1. 配置应用程序Log文件大小

Set-SPAccessServiceApplication –Identity "Access Services"–ApplicationLogSize 5

2. 配置缓存超时时间

Set-SPAccessServiceApplication –Identity "Access Services"–CacheTimeout 600

3. 设置查询中的最大栏数

Set-SPAccessServiceApplication –Identity "Access Services"–ColumnsMax 20

4. 设置查询中的最大计算栏数

Set-SPAccessServiceApplication –Identity "Access Services"–OutputCalculatedColumnsMax 5

5. 设置子句中Order By的最大数

Set-SPAccessServiceApplication –Identity "Access Services"–OrderByMax 2

6. 配置查询中的最大行数

Set-SPAccessServiceApplication –Identity "Access Services"–RowsMax 10

7. 配置Access表中的最大记录数

Set-SPAccessServiceApplication –Identity "Access Services"–RecordsInTableMax 100

8. 配置查询中的最大源数

Set-SPAccessServiceApplication –Identity "Access Services"–SourcesMax 8

9. 配置是否启用外连接

Set-SPAccessServiceApplication –Identity "Access Services"–OuterJoinsAllowed:$false

10. 允许或限制非远程查询

Set-SPAccessServiceApplication –Identity "Access Services"–NonRemotableQueriesAllowed:$true

11. 限制Access Service内存利用率

Set-SPAccessServiceApplication –Identity "Access Services"–PrivateBytesMax 1024

12. 限制会话内存利用率

Set-SPAccessServiceApplication –Identity "Access Services"–SessionMemoryMax 50

13. 配置用户会话

Set-SPAccessServiceApplication –Identity "Access Services"–SessionsPerUserMax 5 –SessionsPerAnonymousUserMax 5

14. 限制模板大小

Set-SPAccessServiceApplication –Identity "Access Services"–TemplateSizeMax 20