存取檢查快取伺服器組態選項access check cache Server Configuration Options

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

當資料庫物件是由 SQL ServerSQL Server所存取時,存取檢查會在稱為 access check result cache的內部結構中進行快取。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 選項會控制用於 access check result cache的項目數和雜湊值區數。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)