How much RAM do I need for database server?

Question

The minimum requirements are easy to meet: at least 3 GB of RAM and enough hard drive space to hold their data warehouse, staging database, and cubes. However, meeting the bare minimum is often not the ideal solution and providing better hardware to your server will allow for improved run-times and efficiency. 31 янв. 2019 г.

How much RAM should a database server have?

Size of Database(s): The most important consideration due to its direct impact on processing needed to populate a data warehouse, if the database is 50 GB or under then 16 GB of RAM is sufficient. Execution Packages: The more RAM your server is equipped with, the faster it will complete execution packages.

How much RAM should SQL Server use?

In our SQL Server Setup Guide, we tell folks to leave at least 4GB to the OS, and I think most sysadmins would consider 2GB to be the bare minimum.

How much RAM does a MySQL server need?

The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of RAM. You can improve MySQL performance by increasing the values of certain cache and buffer-related system variables.

Does database need RAM?

For an 80GB database I wouldn't expect you to need 64GB RAM. Can you make an approximation of how much of that database is going to be in use at any time? Most OLTP databases probably have about 15-20% of the data in use at any time. A Business Intelligence database will be different, and may be using 60% or more.

Expert · Answer