Tracking Processes in SQL Server

Which command will provide the total CPU time and total amount of disk reads and writes for a process?

Choose your answer:

Sp_who sp_who2 sp_processdetails Both A and B Both A and C All of the above None of the above

I selected 'Both A and B' and were wrong.

Correct answer:	sp_who2
Explanation:	By executing sp_who2 we can get the detail of the process. sp_who does not include that information. Ref: http://social.msdn.microsoft.com/Forums/en/transactsql/thread/aa06e533-ef6a-494a-9f9b-df3b29b73d85