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? |
|
Answers
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. |