Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, 440 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, 178 reads

Posted in Adventures in SQL on 9 March 2010