多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题