Script to purge TokenAndPermUserStore

  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 + multi_pages_kb) FROM sys.dm_os_memory_clerks WHERE name = ‘TokenAndPermUserStore’   — Greater than 100MB IF @CacheSize >= 100000 BEGIN…

0