Answers to Review Questions
- C. Monitoring the Process(sqlservr) : % Processor Time performance object counter will indicate whether SQL Server 2005 or some other process is consuming your processor resources.
- D. Event notifications can detect the CREATE TABLE T-SQL statements and cannot be rolled back. DDL triggers are not appropriate because they are processed synchronously within the transaction and can be rolled back.
- A, C. The SQL Trace and Performance Logs and Alerts tools will allow you to monitor both the hardware resource and the database activity while impacting the performance of the database solution the least.
- D, F. Both event notifications and WMI event alerts allow you to capture the DEADLOCK_GRAPH events for further analysis. ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
