In the past 1.5 years we in the SQL Server CSS and content teams have been working on creating new documentation to assist with troubleshooting SQL Server slow performance issues.
Here is a list of articles that were produced over this period. Hope you find these useful. Please share with others and don’t hesitate to provide feedback at the bottom of each article page by clicking on “Was this page helpful?”.
The following individuals contributed with reviews, ideas, project management and content creation: Shaun Beasley, Pradeep Madheshiya, Stephanie Okhagbuzo, Hemin Shah, Liwei Yin, Seven Dong, Haiying Yu
Slow Queries
- Troubleshoot slow-running queries - SQL Server | Microsoft Learn
- Troubleshoot query time-out errors - SQL Server | Microsoft Learn
- Troubleshoot a query that shows different performance between two servers - SQL Server | Microsoft Learn
- Decreased query performance after upgrade from SQL Server 2012 or earlier to 2014 or later - SQL Server | Microsoft Learn
- Query is slower in database application than in SSMS - SQL Server | Microsoft Learn
- Troubleshoot queries that seem to never complete in SQL Server - SQL Server | Microsoft Learn
- Troubleshoot slow queries due to query optimizer timeout - SQL Server | Microsoft Learn
- Troubleshoot performance issues with narrow and wide plans in SQL Server - SQL Server | Microsoft Learn
High CPU in SQL Server
Slow I/O with SQL Sever
Memory issues in SQL Server
- Troubleshoot out of memory or low memory issues in SQL Server - SQL Server | Microsoft Learn
- Troubleshoot slow performance or low memory issues caused by memory grants - SQL Server | Microsoft Learn
- Memory-optimized tempdb metadata out of memory errors - SQL Server | Microsoft Learn
Everything in SQL Server appears slow
Thank you!
Updated Jun 16, 2023
Version 3.0
Joseph_Pilov
Microsoft
Microsoft