题目内容

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.

查看答案
更多问题

咨询关系独特性的含义是()

A. 咨询关系不同于朋友关系
B. 咨询关系不同于医患关系
C. 咨询关系不同于师生关系
D. 咨询关系永远指咨询师与目前这位来访者之间的关系

压力容器作业人员证每()复审一次。

A. 2年
B. 4年
C. 6年
D. 每年

混凝土受压破坏通常是内部产生的压应力大于其极限压应力而发生的。

A. 正确
B. 错误

借款人应当按照()的还款方式、还款计划偿还住房公积金贷款本息。

答案查题题库