PrepAway - Latest Free Exam Questions & Answers

which dynamic management view should you use?

You are the administrator of your company network. You are in charge of checking the performance of a SQL Server 2008 instance. Now you have to identify the longest-running common language runtime (CLR) queries. So which dynamic management view should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
sys.dm_exec_sessions

B.
sys.dm_os_wait_stats

C.
sys.dm_exec_requests

D.
sys.dm_exec_query_stats


Leave a Reply