Microsoft
70-432 · Question #42
70-432 Question #42: Real Exam Question with Answer & Explanation
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
Community Discussion
No community discussion yet for this question.