Category Archives: Security Cache

Managing the Size of the Security Cache (TokenAndPermUserStore) in SQL 2005

Posted on March 24, 2010 by David Levy

In an earlier post I walked through the diagnosis of a problem with TokenAndPermUserStore bloat in SQL 2005. In this post I will go through what I did to work through the issues and the results of those efforts. Continue reading →

Posted in Security Cache | Tagged , , , | 1 Comment

My Adventures with the SQL 2005 Security Cache

Posted on March 9, 2010 by David Levy

This post describes the process of diagnosing a lesser known performance issue in SQL 2005 and higher on servers with a lot of physical memory. The performance issue is caused by security cache bloat and is very difficult to miss unless you know what you are looking for. Continue reading →

Posted in Security Cache | Tagged , , , | 3 Comments