One of my clients asked me a follow-up question in the Comprehensive Database Performance Health Check. The question was about sp_Who2 parameters.
There are so many different statuses of the processes in SQL Server. Let us learn today the difference between Sleeping vs Suspended Process.
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.
After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE.