Note: You are viewing a Preliminary Course Syllabus. This course
is not yet available. Because some parts of the course are currently in
development, some elements of this syllabus are subject to change.
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 Server 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.
Prerequisites
Before attending this course, students
must have met at least one of the following
·
Have working knowledge of
SQL Server 2005 architecture. Such as indexing, SQL execution plans, SQL
Server basic configuration, etc.
·
Have basic monitoring and
troubleshooting skills. For example, students should have used Sysmon
and Perfmon on the job.
·
Have working knowledge of
the operating system and platform. That is, the operating system
integrates with the database, what the platform or operating system can
do, and the interaction between the operating system and the database.
·
Have a basic understanding
of server architecture. For example, CPU and memory utilization and disk
input/output (I/O).
·
Have basic knowledge of
application architecture. That is, how applications can be designed in
three layers, what applications can do, interaction between applications
and the database, and the interaction between database and the platform
or operating system.
·
Understand Transact-SQL
syntax and programming logic.
·
Have basic knowledge of
Microsoft windows networking. That is, understand how Domain Name
Service (DNS) operates and how servers communicate between domains.
·
Be familiar with SQL Server
2005 features, tools, and technologies
·
Have a Microsoft Certified
Technology Specialist: Microsoft SQL Server 2005 credential – or
equivalent experience.
In addition, it is recommended, but not
required, that students have completed:
·
Course 2278, Writing
Queries Using Microsoft SQL Server 2005 Transact-SQL.
·
Course 2779, Implementing a
Microsoft SQL Server 2005 Database.
·
Course 2780, Maintaining a
Microsoft SQL Server 2005 Database.
Skills Gained
At the end of the course, students will
be able to:
·
Build a monitoring solution
for SQL Server performance issues.
·
Troubleshoot database and
database server performance issues.
·
Optimize the query
performance environment.
·
Troubleshoot SQL Server
Connectivity Issues
·
Troubleshoot SQL Server
Data Issues
·
Troubleshoot SQL Server
data concurrency issues
