Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Please differentiate these sql statement
September 16, 2010
what are all the difference between SP_Who and Sp_Who2?
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.
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.
To post reply
Related Questions Related Questions
What is foreach Statement
Can we use Case Statement in Update Query?
C# break and continue statement
Oracle CASE When statement
How do we use CASE WHEN statement in ms access query and please give me sample?
CASE WHEN Statement in MS Access query
Insert Statement doesn''t works from a web application
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend