“访问检查缓存”服务器配置选项access check cache Server Configuration Options

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

通过 SQL ServerSQL Server访问数据库对象时,访问检查缓存在一个名为 访问检查结果缓存的内部结构中。When database objects are accessed by SQL ServerSQL Server, the access check is cached in an internal structure called the access check result cache. access check cache quotaaccess check cache bucket count 选项控制用于 访问检查结果缓存的项数和哈希存储桶数。The access check cache quota and access check cache bucket count options control the number of entries and number of hash buckets used for access check result cache. 在极少数情况下,可以通过更改这些选项来提高性能。In rare circumstances, performance can be improved by changing these options.

默认值 0 表示 SQL ServerSQL Server 正在管理这些选项。The default values of 0 indicates that SQL ServerSQL Server is managing these options. Microsoft 建议仅在有 Microsoft 客户支持服务部门提供指导的情况下才更改这些选项。Microsoft recommends only changing these options when directed by Microsoft Customer Support Services.

另请参阅See Also

服务器配置选项 (SQL Server) Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)sp_configure (Transact-SQL)