.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Please differentiate these sql statement

Posted By: Deco     Posted Date: September 16, 2010    Points:2   Category :Sql Server
what are all the difference between SP_Who and Sp_Who2?

Author: Rajshree             
Posted Date: September 17, 2010     Points: 5   

SP_Who2: The usage of sp_who2 is to diagnose system slowdowns

SP_Who: Provides information about current Microsoft® SQL ServerT users and processes. The information returned can be filtered to return only those processes that are not idle.

Author: Akhil Raj       [Moderator]      
Posted Date: September 18, 2010     Points: 5   

sp_who2 is an Undocumented/Upgraded extension of sp_who.

This will provide the following options,

1. System process ID.
2. Status of the process.
3. Login name of the user.
4. Name of the user. I
5. f the process is blocked, the SPID of the blocking process.
6. Database the process is using.
7. Command currently being executed.


Along with the above options, sp_who2 will provide the following additional linformations

1. Total CPU time of each process.
2. Total amount of disk reads for each process.
3. Last time a client called a procedure or executed a query.
4. Application connected.

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend