Blog is a collection of misc troubleshooting tips collected while supporting Microsoft SQL Server 2000 2005 and 2008 customers.
Forcus area covered include SSIS, Performance, and Replication
Browse by Tags
All Tags »
TokenAndPermUserStore (RSS)
Sorry, but there are no more tags available to filter with.
-
Here is a script that purge the 'TokenAndPermUserStore' every time it reaches 100MB. DECLARE @CacheSize int DECLARE @CurDate varchar ( 30 ) WHILE ( 1 = 1 ) BEGIN SET @CurDate = CONVERT ( varchar , GETDATE (), 126 ) SELECT @CacheSize = SUM ( single_pages_kb Read More...
|
