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


10
Leave a Comment

avatar
1000
5 Comment threads
5 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
7 Comment authors
JrodriguezMaddyAnders BodilsenAmit Singh Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Jrodriguez
Guest
Jrodriguez

any thoughts to adding SQL Server 2016 and 2017 to the tool?

Maddy
Guest
Maddy

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
Joaquim Carvalho

it’s a very useful tools. thanks

Channdeep Singh
Guest
Channdeep Singh

Awesome tool. Thanks.

Amit Singh
Guest
Amit Singh

ok

Amit Singh
Guest
Amit Singh

where are u these days..?