jbarrow.viracoribt wrote:Do we size the VM's based off the Oversized VM report, or do we honor application provider minimum requirements if Veeam One suggests settings that are below those minimums? For instance, I have another SQL server it suggests 1GB of RAM on. 1GB of RAM is less than the minimums for the OS (512MB) and SQL (1GB) combined. Do we ignore the app minimums in this case or use those as our minimums and not go below those regardless of what Veeam One suggests?
jbarrow.viracoribt wrote:As a follow-up, how would you configure min and max memory settings in SQL if you went this low?
skrause wrote:From my experience, running SQL server on a single core is a bad idea. Also, for all editions above Express 4GB is the recommended minimum RAM (1GB being the absolute minimum.)
I just curious if you shrinked the SQL VM and how it works now.
jbarrow.viracoribt wrote:Then once I was RDP'd into that box, doing regular administrative tasks, I felt it was just slower than normal.
jbarrow.viracoribt wrote:It seems when the Windows CPU and RAM sensors show pressure, the VM runs like poo. When they don't show pressure, things run smoothly.
jbarrow.viracoribt wrote:skrause wrote:From my experience, running SQL server on a single core is a bad idea. Also, for all editions above Express 4GB is the recommended minimum RAM (1GB being the absolute minimum.)
Why is it a bad idea? Did you gather stats from VMware or Veeam One on these servers to show that it was performing slowly with the 1 core?
Users browsing this forum: No registered users and 5 guests