September 30, 2014

What is the Difference b/w SP_WHO n SP_WHO2 in SQL

1.SP_who2 shows one extra column that is RAM utilization than SP_WHO.

2.SP_who2 has these extra columns 
a. CPU Time
b. Disk IO
c. Last Batch
d. Program Name , apart from that SP_who is documented and Sp_who2 is not documented in BOL.

No comments:

Post a Comment