Tag Archives: sp_updatestats

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