题目内容

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform?()

A. In a SQL Trace log file, you should look for queries with low duration values and high read and write values.
B. In a query execution plan, you should look for queries with missing or out-of-date statistics.
C. In a SQL Trace log file, you should look for queries with high duration values and low read and write values.
D. In a query execution plan, you should look for queries with a large number of table scans.

查看答案
更多问题

网络规模估算是分别按照()和()计算,获得网络的建设规模,然后取()作为实际所需的基站个数。

涉及两个以上单位的配合操作或需要根据前一项操作后对电网产生的影响才能决定下一项操作的,必须使用()。

肝脾淤血是运动性腹痛的一个原因。

A. 正确
B. 错误

质量管理中需要关注几个阶段的问题()

A. 3个阶段
B. 4个阶段
C. 5个阶段
D. 2个阶段

答案查题题库