Category: SQL Server Performance
This category contains articles about identifying and resolving SQL Server performance issues
-
SQL Server ‘max server memory (MB)’ – the magic formula for calculating buffer pool size
As an SQL Server DBA, have you got a formula for calculating the value for ‘max server memory (MB)’ parameter, that restricts the memory used by SQL Server buffer pool? If not, read on and use the script provided in this post, to come up with a suitable value using various different formulae.
-
Script for a quick SQL Server memory overview – useful for creating a snapshot of current memory configuration
This post provides a quick memory overview of your SQL Server. The output includes the total amount of RAM on the SQL Server box, amount of unused RAM at host level, SQL Server memory allocations, current buffer pool and procedure cache sizes.
-
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)
-
What is sp_WhoIsActive? How to deploy and configure it, as well as 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
