SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.


Once I understood that the issue was TokenAndPermUserStore bloat, the… Read more

0 comments, 816 reads

Posted in Adventures in SQL on 25 March 2010

My Adventures with the SQL 2005 Security Cache


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, 460 reads

Posted in Adventures in SQL on 9 March 2010