“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.
Slow Running Query – SQL in Sixty Seconds #146
One of the most popular questions I receive during Comprehensive Database Performance Health Check is if I have a script that lists Slow Running Query.
Sleeping vs Suspended Process – SQL in Sixty Seconds #122
There are so many different statuses of the processes in SQL Server. Let us learn today the difference between Sleeping vs Suspended Process.