Learn how to investigate SQL Server performance issues on this SQL Server Performance Tuning Training Course, starting from a high level and drilling down into potential performance culprits. This is based on years of real-world tuning databases in the Enterprise. |
|
Learning Outcomes |
A methodical and repeatable approach to tuning SQL Server configuration and queries.
|
Course Requirements |
Developers and DBAs
|
Course Length |
3-days
|
SQL Server Performance Tuning Training Course Agenda
SQL Server Architecture Overview |
|
Disk IO & Benchmarking – What are we looking for? |
|
Windows & SQL Server Configuration |
|
System Database Optimisation – why it’s important |
|
Database Files – there can only be one? |
|
Indexes & Statistics plus Maintenance |
|
Native Monitoring Tools |
|
(Dead)-Locking & Blocking |
|
New Features of SQL Server |
|
Logical Query Processing |
|
Queries & Application Performance Issues |
|
Please note you can add any New Features of SQL Server to compliment this training. You can add or take away any module.
Course Price |
This course costs £1500 excluding VAT
|
How to Book
|
Call us or email us on the form below, any questions, ask us!
|
Comments
“we’d thought we’d learn only 1 or 2 new things, but we’ve learned a lot” – Emma
|
Summary
User Rating
no rating based on votes
Service Type
SQL Server Performance Tuning Training Course
Provider Name
Sequallity Ltd,
80-83 Long Lane,London,EC1A 9ET,
Telephone No.020 3507 1989
Telephone No.020 3507 1989
Area
UK
Description
Learn how to investigate SQL Server performance issues on this SQL Server Performance Tuning Training Course, starting from a high level and drilling down into potential performance culprits. This is based on years of real-world tuning databases in the Enterprise.