access-check-cache-server-configuration-options.md

title	access check cache Server Configuration Options | Microsoft Docs
ms.custom
ms.date	03/02/2017
ms.prod	sql
ms.prod_service	high-availability
ms.reviewer
ms.suite	sql
ms.technology	configuration
ms.tgt_pltfrm
ms.topic	conceptual
helpviewer_keywords	access check cache option
ms.assetid	0a992ea8-3ec6-4a4d-97b5-460ae7326247
caps.latest.revision	9
author	MikeRayMSFT
ms.author	mikeray
manager	craigg

access check cache Server Configuration Options

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

When database objects are accessed by [!INCLUDEssNoVersion], 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 [!INCLUDEssNoVersion] is managing these options. Microsoft recommends only changing these options when directed by Microsoft Customer Support Services.

See Also

Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)