SQL Computing Size

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.

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

Mysql memory usage is limited by the mysql config.

MySQLTuner: 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.

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

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

Have a nice day.