Question

SQL Computing Size

Posted February 1, 2020 119 views
WordPress

Hello, I have resized my droplet to have 2gb of ram as opposed to 1gb. My site keeps going offline because the SQL server is limited with computing size. How do I increase how much memory the SQL database can use on the droplet or would it be best to migrate the sql database to a managed database.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers

Hi shehethey,

SQL Server will take up all the ram assigned to it,whether it use or not.If you have sufficient money,it’s better to buy managed database.

I have met resolve page allocation failures due to insufficient memory when sufficient memory is available.In this condition,If you get the error message,

Disallowing page allocations for database '*\<databaseName>*' due to insufficient memory in the resource pool '*\<resourcePoolName>*'. 

in the error log when the available physical memory is sufficient to allocate the page, it may be due to a disabled Resource Governor. When the Resource Governor is disabled MEMORYBROKER_FOR_RESERVEinduces artificial memory pressure.
To resolve this you need to enable the Resource Governor.To resolve this,maybe Microsoft’s docs can help you.Go to see this page

https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/enable-resource-governor?view=sql-server-ver15

If this cannot help you,please commit a new work-ticket for DO team’s help.

Have a nice day.

Shiroka

Mysql memory usage is limited by the mysql config.

MySQLTuner: https://github.com/major/MySQLTuner-perl is a good tool which will help you to understand mysql resource usage and even limit as you need.

While you could limit mysql resource usage with mysql config changes, that may not guarantee that your application work well with mysql resource constrains you to implement.

So along with limiting mysql resource usage, you may have to use an additional support solution like a cache(Eg: Memcached) to reduce mysql queries which will help to reduce mysql resource usage as well.

Submit an Answer