| |
SQL Server Performance
Tuning Training Class
A four-day on-site SQL Server DBA Training Course
© 2016 by Burleson Corporation
* 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 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.
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 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-2016 by Burleson Corporation
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.
|
|
|
|
|
and include the URL for the page.
