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
答案解析:有
微信扫一扫手机做题