• SharePoint Access Service-PowerShell


    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
    
  • 相关阅读:
    memmove 的实现
    [转]SGI STL 红黑树(Red-Black Tree)源代码分析
    [转]让我看了很有感触
    [转]C++ list 类学习笔记
    [转]码农自白:这样成为谷歌工程师
    [转]Traits 编程技法+模板偏特化+template参数推导+内嵌型别编程技巧
    泛型指针,原生指针和智能指针
    [转]C++基本功和 Design Pattern系列 ctor & dtor
    python+opencv滤波操作
    python+opencv阈值
  • 原文地址:https://www.cnblogs.com/justinliu/p/5961709.html
Copyright © 2020-2023  润新知