Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

   

SQL Server Performance Tuning Training Class


A four-day on-site SQL Server DBA Training Course

© 2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

 

 

Key Features

* 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
 

  

Course Description

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.

Book Required

  High-Performance SQL Server DBA

Retail Price $27.95/  £17.95

Robin Schumacher

ISBN 0-9761573-6-5

Audience

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.

Curriculum Design

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.
 
 

 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.