Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.
Question: Where is Table Variable Created?
Answer: On Hard Disk and NOT in Memory.
I suggest you read the following blogs
I have received an interesting email from a client of Comprehensive Database Performance Health Check. His question was related to files with IO Issues.
We started working with my Comprehensive Database Performance Health Check service and found very interesting details from the server cache.
One of the most popular questions I receive during my Comprehensive Database Performance Health Check is a difference between status in sp_who2 which discusses status as Running, Pending, Runnable, Suspended. Let us today understand them with regards to CPU.