Consolidating sql servers best practices rubidium strontium dating meteorites
The broad database system comprised of a number of physical and virtual machines.
Staying on-site, we deployed an upgraded database system to the customer’s virtual machines.
In regards to RAM, we proposed enabling Lock Pages in Memory right for SQL Server service account, using Max Server Memory and Min Server Memory options when running multiple SQL Server instances in the same VM, as well as disabling unnecessary processes within Windows.
Finally, we suggested running with mixed SQL Server workloads.
Additionally, we provided some purposeful recommendations and a set of best practices relevant to the customer’s newly created environment.
It included over 70 pages of very helpful information.