题目内容

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.

查看答案
更多问题

合成毒品心理依赖比较显著。

A. 正确
B. 错误

什么情况属于三级市场转移登记?

保护主义与国际自由贸易的保护措施?

《2010通则》中的11个贸易术语,买方承担责任最大的是EXW,最小的是DDU。()

A. 正确
B. 错误

答案查题题库