Today, we will see a very interesting script to list database file latency. I use this script quite often in my Performance Health Check.
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.