SQL Server 2014 Performance Tuning and Optimization
This lab is designed to give the right amount of Internals knowledge, and wealth of practical tuning and optimization techniques, that you can put into production. The lab offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The lab also teaches how to create baselines and benchmark SQL Server performance, how to analyze workload and figure out where performance problems are, and how to fix them. Coverage of in-memory tables and stored procedures along with an introduction to this exciting new technology is included.
What's Included:
- 4 Day save period
- Free 24/7 premier support
- Free instructor access
Platform Features:
- Seamless paste to virtual machine functionality
- Integrated keyboard language translation for all countries
- Integrated step-by-step instructions
- Remote classroom management for instructors & admins
- Student progress reporting
| Lab | Estimated completion time |
|---|---|
| 0. SQL Server 2014 Performance Tuning and Optimization |
480 mins
|
FAQ
If you are unable to place an order for Microsoft content, it may be that your account does not hold the required privileges to do so. Please ensure that you have entered a valid Partner ID in your organisation settings, so we are able to validate your TSP status and grant access accordingly.
Order information is sent via email to the registered email address of the account that was used to place the order. You will receive an order confirmation email with a PDF attachment which includes your lab access information.
If you believe you have ordered the wrong labs, please reach out to our support team.
Orders placed using a debit or credit card cannot be cancelled once they have been placed. Customers that are on monthly invoicing terms can cancel an order, assuming the product access key has not yet been issued / redeemed, up until the cut-off point. If you are unsure of your cut off point, please reach out to your account manager for further information.
If you believe you have ordered the wrong labs, please reach out to our support team.
Support can be reached at either of the following methods:
- Service desk: https://lab.support.godeploy.com
- Email: helpdesk@support.godeploy.com