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…
The correct answer is D. sys.dm_exec_query_stats. See the full explanation below for the reasoning.
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
How the community answered
(25 responses)- A8% (2)
- B16% (4)
- C4% (1)
- D72% (18)
Community Discussion
No community discussion yet for this question.