SQL Server Performance & Tuning Course
Course Description
The objective of this course is to provide senior database analysts, developers or database administrators with a good understanding of SQL Server Architecture and Query Performance so that applications and their supporting environment can be tuned for optimal performance.
The course will provide delegates with the knowledge required to size, plan, monitor and tune a SQL Server application for either a OLTP or data warehousing environment. Everything from Operating System & SQL Server service tuning through to query and index tuning will be covered. It is a hands on course with performance and analysis tools being put to use throughout.
Course pre-requisites:
Delegates should have extensive experience with SQL Server 7 or later and should have a knowledge level equivalent to that provided by the PTR Advanced SQL, Stored Procedures & Triggers For SQL Server course . Knowledge of basic SQL Server 2000 Administration would be beneficial.
Topics covered on the 4 day SQL Server Performance & Tuning course
Performance & Tuning
- Sizing & Planning
- Monitoring Performance
- Analyzing Performance Data
- Tuning & Optimising Performance
SQL Server Internals
- Windows & SQL Server Architecture
- Process & Thread management
- Memory Use & Management
- I/O Management
- Networking
SQL Server Architecture
- Data Storage
- Transaction Logging
- Locking
- Indexing
- OLTP databases
- Data Warehouses
Planning A SQL Server Database Application
- Capacity Planning
- Sizing Databases
- Sizing Servers
System Performance & Tuning
- Hardware Resource Tuning
- I/O Performance
- Database Layout
- SQL Server Configuration Options
Monitoring Tools
- Performance Monitor
- SQL Profiler
- DBCC
Optimal Database Design
- Database Design
- Table Design
- Indexes
- OLTP databases
- Data Warehouses
Index Optimisation
- Index Types
- Covering Indexes
- Index Strategies
Locking
- Lock Types
- Locking & Granularity
- Blocking
- Locking & Transactions
- Transaction Isolation Levels
- Transaction Design
- Analysing Locks
Query Optimisation
- Query Optimiser
- Recompilation
- Query Cache
- Query Types
- Range
- Ordering
- Grouping
- Table joins & Join Algorithms
Analyzing Queries
- Query Analyser & Execution Plans
- SHOWPLAN
- Graphical
- Index Statistics
- Index Tuning Wizard
Tuning SQL Statements
- Comparing Queries
- Avoiding Subqueries
- Table Hints
Database Application Tuning
- Using Stored Procedures & User Defined Functions
- Views
- Partitioning Data
- Derived Data
- Minimising Redundant Data With Triggers
- Optimising Transactions
- Optimising Cursors
Tuning SQL Server Services & Tasks
- Replication Services
- DTS Packages
- Backup & Recovery
|
(click button to view / download course outline in printer friendly format)
(may take a few seconds to load)
|
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Technical Training Course
Course Fee = £1300 (excl.VAT)
Scheduled course dates
| May 2008 |
June 2008 |
July 2008 |
August 2008 |
September 2008 |
| 27-30 | 23-26 | 21-24 | 26-29 | 22-25 |
|
|
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
The SQL Server Performance & Tuning course qualifies for the PTR SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.
View SAVE IT Scheme Details
PTR Associates Limited
21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
|
