One of the most popular questions I received during my Comprehensive Database Performance Health Check is Finding Queries Using Particular Index.
SQL SERVER – 3 Queries to Detect Memory Issues
One of the most popular conversations during Comprehensive Database Performance Health Check is about CPU and memory issues.
SQL SERVER – Cached Data Per Object in Memory
“How to build a list of cached data per object in memory pool?” I just received this question from my client who hired me for Health Check.
SQL SERVER – List Tables with Size and Row Counts
Today we will see a very simple script that lists table names with the size of the table and along with that row counts. Let us learn it in today.
SQL SERVER – sp_who2 Parameters
One of my clients asked me a follow-up question in the Comprehensive Database Performance Health Check. The question was about sp_Who2 parameters.
SQL SERVER – Inserting sp_who2 Into a Table
I should also have included the script for method 1 discussed in the blog post. Let us learn a method of inserting sp_who2 into a table.
SQL SERVER – Representing sp_who2 with DMVs
During the recent Performance Check, I had a very interesting situation where my client wanted to capture the details of the sp_who2 in a table with DMVs.