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.
Recent Execution of Stored Procedure – SQL in Sixty Seconds #118
My clients were not sure which SPs are the recent SP and which SP is no longer used. Today we will learn about the recent execution of the stored procedure.
SQL SERVER – Not Auto-Updating Statistics with STATISTICS_NORECOMPUTE
After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE.
SQL SERVER – List All Active Background Jobs
During Comprehensive Database Performance Health Check, we had an issue where lots of active background jobs consuming lots of important resources.