What do you want to learn today?

Performance Tuning and Optimizing SQL Databases (SQL Server 2017)

Inquire Now
In-Person / Training
May 13, 2019 - May 16, 2019
USD  1,885.00

Details

This course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

This course is based on the objectives of the course version 10987C.

Outline

      1. SQL Server Architecture, Scheduling, and Waits
        1. SQL Server Components and SQL OS
        2. Windows Scheduling vs SQL Scheduling
        3. Waits and Queues
        4. Lab : SQL Server Architecture, Scheduling, and Waits
      2. SQL Server I/O
        1. Core Concepts
        2. Storage Solutions
        3. I/O Setup and Testing
        4. Lab : Testing Storage Performance
      3. Database Structures
        1. Database Structure Internals
        2. Data File Internals
        3. TempDB Internals
        4. Lab : Database Structures
      4. SQL Server Memory
        1. Windows Memory
        2. SQL Server Memory
        3. In-Memory OLTP
        4. Lab : SQL Server Memory
      5. SQL Server Concurrency
        1. Concurrency and Transactions
        2. Locking Internals
        3. Lab : SQL Server Concurrency
      6. Statistics and Index Internals
        1. Statistics Internals and Cardinality Estimation
        2. Index Internals
        3. Columnstore Indexes
        4. Lab : Statistics and index Internals
      7. Query Execution and Query Plan Analysis
        1. Query execution and optimizer internals
        2. Query execution plans
        3. Analyzing query execution plans
        4. Lab : Query execution and query plan analysis
      8. Plan Caching and Recompilation
        1. Plan cache internals
        2. Troubleshooting plan cache issues
        3. Query store
        4. Lab : Plan caching and recompilation
      9. Extended Events
        1. Extended events core concepts
        2. Working with extended events
        3. Lab : Extended events
      10. Monitoring, Tracing, and Baselining
        1. Monitoring and tracing
        2. Baselining and benchmarking
        3. Lab : Monitoring, Tracing and Baselining

Special Offer

For special offers, visit https://www.netcomlearning.com/

Schedules

Apr 15, 2019 - Apr 18, 2019
Mon, Tue, Wed, Thu 09:00 AM — 05:00 PM
May 13, 2019 - May 16, 2019
Mon, Tue, Wed, Thu 09:00 AM — 05:00 PM
Jun 10, 2019 - Jun 13, 2019
Mon, Tue, Wed, Thu 09:00 AM — 05:00 PM
Jul 08, 2019 - Jul 11, 2019
Mon, Tue, Wed, Thu 09:00 AM — 05:00 PM
No. of Days: 4
Total Hours: 32
No. of Participants: 6
Reviews
Be the first to write a review about this course.
Write a Review
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.