toc.yml

- name: Monitor and Tune for Performance
  href: monitor-and-tune-for-performance.md
- name: Monitor SQL Server Components
  href: monitor-sql-server-components.md
- name: Performance Monitoring and Tuning Tools
  href: performance-monitoring-and-tuning-tools.md
- name: Cardinality Estimation
  href: cardinality-estimation-sql-server.md
- name: Establish a Performance Baseline
  href: establish-a-performance-baseline.md
- name: Isolate Performance Problems
  href: isolate-performance-problems.md
- name: Identify Bottlenecks
  href: identify-bottlenecks.md
- name: Monitoring Performance By Using the Query Store
  href: monitoring-performance-by-using-the-query-store.md
- name: Server Performance and Activity Monitoring
  href: server-performance-and-activity-monitoring.md
  items:
  - name: Start System Monitor (Windows)
    href: start-system-monitor-windows.md
  - name: Set Up a SQL Server Database Alert (Windows)
    href: set-up-a-sql-server-database-alert-windows.md
  - name: View the Windows Application Log (Windows)
    href: view-the-windows-application-log-windows-10.md
  - name: View the SQL Server Error Log (SQL Server Management Studio)
    href: view-the-sql-server-error-log-sql-server-management-studio.md
  - name: Save Deadlock Graphs (SQL Server Profiler)
    href: save-deadlock-graphs-sql-server-profiler.md
  - name: Open, View, and Print a Deadlock File (SQL Server Management Studio)
    href: open-view-and-print-a-deadlock-file-sql-server-management-studio.md
  - name: Save Showplan XML Events Separately (SQL Server Profiler)
    href: save-showplan-xml-events-separately-sql-server-profiler.md
  - name: Save Showplan XML Statistics Profile Events Separately (SQL Server Profiler)
    href: save-showplan-xml-statistics-profile-events-separately-sql-server-profiler.md
- name: Display and Save Execution Plans
  href: display-and-save-execution-plans.md
  items:
  - name: Display the Estimated Execution Plan
    href: display-the-estimated-execution-plan.md
  - name: Display an Actual Execution Plan
    href: display-an-actual-execution-plan.md
  - name: Save an Execution Plan in XML Format
    href: save-an-execution-plan-in-xml-format.md
- name: Plan Guides
  href: plan-guides.md
  items:
  - name: Create a New Plan Guide
    href: create-a-new-plan-guide.md
  - name: Create a Plan Guide for Parameterized Queries
    href: create-a-plan-guide-for-parameterized-queries.md
  - name: Specify Query Parameterization Behavior by Using Plan Guides
    href: specify-query-parameterization-behavior-by-using-plan-guides.md
  - name: Apply a Fixed Query Plan to a Plan Guide
    href: apply-a-fixed-query-plan-to-a-plan-guide.md
  - name: Attach Query Hints to a Plan Guide
    href: attach-query-hints-to-a-plan-guide.md
  - name: View Plan Guide Properties
    href: view-plan-guide-properties.md
  - name: Use SQL Server Profiler to Create and Test Plan Guides
    href: use-sql-server-profiler-to-create-and-test-plan-guides.md
  - name: Validate Plan Guides After Upgrade
    href: validate-plan-guides-after-upgrade.md
  - name: Delete a Plan Guide
    href: delete-a-plan-guide.md
  - name: Enable or Disable a Plan Guide
    href: enable-or-disable-a-plan-guide.md
- name: Database Engine Tuning Advisor
  href: database-engine-tuning-advisor.md
  items:
  - name: Start and Use the Database Engine Tuning Advisor
    href: start-and-use-the-database-engine-tuning-advisor.md
  - name: Reduce the Production Server Tuning Load
    href: reduce-the-production-server-tuning-load.md
  - name: Considerations for Using Test Servers
    href: considerations-for-using-test-servers.md
  - name: View and Work with the Output from the Database Engine Tuning Advisor
    href: view-and-work-with-the-output-from-the-database-engine-tuning-advisor.md