CSS-sql server Troubleshooting tools

Connection

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/resolve-connectivity-errors-overview

https://github.com/microsoft/CSS_SQL_Networking_Tools/wiki/0000-Troubleshooting-Workflows

Performance

• Pssdiag & Sqldiag manager

This is data collection tool for performance issues. It collects DMV, perfmon, profiler trace or extended events (xevents) data for support analysis.

Pssdiag & Sqldiag Manager on github repo

Pssdiag/Sqldiag Manager is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine. The data collected can be used by SQL Nexus tool which help you troubleshoot SQL Server performance problems.

• SQL Nexus

This is data analysis tool. It analyzes data collected by pssdiag or Sqldiag. SQL Nexus on codeplex (to be migrated to GitHub repro)

• RML Utilities

RML Utilities process, aggregate and replay profiler trace files. SQL Nexus depends on RML Utilities to process profiler traces. RML on Microsoft download center

• Execution plan
  • https://learn.microsoft.com/zh-cn/training/modules/explore-query-performance-optimization/
  • https://learn.microsoft.com/zh-cn/sql/relational-databases/performance/execution-plans?view=sql-server-ver16
  • https://www.sqlshack.com/execution-plans-in-sql-server/