One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or the database is slow. In the ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or the database is slow. In the ...

I had an interesting talk with a dev today about how to troubleshoot SQL issues. The issue was this: we had a case where all of a sudden the DB just slowed down to a crawl. Everything typically ...

Query Store (QS): Introduced in SQL Server 2016, QS is similar to an airplane flight recorder with a specific focus on query plans and their performance. QS captures the history of queries, their ...

Microsoft has recently released a powerful new DMV specifically to help with memory issues, sys.dm_os_out_of_memory_events. It is currently available in Azure SQL Database and Azure SQL Man­aged ...

Run the SQL Profiler tool and capture events while reproducing the timeout. That might help diagnose whether it's SQL Server that's causing all the delay (e.g. query processing) or a network delay ...