So apparently, when you setup a SQL Server its default maximum allotted memory value is a ridiculously large number. I wasn't aware of this until someone pointed it out. It is good to know information.
You should not use the default value obviously because doing so will suffocate the server it is on. So it is recommended to give the SQL Server as much as you can, but leave the OS 2-4 GB of memory. If the OS can't do its job, SQL Server is going to suffer too. So you get a performance gain by doing so.
The next part only really matters on physical machines and not VMs, the number of CPUs given to the SQL Server should be n-1, for the same reason as the memory. You need to let the OS do its job.
No comments:
Post a Comment