Consolidating sql servers best practices

08-Jun-2020 02:26

Leaving aside for the moment the cost of virtualization software, training admins to use the software and so forth, let's look specifically at the cost of the hardware.Eight 1U dual-core servers with 4 GB RAM, one or two built-in Ethernet ports and 70 to 150 GB of hard disk space can be found quite inexpensively these days, with even more savings if you don't insist on a first-tier server manufacturer.Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it.We know that a quick look at perfmon or task manager can tell us of high CPU usage, but what is a good way to quickly look at proper memory usage.On the other hand, a 16-core server with 32 GB of RAM, several four-port Ethernet cards and a terabyte or two of disk space can cost considerably more than eight dual-core servers.A quick check of a major brand site produced numbers of

Leaving aside for the moment the cost of virtualization software, training admins to use the software and so forth, let's look specifically at the cost of the hardware.Eight 1U dual-core servers with 4 GB RAM, one or two built-in Ethernet ports and 70 to 150 GB of hard disk space can be found quite inexpensively these days, with even more savings if you don't insist on a first-tier server manufacturer.Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it.We know that a quick look at perfmon or task manager can tell us of high CPU usage, but what is a good way to quickly look at proper memory usage.On the other hand, a 16-core server with 32 GB of RAM, several four-port Ethernet cards and a terabyte or two of disk space can cost considerably more than eight dual-core servers.A quick check of a major brand site produced numbers of $1,339 each for the small servers, or $10,172 total, versus $45,196 for a single big server.It isn't a simple prospect, and I often see it done incorrectly in client environments.To address this important topic, I have three avenues for you to take.

||

Leaving aside for the moment the cost of virtualization software, training admins to use the software and so forth, let's look specifically at the cost of the hardware.

Eight 1U dual-core servers with 4 GB RAM, one or two built-in Ethernet ports and 70 to 150 GB of hard disk space can be found quite inexpensively these days, with even more savings if you don't insist on a first-tier server manufacturer.

,339 each for the small servers, or ,172 total, versus ,196 for a single big server.It isn't a simple prospect, and I often see it done incorrectly in client environments.To address this important topic, I have three avenues for you to take.

consolidating sql servers best practices-42consolidating sql servers best practices-17consolidating sql servers best practices-61

If you set up eight single-purpose servers (an app server, mail server, Web server, SQL server, etc.) without changing the configurations, virtualization's advantage drops.Create a hybrid virtualization solution in Microsoft Azure: - Learn about running virtual machines in Microsoft Azure- Move VM’s between Hyper-V and Microsoft Azure- Move VMware, AWS, Hyper-V and Physical Servers to Microsoft Azure The following table lists the topics in the Hyper-V documentation library for the Hyper-V role in Windows Server 2012 and Windows Server 2012 R2.It provides links to other information resources, including downloadable content, blogs, videos and a contact link you can use to ask questions and provide feedback.With this technology, you can improve the efficiency of your computing resources and free up your hardware resources.For the most current versions of the topics in this section, see Hyper-V on Windows Server 2016 Technical Preview.

If you set up eight single-purpose servers (an app server, mail server, Web server, SQL server, etc.) without changing the configurations, virtualization's advantage drops.Create a hybrid virtualization solution in Microsoft Azure: - Learn about running virtual machines in Microsoft Azure- Move VM’s between Hyper-V and Microsoft Azure- Move VMware, AWS, Hyper-V and Physical Servers to Microsoft Azure The following table lists the topics in the Hyper-V documentation library for the Hyper-V role in Windows Server 2012 and Windows Server 2012 R2.It provides links to other information resources, including downloadable content, blogs, videos and a contact link you can use to ask questions and provide feedback.With this technology, you can improve the efficiency of your computing resources and free up your hardware resources.For the most current versions of the topics in this section, see Hyper-V on Windows Server 2016 Technical Preview.Checking out the Page Life Expectancy (PLE) counter is a great way to check for memory pressure.