|
Outline:
Lesson 1: Building a Monitoring Solution for SQL Server Performance Issues
Narrowing Down a Performance Issue to an Environment Area.
Guidelines for Monitoring Database Servers and Instances by Using Profiler and Sysmon.
Guidelines for Auditing and Comparing Test Results.
Lesson 2: Troubleshooting Database and Database Server Performance Issues
Narrowing Down a Performance Issue to a Database Object.
How the SQLdiag Tool Can Be Used to Analyze Outputs.
Lesson 3: Optimizing the Query Performance Environment
The Methodology of Optimizing a Query Environment.
The Query Performance Troubleshooting Process.
Use of Database Tuning Advisor to Troubleshoot the Query Environment.
Lesson 4: Troubleshooting SQL Server Connectivity Issues
The Methodology of Troubleshooting SQL Server Connectivity Issues.
Areas to Troubleshoot for Common Connectivity Issues.
What Are SQL Server 2005 Endpoints?
Lesson 5: Troubleshooting SQL Server Data Issues
The Methodology of Troubleshooting SQL Server Data Issues.
The Process of Troubleshooting Data Integrity Issues.
How Torn Pages Can Be Resolved using a Single-Page Restore.
Lesson 6: Troubleshooting SQL Server Data Concurrency Issues
The Methodology of Troubleshooting Concurrency Issues.
What Are SQL Server Latches? |