| |
SQL Server Performance Tuning
Training Class
A four-day
on-site SQL Server DBA Training Course
© 2007 by Burleson Consulting
* Provides a winning performance methodology for
use in analyzing any SQL Server database
* Demonstrates how to uncover serious bottlenecks that exist in your SQL
Server
* Offers insight into how to determine the overall workload of a SQL Server
* Supplies methods for determining how and when to reorganize databases and
objects
* Presents new techniques for monitoring and optimizing memory usage
* Shows how to quickly pinpoint and resolve I/O hotspots at the database
session, and object level
Details strategies on how to successfully use capacity planning for
performance analysis
* Provides new tips and techniques for locating and fixing problem SQL and
procedure code
* Presents improved methods for uncovering session-related bottlenecks
* Provides new tips and techniques for locating and fixing problem SQL
|
|
The primary goal
is this course is to prepare the students to tune complex SQL
Server databases. This SQL Server DBA course is an
intensive 4-day hands-on course is designed to provide SQL Server
professionals with an in-depth understanding of the performance
tuning features of
SQL Server and T-SQL tuning techniques.
Broad in scope,
this course covers all of the SQL Server Database performance tuning
topics including global tuning with SQL Server parameters, SQL
tuning, file & tablespace management, user
administration & security and table & index management.
Hands-on
exercises are used to demonstrate each SQL Server performance tuning feature and the student will
gain first-hand experience in the key SQL Server DBA concepts.
This SQL Server
DBA Training is designed for the practicing Microsoft SQL Server
professionals but it is useful to anyone interested in learning
SQL Server tuning techniques. This includes SQL Server developers,
SQL Server DBAs, SQL Server web developers and any computer professional who
needs to understand how to make their SQL Server database and SQL
run faster. The
course assumes a basic knowledge of computer programming techniques,
relational database concepts, SQL, and basic SQL Server architecture.
|
This SQL Server
training was designed by experienced SQL Server database
administrators with extensive real-world experience.
Learning
Objectives:
The primary
objective of this SQL Server DBA training is to provide each student
with the knowledge and secrets to be successful as a practicing SQL
Server tuning professional. The student will gain confidence in their SQL Server DBA
knowledge and learn the tricks and traps of the SQL Server
performance optimization.
Using a proven
training combination of intense instruction and hands-on practicum the student should have a firm
understanding of SQL Server Database performance tuning concepts.
SQL Server
Performance Tuning Optimization Training Class
SQL Server Certified
Tuning Training Course
Copyright © 2007
by Burleson Consulting
Syllabus
I.
SQL Server
Performance Lifecycle
Management
Database performance isn’t
something to be managed
haphazardly, but instead
should be approached in a
methodical and organized
manner. This is precisely
what Performance Lifecycle
Management or PLM is
designed to provide. This
chapter provides an
introduction to PLM and
covers the basics areas
involved in a successful PLM
implementation.
II. How to Accurately
Measure
SQL Server
Database Performance
Determining the overall
health of a SQL Server
system can be confusing
task, but it doesn’t have to
be. Accurately measuring
database performance can
easily be accomplished once
you understand the basic
components of performance
and how they relate to one
another. This chapter takes
a brief look at performance
modeling and how it can be
applied to any SQL Server
installation.
III. Proactive
Actions that Ensure Optimized
SQL Server
Performance
The foundation of SQL Server
performance isn’t found in
SQL tuning or other such
tasks. Instead, it’s
established during the
initial physical design and
performance testing phases
of the PLM cycle. This
chapter shows how to create
a winning SQL Server
database design and
discusses how to perform one
of the most neglected
activities of performance
management, which is
proactive testing.
IV. Establishing a Smart
SQL Server
Monitoring Plan
What are the overall goals
of a smart SQL Server
monitoring plan? Do you know
how to accurately use the
most important performance
analysis methods for SQL
Server? This chapter
provides an overview of the
building blocks of a solid
SQL Server monitoring plan
and introduces the key
performance analysis methods
that every DBA needs to
understand and practice.
V.
SQL Server
Bottleneck Analysis Part 1 –
Diagnosing storage and system
problems
Bottleneck analysis is the
primary performance analysis
method DBAs should use in
diagnosing and tuning SQL
Server response time
problems. This chapter
focuses on how to recognize
and correct bottlenecks that
occur in the storage and
overall SQL Server system
layers.
VI. SQL Server Bottleneck Analysis Part 2 –
Diagnosing session and O/S
issues
If DBAs cannot locate any
obvious SQL Server issues at
the storage or system
layers, the next step is to
drill down into session and
operating system metrics to
determine if any bottlenecks
exist in these layers. This
chapter contains information
on how to identify and
correct bottlenecks with SQL
Server processes and the
Windows server.
VII. SQL Server Workload Analysis -
Unlocking the Who, What, and Why
of Performance Problems
After bottleneck analysis,
the next most important
performance methodology is
workload analysis, which
focuses on the overall
workload generated by
system, session, and SQL
activity. This chapter
contains details on how to
understand the overall
workload on a SQL Server and
recognize where improvements
can be made.
VIII. SQL Server Ratio Analysis -
Techniques for quickly getting a
bird's eye view of performance
Key performance ratios can
quickly help a SQL Server
DBA understand how well
their overall system is
performing. This chapter
provides details on what
ratios a DBA needs to
monitor, along with
recommendations for what to
do when key performance
metrics are out of line.
IX. PLM Steps 3 and 4 -
Using SQL Server History to Prepare for
the Future
Many SQL Server DBAs work in
a reactive mode, which means
they do little to plan for
the future needs of the
databases they oversee. This
chapter discusses the
importance of historical
trend analysis, what key
metrics should be tracked,
and how to use historical
data to forecast future
needs.
X. PLM Step 5 - SQL Server Tuning that
makes a difference
Many SQL Server DBAs spend
time tuning things that make
little or no impact in
overall performance. This
chapter focuses on what to
pay attention to and how to
form an overall PLM tuning
plan that can be effectively
used in large SQL Server
installations to
dramatically increase
performance.
|
|
|
|
|
