Microsoft (MOC) Courses > MOC 2790: Troubleshooting and Optimising SQL Server 2005

MOC 2790: Troubleshooting and Optimising SQL Server 2005


MOC 2790: Troubleshooting and Optimising SQL Server 2005

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


    • Single User CD Course
    £ 298
    Single User Online Course
    £ 238
    Multi User CD Course
    £ 596

    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.

    Course Outline


    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
    Page Execution time is 5.203 seconds.