Subscribe to this blog
Archives: March 2010
Managing the Size of the Security Cache (TokenAndPermUserStore) in SQL 2005
Introduction
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.
Triage
Once I understood that the issue was TokenAndPermUserStore bloat, the… Read more
0 comments, 247 reads
Posted in Adventures in SQL on 25 March 2010
My Adventures with the SQL 2005 Security Cache
Introduction
For that past couple of months I have been chasing performance issues with one of the most high profile servers I support. Yes, I said months and high profile. Typically the pressure to find a quick fix would be immense, but luckily we have a strong team working the… Read more
0 comments, 66 reads
Posted in Adventures in SQL on 9 March 2010