MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

1. 

How can SQL Server Profiler help you to troubleshoot database applications?

2. 

What other system tool can be used to troubleshoot database applications?

3. 

What new feature in SQL Server 2005 allows you to return information about the health of your SQL Server?

1. 

SQL Server Profiler can help you by allowing you to record a trace in which specific SQL Server events are monitored and recorded. This information can be invaluable when determining the cause of a specific problem, such as a server slowdown.

2. 

Windows System Monitor is the tool that allows you to graphically monitor performance counters that are associated with server objects in real time.

3. 

Dynamic management view (DMV) can be included in a SELECT statement to expose statistical information as a result set. There are dozens of them available; they all start with the "dm_" prefix.