MOC-2790: Troubleshooting and Optimizing Database Servers Using MS SQL Server 2005 Training

MOC 2790: Troubleshooting and Optimising Microsoft SQL Server 2005 Training Package Includes

• 6 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
• Printable courseware
• Step-by-step hands-on-labs
• Comprehensive, understandable, and reusable as reference material
• Microsoft Authorized MeasureUp Exam Simulation
• Focused on practical solutions to real-world development problems

Course Introduction

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft-Certified Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to succeed.

This instructor-led course is desinging 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.

List of Course Features

MOC 2790: Troubleshooting and Optimising Microsoft SQL Server 2005 Course Contents
 

Module 1 - Building a Monitoring Solution for SQL Server Performance Issues

Building a Monitoring Solution for SQL Server Performance Issues
Narrowing a Performance Issue to an Environment Area
Using SQL Server Profiler and System Monitor
Auditing and Comparing Test Results
Module 1 Lab Introduction
Lab Demonstration - Setting Up System Monitor Using Performance Counters
Lab Demonstration - Set Up SQL Server Profiler
Module 1 Review

Module 2 - Troubleshooting Database and Database Server Performance Issues

Troubleshooting Database and Database Server Performance Issues
Narrowing a Performance Issue to a Database Object
Using Server Profiler to Narrow a Search to a Specific Issue
Using SQLDiag to Analyze Outputs
Module 2 Lab Introduction
Lab Demonstration - Compare Trace and Log Files
Lab Demonstration - Query a Trace Table
Module 2 Review

Module 3 - Optimizing the Query Performance Environment

Optimizing the Query Performance Environment
The Methodology for Optimizing a Query Environment
Query Performance Troubleshooting Process
Using the Database Engine Tuning Advisor to Troubleshoot the Query Environment
Module 3 Lab Introduction
Lab Demonstration - Execution Plan
Lab Demonstration - Database Tuning Advisor (DTA)
Module 3 Review

Module 4 - Troubleshooting SQL Server Connectivity Issues

Troubleshooting SQL Server Connectivity Issues
The Methodology for Troubleshooting SQL Server Connectivity Issues
Common Connectivity Issues
SQL Server 2005 Endpoints
Module 4 Lab Introduction
Lab Demonstration - Server Not Found
Lab Demonstration - Authentication Troubleshooting
Lab Demonstration - End Point
Module 4 Review

Module 5 - Troubleshooting SQL Server Data Issues

Troubleshooting SQL Server Data Issues
Troubleshooting Data Integrity Issues
Torn Pages Resolution with Single-Page Restore
Module 5 Lab Introduction
Lab Demonstration - Torn Pages
Lab Demonstration - Data Problem
Module 5 Review

Module 6 - Troubleshooting SQL Server Concurrency Issues

Troubleshooting SQL Server Concurrency Issues
Troubleshooting Concurrency Issues
SQL Server Latches
Module 6 Lab Introduction
Lab Demonstration - Deadlocking Issues
Lab Demonstration - Blocking Issues
Lab Demonstration - Latch Wait Types and Times
Module 6 Review