SQL Server Process

Great Monty 2016-10-03 12:55:05

,alt text


Please note that I am inserting 50 million records in one of my test table, though process is going on why it is displaying that process as status – SUSPENDED (check the image attached) in sp_who2.
Any reason behind this? it should be running.

Vlady Oselsky 2016-10-03 19:42:08
Do you know what SUSPENDED really means? Read the following article, you might be surprised https://blogs.msdn.microsoft.com/sqlsakthi/2011/02/08/different-status-of-a-spid-in-sql-server-and-what-do-they-mean/
In addition to that sp_who2 is not supported and you should use something like sp_whoisactive or script from Glen Berry to see what is happening to your query and what resources it is waiting for.
Great Monty 2016-10-05 11:00:58
Thank you Viady.