-
-
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.