Microsoft
70-432 · Question #42
You are the administrator of a SQL Server 2008 instance. Your company CIO assigns you a task. You have to check the performance of the SQL Server 2008 instance. You have to find out which common…
Sign in or unlock 70-432 to reveal the answer and full explanation for question #42. The question stem and answer options stay visible for context.
Question
You are the administrator of a SQL Server 2008 instance. Your company CIO assigns you a task. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time. Which dynamic management view should you choose to use?
Options
- Asys.dm_os_wait_stats
- Bsys.dm_exec_requests
- Csys.dm_exec_sessions
- Dsys.dm_exec_query_stats
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 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.