The Query Store feature was introduced in SQL Server 2016 (13.x), which helps DBAs & Developers identify and resolve performance issues related to queries. In this blog post, we’ll share a simple SQL query that will show if Query Store […]
SQL Server Heap Fragmentation
SQL Server heap fragmentation can significantly impact database performance and efficiency. In this blog post, we’ll dive into the causes of heap fragmentation, its effects on SQL Server performance, and effective strategies to mitigate and manage it. In SQL Server, […]
Killing SPIDs in SQL Server
In SQL Server, Session Process IDs (SPIDs) play a crucial role in identifying and managing SQL connections. The KILL SPID command serves as a tool for terminating troublesome sessions. This article provides an overview of the KILL command and its […]
Quick Performance Troubleshooting Script for SQL Server
When your SQL Server database starts experiencing performance issues, it’s crucial to have tools at your disposal to quickly diagnose and address the root causes. One such tool is a performance troubleshooting script that provides insights into SQL Server’s current […]
Get Most Frequently Executed Queries in SQL Server
As a SQL Server Database Administrator, troubleshooting query performance issues might unfortunately be a common task. Pinpointing the most frequently executed queries is akin to peering into the heartbeat of your system. Understanding which queries are running most often not […]
SQL Script to Get CPU Utilization History
Understanding CPU utilization history can sometimes be needed for diagnosing system or performance on a SQL Server instance. By analyzing historical CPU data, you can identify patterns, trends, and anomalies that help improve resource allocation and enhance overall system efficiency. […]