SQL Server Memory Calculator Tool

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.

 

 

Share This Story

Share on facebook
Share on twitter
Share on linkedin
Share on whatsapp

Share Your Comments

About The Author

Search Articles

Categories

Follow Fard Solutions

Share Your Comments

Fard Solutions Sdn. Bhd. Company was established in 2012 in Kuala Lumpur. We are engaged in development, implementation, integration and maintenance of the most advanced database solutions and IT research & development (innovation).

(+60) 03 8994 6788

info@fard-solutions.com

Fard Technology Corp.
700-1199 West Hastings Street,
Vancouver, British Colombia,
V6E 3T5 Canada.

Fard Solutions Sdn. Bhd.
1-1C & 1-2C Incubator 1,
Technology Park Malaysia,
Bukit Jalil, 57000
Kuala Lumpur, Malaysia.

  • Copyrights © 2020 Fard Solutions Sdn. Bhd. , All rights reserved.
  • Privacy Policy
  • Terms of Service
  • A Project By Website Artisan