DBCC FREESYSTEMCACHE ('TokenAndPermUserStore')
- This issue does not occur if you enable only the C2 audit tracing in SQL Server 2008 R2 or in SQL Server 2008.
- You can run the following query to find the size of the TokenAndPermUserStore cache store:
select name,single_pages_kb,multi_pages_kb from sys.dm_os_memory_clerks
where type = 'USERSTORE_TOKENPERM' and single_pages_kb+multi_pages_kb > 8
order by single_pages_kb+multi_pages_kb desc
Note This memory allocation cannot be freed when you run the DBCC FREESYSTEMCACHE command.
Cumulative update information
The fix for this issue was first released in Cumulative Update 3. For more information about how to obtain this cumulative update package for SQL Server 2008 R2, click the following article number to view the article in the Microsoft Knowledge Base:
Resolution for SQL Server 2008The resolution for SQL Server 2008 is included in SQL Server 2008 Service Pack 2. For more information about the list of the bugs that are fixed in SQL Server 2008 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
|Rule software||Rule title||Rule description||Product versions against which the rule is evaluated|
|System Center Advisor||SQL Server missing update KB2277078 to prevent leak of security audit entries in TokenAndPermUserStore||System Center Advisor determines whether this instance of SQL Server contains any defined audits and whether this fix is applied. If the current build version of SQL Server is earlier than the fix build version, the advisor generates an alert about this issue. Review the details that are provided in the “Information Collected” section of the advisor alert, and apply the fix that is discussed in this article.||SQL Server 2008|
SQL Server 2008 R2
For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
Article ID: 2277078 - Last Review: Oct 28, 2011 - Revision: 1