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

微软认证考试

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

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 infrastructure is managed by you. There is a database in the instance, and the day-to-day business of your company requires the database. When reports are executed, slow response time will be experienced by Users. A performance monitoring strategy will be implemented by you so as to have three aspects of data captured and stored: Blocking and deadlock information,  Executed Transact-SQL statements  Query activity and Counters for disk, CPU, and memory. You are required to utilize the least amount of administrative effort to implement the monitoring process.     Which action will you perform to finish the task?()

  • A、To finish the task, the client-side profiler trace should be utilized. 
  • B、To finish the task, the dynamic management views should be utilized.
  • C、To finish the task, the data collector should be utilized. 
  • D、To finish the task, the System Monitor counter log trace should be utilized.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题