|
|
 |
Microsoft SQL Server 2005
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (2790)
|
|
|
Who Should Attend
| This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment. |
Prerequisites
| Participants must have working knowledge of SQL Server 2005 architecture, have basic monitoring and troubleshooting skills, and have working knowledge of the operating system and platform. Participants should have a basic knowledge of server and application architecture, understand Transact-SQL syntax and programming logic, and have basic knowledge of Microsoft Windows networking. Students should also be familiar with SQL Server 2005 features, tools and technologies, and should have acquired a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential, or equivalent experience. |
Course Objectives
| The purpose of this course is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of the course 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 Content
| 1. Building a Monitoring Solution for SQL Server Performance Issues
|
| 2. Troubleshooting Database and Database Server Performance Issues
|
| 3. Optimizing the Query Performance Environment
|
| 4. Troubleshooting SQL Server Connectivity Issues
|
| 5. Troubleshooting SQL Server Data IssuesTroubleshooting SQL Server Data Concurrency Issues |
Dates Europe
To book a course, please click on the required city name.
Germany
|
|
|
|
Munich