單項(xiàng)選擇題

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

你可能感興趣的試題

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. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.
These features will be discontinued. What should you do？（）

A.The SQL Server 2008 Upgrade Advisor should be used.
B.The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used.
C.A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used
D.A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.

單項(xiàng)選擇題

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 remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance.
So what action should you perform to achieve this goal？（）

A.You should recapture the workload by using the data collector.
B.You should enable the XP_MSVER stored procedure on the local server.
C.You should enable the XP_MSVER stored procedure on the remote server
D.You should recapture the workload to a trace file by using SQL Profiler.