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

You are a professional


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

  • AIn a SQL Trace log file, you should look for queries with low duration values and high read and write values.
  • BIn a query execution plan, you should look for queries with missing or out-of-date statistics.
  • CIn a SQL Trace log file, you should look for queries with high duration values and low read and write values.
  • DIn a query execution plan, you should look for queries with a large number of table scans.
参考答案
参考解析:
分类:MCITP(70-447)题库
相关推荐

1、You are a professional

You are a professional level SQL Sever 2008 Database Administrator in an international corporation&e...

2、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

3、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

4、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

5、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

6、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...