SharePoint Access Service-PowerShell-优快云博客

本文详细介绍了如何配置Access服务应用的关键参数，包括日志文件大小、缓存超时时间、查询最大栏数等，旨在优化应用性能和用户体验。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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