|
Provided by: Affinity IT Training, LLC SQL Server 2000 Performance and Tuning |
 |
Training
Provided by Affinity IT Training, LLC
You need to know how to tune queries and stored procedures
for optimal performance.
This course thoroughly covers SQL Server 2000 Query Optimizer.
You will learn techniques to write high performance queries,
allowing the optimizer to use the most efficient query plan,
and diagnose and correct performance problems with already existing queries.
Additionally, you will learn to interpret optimizer statistics and how to use simulated statistics.
Finally, you are presented with a benchmarking tuning methodology.
Audience:SQL Developers and Database Administrators (involved in tuning queries)
|
|
||||||||||
SQL Server 2000 Performance and Tuning
Objectives
- Use Microsoft utilities to troubleshoot query performance
- Determine how the optimizer chooses access methods (indexes, table scans, parallel vs. serial)
- Write queries which help the Optimizer choose the most efficient query plan
- Interpret optimizer statistics
- Tune insert, update, and delete operations
- Optimize stored procedure performance
- Work with different transaction techniques to promote better concurrency
Outline
The query optimizer
Query Analyzer, Enterprise Manager, Profiler, Debug and other utilities
Optimizing joins
Optimizer statistics
Tuning insert, update, and delete operations
Parallel query plans
Using indexes to reduce I/O
Locking and concurrency issues
Stored procedures
Setup
- Access to Microsoft SQL Server 2000
- Databases and Accounts for students and Instructor
Seminar Pre-Requisites
- SQL Server 2000 Intro for Developers
- SQL Server Advanced Transact-SQL
Training Materials
- Course Workbook
X.X
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
