Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

access check cache Server Configuration Options

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

When database objects are accessed by SQL Server, the access check is cached in an internal structure called the 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.

The default values of 0 indicates that SQL Server is managing these options. Microsoft recommends only changing these options when directed by Microsoft Customer Support Services.

Community Additions

ADD
Show:
© 2015 Microsoft