-
Big Security Token cache affects performance of Sql Server 2005
I recently came across a Sql Server performance problem. It was caused by TokenAndPermUserStore taking too much of cache. Server specifications: Windows 2003 R2 SP2 Enterprise b4-bit, Sql Server 2005 Enterprise 64-bit SP2, 2 Quad-Core Dell server with 32 gig of memory Symptoms that I have experienced: 1. Over time, the application got timeout messages.…