You work in a&en_睦霖题库

单项选择题 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.

热门试题