Search on keywords

 


This set of training videos 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.

Price: $395

 
Meet The Certified Instructor:

a

Mark Russell - SQL 2005 Trainer (MCT, MCDBA, MCSD.NET, MCSE Security, CEH, Security+)

Mark Russell has over twenty years total networking and programming experience with a current focus enterprise database development and training using Microsoft SQL Server tools and technologies. Mark is a Certified Technical Trainer. He has taught over 500 Desktop Applications classes and over 500 Technical classes. Mark has completed Microsoft approved Train-the Trainer Program. He was named Instructor of the Year in 1999 with New Horizons Worldwide. As a Microsoft Certified Trainer, Mark has maintained an overall class (Instructor score) average of 9.62 on a 10 scale.

a
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