Tag: Memory
This tag is for tagging all SQL Server memory related posts and articles
-
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.
-
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
