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
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
Course architecture
- Introduction to performance optimization: physical design, load analysis
- MS SQL Server storage mechanisms: files, FILEGROUPS, extensions and pages
- Indexes: creation, options, structure, parameterization
- Indexed views, partitioned views and partitioned tables
- The role of the optimizer: how it works, query optimization
- Refining queries: the query execution plan and execution statistics
- SQL Server and VMs
- MS SQL Server with Windows: CPU utilization, virtual memory management, RAID disks
- Transactions and locks: exclusive and shared, range, page and table locks, isolation levels, hints
- Performance monitoring, stored procedures, perfmon, alerts, MS SQL Profiler
- Using the Database Engine Tuning Advisor
- Maintaining indexes (defragmentation) and statistics
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