Troubleshooting and Optimizing Database Servers Using Microsoft® SQL Server™ 2005

This workshop is part of a collection of workshops that teaches IT Professionals working in enterprise environments to troubleshoot and optimize database servers. This includes monitoring, troubleshooting, and optimizing databases and database servers.This online learning workshop is comprised of a rich multimedia experience coupled with comprehensive technical labs.

Workshop 2980: Building a Monitoring Solution for Microsoft® SQL Server™ 2005 Performance Issues

Description:
In this workshop, you perform the initial stages of troubleshooting Microsoft SQL Server 2005 where you narrow down an issue to a particular database environment area, such as CPU, memory, disk I/O, or query design.

In addition, you apply guidelines for monitoring database servers and instances by using Profiler and Sysmon.

This workshop also helps prepare you for certification exam 70-444.

Objectives:
At the end of the course, students will be able to:
Define the monitoring standards for database servers and instances.
Implement the monitoring standards for database servers and instances to identify problem areas.
 
Workshop 2981: Troubleshooting Microsoft® SQL Server™ 2005 Performance Issues

Description:
In this workshop, you troubleshoot Microsoft SQL Server 2005 performance by analyzing the data captured through a monitoring solution. You then use this analysis to narrow down the performance issue to a specific database environment object.
In addition, you automatically synchronize Sysmon logs and Profiler traces, and utilize the SQLDiag tool.
This workshop also helps prepare you for certification exam 70-444.

Objectives:
At the end of the course, students will be able to:
Describe the methodology and tools that are used to determine database and database server performance issues.
Narrow down a troubleshooting search to a specific database object.
 
Workshop 2982: Optimizing the Microsoft® SQL Server™ 2005 Query Performance Environment

Description:
In this workshop, you troubleshoot Microsoft SQL Server 2005 performance issues caused by poorly performing queries. You learn the query troubleshooting process in which you review the query and the query environment to identify performance issues before you implement a suitable solution.
In addition, you utilize the Database Engine Tuning Advisor (DTA) to troubleshoot a query environment.
This workshop also helps prepare you for certification exam 70-444.

Objectives:
At the end of the course, students will be able to:
Optimize the query performance environment.
Troubleshoot the query environment.
 
Workshop 2983: Troubleshooting Microsoft® SQL Server™ 2005 Connectivity Issues

Description:
In this workshop, you troubleshoot Microsoft SQL Server 2005 connectivity issues. You examine the SQL Server environment and network infrastructure to help you troubleshoot the connection problem.
In addition, you explore common connection problems related to Domain Name System (DNS), network authentication, and SQL Server 2005 endpoints.
This workshop also helps prepare you for certification exam 70-444.

Objectives:
At the end of the course, students will be able to:
Describe different types of SQL Server connectivity issues.
Troubleshoot SQL Server connectivity issues.
 
Workshop 2984: Troubleshooting Microsoft® SQL Server™ 2005 Data Issues

Description:
In this workshop, you troubleshoot Microsoft SQL Server 2005 data integrity issues. You use a five step database troubleshooting methodology to identify and resolve torn SQL Server pages by using single-page restore.
In addition, you detect torn pages by using the Page_Verify option.
This workshop also helps prepare you for certification exam 70-444.

Objectives:
At the end of the course, students will be able to:
Describe the methodology of troubleshooting data integrity issues.
Troubleshoot SQL Server data issues.
 
Workshop 2985: Troubleshooting Microsoft® SQL Server™ 2005 Concurrency Issues

Description:
In this workshop, you troubleshoot Microsoft SQL Server 2005 concurrency issues. You use a five step database troubleshooting methodology to identify and resolve concurrency issues that are caused by locking, blocking, and deadlocking.
In addition, you measure and troubleshoot wait times by using SQL Server latches.
This workshop also helps prepare you for certification exam 70-444.

Objectives:
At the end of the course, students will be able to:
Describe the methodology and tools that are used for troubleshooting concurrency issues.
Troubleshoot SQL Server concurrency issues.