Description
Scaling SQL Server describes the capacity and license limit for SQL Server and to the Windows Servers and explains the different kinds of versions in these servers. The planning and implementation of hardware migration can be described in several different ways. And finally migrating to new hardware with minimal downtime and some of the different ways for using all the technologies that are built into SQL Server.
Description
Following are the license agreement for Windows Server.
- Windows Server 2012 and 2012 R2 are limited to 640 logical processors and 4TB of RAM.
- Current model commodity servers can exceed the 4TB RAM limit.
- Windows Server 2016 will allow 12TB of RM.
Description
Following are the license agreement for SQL Server.
- SQL Server 2012 and 2014 enterprise edition can use 640 logical processors and 4TB of RAM.
- SQL Server 2012 standard edition is limited to four sockets or 16 physical cores and 64GB of RAM.
- SQL Server 2014 standard edition is limited to four sockets or 16 physicals cores and 128 GB OF RAM.
- SQL Server 2016 enterprise edition can use 12TB of RAM.
- SQL Server 2016 standard edition limits are currently not defined.
Description
Scaling refer to the idea of loading up a particular server to its capacity,replacing that server with a larger server. Such as replacing sockets from 2-sockets server to 4-socket server. And even NUMA hardware doesn't scale in a perfect linear fashion. The performance and scalability doesn't scale in a linear fashion, but the cost actually goes up quicker while doubling the scale. The other problem run into the higher core count processors from any given intel processor family. Typically have much lower base clock speeds then lowering core count processors will get diminished. And the other issues is that the larger server, it contain 2-socket server to 4-socket server is probably not going to have twice the number of PCIe slots,that going to have a limit for the ultimate amount of input and output boxes as the number of PCLe slots, even though it's pretty easy to do from an engineering perspective.
Description
There are three different phases for exercising the planning and implementing a hardware migration, such as :
- Upgrading hardware and storage
- Using latest version of windows server
- Using latest version of SQL Server
Description
Database mirroring VS log shipping it come from the production migration. And these both can be described individually.
- Database mirroring requires more preparation.
- Database mirroring has more restrictions.
- Database mirroring puts more stress on the infrastucture.
- It allows no data loss and short outage.
- Log shipping requires less preparation.
- Log shipping has fewer restrictions.
- It has less dependent on infrastructure.
- Log shipping has some potentials for data loss
Key Points
- Scaling Up SQL Server - Describes the capacity and license limit of SQL Server and Window Server.
- Diminishing returns of scaling - Describes the concept of loading a server.
- Planning a hardware migration - Describe the features and phrases of SQL Server.
- Database mirroring vs log shipping - Describes the key difference between them.