SQL Server Memory Calculator Tool

The estimated reading time for this post is 0 minutes

Providing enough memory to SQL Server is very tricky and most DBAs do not know how much memory is needed, then the gradually add on the memory into the VM or physical server once they face the performance issue from lack of memory space.

SQL Server memory usage calculation is different on every single hardware/server, and also the formula is difficult to be memorized by DBAs and takes long time to be calculated.

In this post, I would like to introduce out SQL Server Memory Calculator tool to estimate the memory usage by SQL Server components based on the entered information.

As you see at the following figure, SQL Server Memory Calculator requires the following info:-

  • SQL Server Version and Architecture
  • Windows Server Version, Architecture and Feature
  • Total Physical Memory
  • Total Logical Processors (2/Core)
  • Total Database Size

After providing above information, the tool will calculate the estimated memory utilization by SQL Server components and also mentions whether the current memory space is enough or needs to be add on.

You may download the SQL Server Memory Calculator Tool from HERE.

 

 

Hamid J. Fard

I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. I also do Pig, Hive and Sqoop development regarding Hadoop Big Data platform. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.

More Posts

Follow Me:
FacebookLinkedIn


Leave a Comment

8 Comments on "SQL Server Memory Calculator Tool"

Notify of
avatar
1000
Sort by:   newest | oldest | most voted
Maddy
Guest

In terms of DB size…should I need to consider only data file or I need to add log file usage as well.

Anders Bodilsen
Guest

Who do you approach a multi instance system with this tool ?

Joaquim Carvalho
Guest

it’s a very useful tools. thanks

Channdeep Singh
Guest

Awesome tool. Thanks.

Amit Singh
Guest

where are u these days..?

Amit Singh
Guest

ok

wpDiscuz