This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 6%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Today morning, I executed sp_who2 and SQL Server is taking very long time. I tried executing other commands and some queries but they are also taking long time to execute. SQL Server was fine yesterday. I am unable to understand what the resolution is. Could you please help
Additional SQL Server features and topics not covered by specific categories
Answer accepted by question author
Hi Carrin,
No changes were made to SQL Server. DId not get results of sp_who2, ran it for 5 hours. My company does not allow downloads. So, can you please advise how to fix this issue.
Hi @Chaitanya Kiran Buduguru , sorry for the late response, could you try select * From sys.sysprocesses where blocked<>0? Does return faster? And have try to restart the server?
IDid not get results for this command as well. I didnt try restarting because its a production server.
Hi @Chaitanya Kiran Buduguru , I do a lot of research for your issues, there are some solutions need to download store procedures, but you couldn't do it. Here has a similar thread might be help you, please check it.
Hi @Chaitanya Kiran Buduguru ,
Welcome to Microsoft Q&A!
Have you made any changes for your SQL Server? Although sp_who2 take a long time to execute, have you get any results? I recommend that you could use sp_BlitzFirst to help you troubleshoot slow SQL Servers.
Best regards,
Carrin
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi Carrin,
No changes were made to SQL Server. DId not get results of sp_who2, ran it for 5 hours. My company does not allow downloads. So, can you please advise how to fix this issue.
But why SP_WHO2 is executing for a long time, I had to cancel the query.
Hello,
This may occur if your table is not properly indexed,the Database Engine had to search from the Start to End to find the matching values
There are so many factors that may affect the performance. Indexing is the primary one.
Check This Link for more performance-tuning