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?()
- Asys.dm_os_wait_stats
- Bsys.dm_exec_requests
- Csys.dm_exec_sessions
- Dsys.dm_exec_query_stat