Do you know the difference between the various status of the processes? I was asked about this from my client of Comprehensive Database Performance Health Check. There are so many different statuses of the processes in SQL Server and it is important for us to know that. Let us learn today the difference between Sleeping vs Suspended Process.
In this quick video, we will learn what each of the statuses means i.e. Pending, Runnable, Running, Suspended, Sleeping, Dormant, Background, Spinlock.
Here is the supporting blog post about the sleeping session discussed in the video SQL SERVER – Script to Kill All Inactive Sessions – Kill Sleeping Sessions from sp_who2. Please note that do you use this script without properly understanding its impact. It is very different to remove the suspended process vs sleeping process.
If you like the video, please do not forget to subscribe to my youtube channel. Let me know if you have any other SSMS tip which you think help the larger community.
Here are a few associated blog posts which you may find interesting.
- Activity Monitor and Running Query – SQL in Sixty Seconds #115
- Email an Execution Plan – SQL in Sixty Seconds #114
- Execution Plan – Estimated vs Actual – SQL in Sixty Seconds #113
- What Happens If the Clustered Index is Disabled? – Interview Question of the Week #291
Reference: Pinal Dave (https://blog.sqlauthority.com)