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?

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?

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 0

Your email address will not be published. Required fields are marked *