Microsoft
70-450 · Question #149
Your manager is testing your experience of SQL Server 2008 and stored procedures. He wants you to show him which active users are connected to the server, which tasks they are performing and also…
The correct answer is A. sp_who2 `active'. Only the sp_who2 command used in conjunction with `active' will show you active connections and also disk IO usage
Design and implement an optimized monitoring strategy
Question
Your manager is testing your experience of SQL Server 2008 and stored procedures. He wants you to show him which active users are connected to the server, which tasks they are performing and also disk IO usage. However, you can't use the Activity Monitor window in SMSS. Which sp should you use?
Options
- Asp_who2 `active'
- Bsp_who2 55
- Csp_who
- Dsp_who `active'
How the community answered
(34 responses)- A79% (27)
- B6% (2)
- C3% (1)
- D12% (4)
Explanation
Only the sp_who2 command used in conjunction with `active' will show you active connections and also disk IO usage
Topics
#sp_who2#active connections#disk IO monitoring#performance monitoring
Community Discussion
No community discussion yet for this question.