< Go back to SQL Server Performance Tuning training course
Editor (add & remove topics to suit your needs)
Database Performance – What’s ‘Good’ and why?
Relational Database Overview
The Query optimiser, compilation and caching.
Locking and Logging and how updates happen.
How backups work, how DTS packages work.
Optimal Data Storage
Using File groups to Position Objects
The affect of normalisation and de-normalisation.
Analysis Services – a reporting solution in waiting?
Task Manager & Performance Monitor – General counters to look out for, tips and techniques.
Current Activity Window & SQL Profiler – Zooming in on problem queries
Query Analyser – Decrypting the showplan and trace output. Other set commands.
Transact SQL diagnostic commands. Various DBCC commands, some undocumented.
Index selection – How the optimiser decides.
Statistics – Auto and Manual.
Clustered versus Non-Clustered – Pros and Cons
The Fillfactor factor
Index optimiser hints
Index tuning wizard, when to use it.
Index Maintenance. Dangers and pitfalls.
Table defrag with clustered indexes. When and when not to do it.
Indexed Views – Advanced index builds.
The City Analogy & Keeping the traffic flowing
Transaction isolation levels and locking hints
Table restructuring & de-normalisation, replication and data warehousing solutions
Efficient Programming in TSQL
SARGS and the WHERE clause.
Covered indexes from the other side.
Stored procedures: Problems solved and created
Trigger problems and solutions
Cursors and Temporary tables
Tips and tricks.
Efficient Client Programming
Most of this course focuses on the server side application. However there is also a number of potential problems that may occur from the client side too. This section makes no assumption on which client you will be using, except that it will use ActiveX Data objects.
Default recordset options.
Send SQL versus Stored Procedures
Efficient use of recordsets and connections.
Timeout management and giving the user the perception of better performance
Audience & Requirements
Duration, location and dates
If you have a course length in mind, please select from the list
More than 5 days
Where would you like the course to be held?
On your site
At our London offices
Please quote for both options
Where is your site located?
If you have a date and location in mind, enter them here....
Complete the form oppositebelow to get your quote >>>
GET A CUSTOM COURSE QUOTE
Complete this form for an instant quote Or for more information call 0800 028 6400
Subscribe to our Newsletter – Receive the latest info on Tech courses & insights Subscribe