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:$true11. 限制Access Service内存利用率
Set-SPAccessServiceApplication –Identity "Access Services" –PrivateBytesMax 102412. 限制会话内存利用率
Set-SPAccessServiceApplication –Identity "Access Services" –SessionMemoryMax 5013. 配置用户会话
Set-SPAccessServiceApplication –Identity "Access Services" –SessionsPerUserMax 5 –SessionsPerAnonymousUserMax 514. 限制模板大小
Set-SPAccessServiceApplication –Identity "Access Services" –TemplateSizeMax 20