SQL 2005: Procedure cache cleared
I don’t normally write about a technet article but i must say that 917828 caught my eye and i felt that it was worth highlighting it.
The reason it caught my eye is that it describes a number of scenarios where by the whole procedure cache is flushed which will clearly lead to a decrease in query performance whilst the cache builds up again. The most alarming point was that there are at least 2 scenarios that a DBA may carry out and even schedule during core production hours without realising the impact until the users start complaining about the mysterious slow downs…..
These are
- Deleting a database snapshot.
- Restoring a database backup.
I’d recommend reading the article as there are 5 other situations in which this occurs that may affect you.
Categories: Performance, SQL Server
Comments (0)
Trackbacks (0)
Leave a comment
Trackback