- 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