|
|
Overview
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 establishing monitoring standards and baselines, determining
performance thresholds, and focusing the investigation on specific
issues.
Audience
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
Before attending this course, students must:
• Working knowledge of SQL Server 2005 architecture including indexing,
SQL execution plans, and SQL
Server basic configuration.
• Basic monitoring and troubleshooting skills. For example, students
should have used Sysmon and Perfmon on
the job.
• Working knowledge of the operating system and platform. Students
should understand how 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.
• Basic understanding of server architecture such as CPU and memory
utilization and disk input/output (I/O).
• Basic knowledge of application architecture. Students should know how
applications can be designed in
three layers, what applications can do, the interaction between
applications and the database, and the
interaction between the database and the platform or operating system.
• Understanding of Transact-SQL syntax and programming logic.
• Basic knowledge of Microsoft Windows networking. Students should
understand how Domain Name Service
(DNS) operates and how servers communicate between domains.
• Familiarity with SQL Server 2005 features, tools, and technologies.
• Microsoft Certified Technology Specialist: Microsoft SQL Server 2005
credential or equivalent experience.
Exam
Exam 70-444: PRO: Optimizing and Maintaining a Database Administration
Solution by Using Microsoft SQL Server 2005
|
|
Choose below for more information |
|
Hands
on Training |
Optimizing and Maintaining DBA SQL Server 2005
16 Hours
Course NW304
Course Outline
Register Today
Approved for
VA Benefits and G.I.Bills
Earn
College Credits Call for details
Request On-Site Training Proposal
|
