• Objectives

    Explain how the Tuning Advisor supports database performance optimization.

    Use the tool to review and apply index and statistics recommendations.

    Detect and troubleshoot long-running and blocking queries.

    Safely run Tuning Advisor scripts using SQL Server Management Studio (SSMS).

  • Audience

    System Administrators

    Database Administrators

    IT Support and Technical Staff

  • Required Knowledge

    Basic understanding of SQL databases and indexing

    Familiarity with EnCore system administration

    Access to SQL Server Management Studio (SSMS)

    Appropriate system permissions to execute scripts

Course curriculum

    1. Overview of EnCore Tuning Advisor

    2. Understanding Indexes and Statistics

    1. Enabling and Accessing Tuning Advisor

    2. Running Index Advisor

    3. Running Statistics Advisor

    1. Long Running Queries

    2. Blocking Queries

    1. Frequently Asked Questions

About this course

  • 8 lessons
  • 6 minutes