可学答题网 > 问答 > MCTS(70-432)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You work in a com


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?()

  • AYou should recapture the workload by using the data collector.
  • BYou should enable the XP_MSVER stored procedure on the local server.
  • CYou should enable the XP_MSVER stored procedure on the remote server
  • DYou should recapture the workload to a trace file by using SQL Profiler.
参考答案
参考解析:
分类:MCTS(70-432)题库