Tools and Documents for fault analysis in SQL Server-based environments.
Contents
Analyzing Call Stack
Microsoft
- WinDbg（(Debugging Tools for Windows)
- Windows Performance Tool kit
- microsoft/SQLCallStackResolver
- Sysinternals
- Trace Flag
- DBCC TRACEON – Trace Flags (Transact-SQL)
- 2592 and 3656
- DBCC TRACEON – Trace Flags (Transact-SQL)
Monitoring Tools
Microsoft
Non Microsoft
- oazabir/SQLServerPerformanceDashboard
- marcingminski/sqlwatch
- unruledboy/SQLMonitor
- glensmall/SQL-Live-Monitor
Private Project
- MasayukiOzawa/EZMonitor
- MasayukiOzawa/SimpleMonitor
- MasayukiOzawa/Zaiba2
- MasayukiOzawa/SQLServer-CustomReport
- MasayukiOzawa/SQLServer-CustomReport
DBA Tools
Microsoft
- Client Tools
- SQL Server Management Studio (SSMS)
- MicrosoftR SQL ServerR 2012 Performance Dashboard Reports (The latest SSMS includes it.)
- Azure Data Studio (ADS)
- sqcmd
- bcp
- Microsoft ADO.NET for SQL Server
- SQL Server Management Studio (SSMS)
- microsoft/tigertoolbox
- RML Utility
- MicrosoftR Database Experimentation Assistant
- MicrosoftR Data Migration Assistant
- microsoft/diskspd
- Docker Image
Non Microsoft
- BrentOzarULTD/SQL-Server-First-Responder-Kit
- sqlcollaborative/dbatools
- ErikEJ/SqlQueryStress
- flyway/flyway
- HammerDB
Private Project
Sample Databases
Microsoft
Non Microsoft
Documents
Microsoft
- SQL Server
- SQL Server troubleshooting
- SQL Server Guides
- Performance Center for SQL Server Database Engine and Azure SQL Database
- Security Center for SQL Server Database Engine and Azure SQL Database
- Failover Cluster Troubleshooting
- Best Practice
- Best practices with Query Store
- Security Best Practices with Contained Databases
- SQL Server back up to URL best practices and troubleshooting
- Replication
- Performance best practices and configuration guidelines for SQL Server on Linux
- SQL server best practices to optimize performance in Azure Stack Hub
- Storage and SQL Server capacity planning and configuration (SharePoint Server)
- SQL Server Design Considerations
- Microsoft SQL Server configuration
- Configuration Manager site sizing and performance FAQ
- TechNet Wiki
- SSMS
- Azure SQL Database
- Synapse Analytics
- Best practices for dedicated SQL pools in Azure Synapse Analytics
- Best practices for serverless SQL pool in Azure Synapse Analytics
- Development best practices for Synapse SQL
- Development best practices for Synapse SQL pool (Old Document)
- Best practices for loading data using dedicated SQL pools in Azure Synapse Analytics
- SQL Server on Azure VM
- Checklist: Best practices for SQL Server on Azure VMs
- Collect baseline: Performance best practices for SQL Server on Azure VM
- Storage: Performance best practices for SQL Server on Azure VMs
- VM size: Performance best practices for SQL Server on Azure VMs
- HADR configuration best practices (SQL Server on Azure VMs)
- Azure SQL Edge
- Basic Information