Improving SQL Server performance is rarely a matter of hardware. It's more often a matter of how well you write queries and how efficiently you index them. Find out how to evaluate queries, identify errors and areas for improvement, depending on your situation.
Duration
2 days
Schedule
9h to 16h
Regular fee
$995
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$895
Objectives of the training
To provide the knowledge and skills required to optimize MS SQL Server to get the highest possible performance for complex and/or high-volume applications.Targeted audience
Database administrators and developers.Prerequisite
Experience with MS SQL Server 2008 R2 administration (Courses MS509).Trainers
Associations and Partners Companies
Course architecture
Training eligible for SCALE AI grants
- Introduction to performance optimization: physical design, volume analysis
- The biggest causes of performance loss and the most common bottlenecks.
- Optimizing SQL Server for the cloud and VMs
- MS SQL Server storage structure: files, FILEGROUPS, extensions and pages
- Indexing: creation, options, structure, setup and fragmentation
- Optimizing SQL Server with the help of indexes
- Reading and compressing an execution plan
- Understanding the cardinality estimator improvements with SQL server 2019.
- Indexed views, partitioned views and partitioned tables
- Role and operation of the optimizer: query optimization
- Use of hints : RECOMPILE and QUERYTRACEON
- Query refinement: query plan and statistics
- SQL Server and Windows coexistence: CPU usage, virtual memory and disk management
- Transactions and locks: exclusive and shared, row, page and table locks, isolation levels, Hints
- Performance monitoring: procedures store systems, perfmon, alerts, MS SQL Profiler, Query Store, diskSpeed
- Creation of a load test and benchmarks
- Use of the Database Engine Tuning Advisor
- Index maintenance (defragmentation) and statistics
- Checklist for a SQL Health Check
- The biggest causes of performance loss and the most common bottlenecks.
- Optimizing SQL Server for the cloud and VMs
- MS SQL Server storage structure: files, FILEGROUPS, extensions and pages
- Indexing: creation, options, structure, setup and fragmentation
- Optimizing SQL Server with the help of indexes
- Reading and compressing an execution plan
- Understanding the cardinality estimator improvements with SQL server 2019.
- Indexed views, partitioned views and partitioned tables
- Role and operation of the optimizer: query optimization
- Use of hints : RECOMPILE and QUERYTRACEON
- Query refinement: query plan and statistics
- SQL Server and Windows coexistence: CPU usage, virtual memory and disk management
- Transactions and locks: exclusive and shared, row, page and table locks, isolation levels, Hints
- Performance monitoring: procedures store systems, perfmon, alerts, MS SQL Profiler, Query Store, diskSpeed
- Creation of a load test and benchmarks
- Use of the Database Engine Tuning Advisor
- Index maintenance (defragmentation) and statistics
- Checklist for a SQL Health Check
Pedagogical details
Training architecture
Use of laboratories to test and validate your knowledge.
Type of training
Skill development
Skill development and knowledge integration
Decision support
Basic knowledge
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
2 days
Schedule
9h to 16h
Regular fee
$995
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$895
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote