DBA Scrolls - SQL Stories from the Trenches

As database administrators, it's crucial to monitor and analyze CPU usage across different databases in SQL Server. By understanding which databases consume the most CPU resources, we can better optimize performance…

Slow running queries can drag down application performance and degrade user experience. As a DBA, it's important to monitor and optimize long running SQL statements. In this post, I'll demonstrate how to find que…

The SQL Server Query Store is an incredibly useful feature for monitoring and troubleshooting query performance issues. One of the handiest aspects of the Query Store is the ability to easily retrieve execution plans an…

The Query Store is a feature in SQL Server that collects and stores information about queries that are executed. This information can be used to troubleshoot performance problems, identify queries that are causing probl…

In the world of database management, identifying queries responsible for high CPU usage is paramount for maintaining optimal performance. This article will guide you through two essential SQL statements that can help…

In SQL Server, TempDB is a system database used to store temporary objects such as temporary tables, table variables, and other internal objects created during query processing. It is essential for managing sorting, gro…

Cardinality Estimation is a crucial component of SQL Server's query optimization process. It is the process by which the database engine estimates the number of rows that will be returned by a query. The accuracy of…

SQL Server is a powerful relational database management system that can handle large amounts of data and complex queries. However, as the workload increases, SQL Server can experience performance issues that can impact …

Parallelism is a key feature of SQL Server that enables multiple processors to work on a single query simultaneously. By utilizing parallelism, you can significantly improve query performance and reduce query execution …

Have you ever wondered why SQL Server generates new execution plans for queries even if there is no change in the SQL code? This phenomenon can cause performance degradation and impact database performance if not manage…

SQL Server is a powerful relational database management system used by businesses of all sizes. However, as your database grows, it is not uncommon to experience SQL blocking, which can significantly impact your databas…