Microsoft
70-450 · Question #149
70-450 Question #149: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #149. The question stem and answer options stay visible for context.
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'
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.