Category: SQL Server Performance
This category contains articles about identifying and resolving SQL Server performance issues
-
How to use sys.dm_io_virtual_file_stats to check the disk read and write performance of your SQL Server?
When it comes to checking how well the disks are performing on your SQL Server, sys.dm_io_virtual_file_stats is your best friend. This Dynamic Management View (DMV)
-
sp_WhoIsActive – What is it? How to deploy & configure it? How to maintain the collected data?
If you’ve been an SQL Server DBA for a while, chances are you are already familiar with sp_WhoIsActive, a comprehensive, free, lightweight stored procedure developed
-
How to check the correct Windows Defender antivirus (AV) exclusions are in place for SQL Server?
Most enterprises run some sort of Antivirus or endpoint protection software on their servers including on SQL Server estates. The software choice depends on things
-
Are you a system administrator? Worried about high memory usage on your SQL Server host? Read on!
Quite often, I get approached by Windows SAs or system administrators in my organisation, saying that my SQL Server host is using too much memory
Latest Articles
