Troubleshooting and Optimizing Database Server Using Microsoft SQL Server 2005
Short course
In London
Description
-
Type
Short course
-
Location
London
The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes establishing monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.
Facilities
Location
Start date
Start date
Reviews
Course programme
Lessons
- 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
- Determining Which Indicators to Monitor
- Implementing a Monitoring Solution
- Auditing Monitoring Results to Identify Problem Areas
- Explain the methodology of narrowing down a performance issue to a particular database environment area
- Apply the guidelines for monitoring database servers and instances by using Profiler and Sysmon
- Apply the guidelines for auditing and comparing test results
- Determine which indicators to monitor
- Implement a monitoring solution
- Audit monitoring results to identify problem areas
Lessons
- Narrowing Down a Performance Issue to a Database Object
- How Profiler Can Help Narrow a Search to a Specific Issue
- How the SQLdiag Tool Can Be Used to Analyze Outputs
- Analyzing Sysmon and Profiler Traces
- Analyzing a Profiler Trace by UsingSQLServer Queries
- Determining Database Server Issues by Using SQLdiag.exe
- Explain the methodology of narrowing down a performance issue to a particular database environment object
- Explain the use of SQLdiag tool to analyze outputs
- Explain the use of Profiler to narrow a troubleshooting search to a specific issue
- Analyze Sysmon and Profiler traces
- Analyze Profiler traces usingSQLServer queries
- Determine performance issues by using SQLdiag.exe
Lessons
- The Methodology of Optimizing a Query Environment
- The Query Performance Troubleshooting Process
- Reviewing an Execution Plan for Clues to Poor Performance
- Performing Index Analysis by Using the Database Tuning Advisor (DTA)
- Explain the methodology of optimizing the query environment
- Describe the query performance troubleshooting process
- Explain how Database Tuning Advisor can be used to troubleshoot the query environment
- Review an execution plan for clues to poor performance
- Perform index analysis by usingDTA.
Lessons
- The Methodology of TroubleshootingSQLServer Connectivity Issues.
- Areas to Troubleshoot for Common Connectivity Issues.
- What AreSQLServer 2005 Endpoints?
- Troubleshooting Server-Not-Found Issues.
- Troubleshooting an Authentication Error Message.
- Troubleshooting Endpoint Issues.
- Explain the methodology of troubleshooting connectivity issues
- Describe the areas to audit for common connectivity issues
- Explain theSQLServer 2005 endpoints
- Troubleshoot Server-Not-Found issues
- Troubleshoot an authentication error message
- Troubleshoot endpoint issues
Lessons
- The Methodology of TroubleshootingSQLServer Data Issues
- The Process of Troubleshooting Data Integrity Issues
- How Torn Pages Can be Resolved Using a Single-Page Restore
- Troubleshooting and Repairing Torn Pages
- Troubleshooting a Data Issue
- Explain the methodology of troubleshooting data issues
- Explain the process of troubleshooting data integrity issues
- Explain how torn pages can be resolved using a single-page restore
- Troubleshoot and repair torn pages
- Troubleshoot data integrity issues
Lessons
- The Methodology of Troubleshooting Concurrency Issues
- What AreSQLServer Latches?
- Activity: Choosing a Blocking Monitoring Solution
- Identifying the Objects Involved in a Deadlock
- Identifying the Objects Involved in a Blocking Issue
- Determining Concurrency Issues by Using Latch Wait Types
- Explain the methodology of troubleshooting concurrency issues
- Explain what latches are and how they can be useful in troubleshooting long wait times
- Choose a blocking monitoring solution
- Identify the objects involved in a deadlock issue
- Identify the objects involved in a blocking issue
- Determine concurrency issues by using latch wait types
Troubleshooting and Optimizing Database Server Using Microsoft SQL Server 2005