Monthly Archives: March 2010

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

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 , , , | Leave a comment

My Adventures with the SQL 2005 Security Cache

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 , , , | Leave a comment