试题详情
单项选择题 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

  • D
  • 关注下方微信公众号,在线模考后查看

热门试题