Course Ref: 42167
Course: MS2790 Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
Course Summary
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 ServerT 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes learning how to establish monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.
Course Outline
Modules include:
By the end of the course, delegates should be:
- Building a Monitoring Solution for SQL Server Performance Issues
- Troubleshooting Database and Database Server Performance Issues
- Optimizing the Query Performance Environment
- Troubleshooting SQL Server Connectivity Issues
- Troubleshooting SQL Server Data Issues
- Troubleshooting SQL Server Data Concurrency Issues
By the end of the course, delegates should be:
- Building a Monitoring Solution for SQL Server Performance Issues
- Troubleshooting Database and Database Server Performance Issues
- Optimizing the Query Performance Environment
- Troubleshooting SQL Server Connectivity Issues
- Troubleshooting SQL Server Data Issues
- Troubleshooting SQL Server Data Concurrency Issues
Where & When
| Location | Wokingham |
|---|---|
| Start Date | 19 Mar 09 |
| Price (ex. VAT) | £445.00 |
| Venue Info | Wokingham - Mulberry Business Park |
| Residential | No |
| Availability | Spaces |
| Duration | 2 days |
| Delivered As | Venue and on-site |
| Pre-course Reading | |
| No precourse reading si specified. | |
| Exam Included | No |
| Course Ref | 42167 |
