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