Tag: SQL Server Performance
-
Check if Query Store is Enabled in SQL Server
The Query Store feature was introduced in SQL Server 2016 (13.x), which helps DBAs & Developers identify and…
-
SQL Server Heap Fragmentation
SQL Server heap fragmentation can significantly impact database performance and efficiency. In this blog post, we’ll dive into…
-
Killing SPIDs in SQL Server
In SQL Server, Session Process IDs (SPIDs) play a crucial role in identifying and managing SQL connections. The…
-
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…
-
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…
-
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.…
Most Viewed
Blog Categories
- Other (7)
- PowerShell (29)
- SQL Server (62)
- WSL (11)