Which tool or tools should you use?

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
Occasionally, the following problems occur:
-The SQL Server service fails to start. -A query from the application runs slower than
expected.

You need to be able to diagnose each of these problems.
Which tool or tools should you use? (To answer, drag the appropriate problem to the correct
tool in the answer area. Each problem may be used once, more than once, or not at all.
Each tool may be used once or not at all. Additionally, you may need to drag the split bar
between panes or scroll to view content.)

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
Occasionally, the following problems occur:
-The SQL Server service fails to start. -A query from the application runs slower than
expected.

You need to be able to diagnose each of these problems.
Which tool or tools should you use? (To answer, drag the appropriate problem to the correct
tool in the answer area. Each problem may be used once, more than once, or not at all.
Each tool may be used once or not at all. Additionally, you may need to drag the split bar
between panes or scroll to view content.)

Answer:

Explanation:
Note:

Dynamic management views and functions return server state information that can be used
to monitor the health of a server instance, diagnose problems, and tune performance.
Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an
instance of the Database Engine or Analysis Services. You can capture and save data about
each event to a file or table to analyze later. For example, you can monitor a production
environment to see which stored procedures are affecting performance by executing too
slowly.
Database developers and Database Administrators can use Activity Monitor to get a quick
overview of an SQL Server 2008 system performance.
The SQL Server error log contains user-defined events and certain system events. You can
use this error log to troubleshoot problems related to SQL Server.
Incorrect: Reporting Services writes event messages to the Windows application log. You
can use the message information written to the application log to find out about events that
are generated by the report server applications running on the local system.



Leave a Reply 0

Your email address will not be published. Required fields are marked *