多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance should be managed. It is reported by the customers that the server performance degraded due to a newly implemented process. Dynamic Management Views is utilized to confirm that no long running queries exist. The operating system performance data should be correlated with the actual query execution trace, and the least administrative effort should be utilized.  Which action will you perform to finish the task?()

  • A、To finish the task, Data Collector should be utilized.
  • B、To finish the task, the SQLdiag.exe utility should be utilized.
  • C、To finish the task, SQL Server Profiler and the tracerpt.exe utility should be utilized.
  • D、To finish the task, SQL Server Profiler and System Monitor should be utilized.
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题