You work in a&en

题目

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. Now your company CIO assigns a task to you. 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.  So in the options below, which dynamic management view should you choose to use?()  

  • A、sys.dm_os_wait_stats 
  • B、sys.dm_exec_requests 
  • C、sys.dm_exec_sessions 
  • D、sys.dm_exec_query_stats