High Availability

SQL Server Standard includes some features to enable high availability, but the Enterprise edition brings more. Features like database snapshots, mirrored backups and fast restore mean that when something goes wrong, a back-up system can be online and in the right state to carry on.

Scalability

SQL Server Enterprise can scale more than the Standard edition. In hard numbers, Enterprise can run on 8 CPUs instead of Standard’s 4, utilising 2TB of memory instead of 64GB. The maximum database size is the same (524PB) for both, but the limits on CPUs and memory will affect the performance of a big SQL deployment. Some of the options around indexing will also make a big difference on performance when the database size and usage gets large.

Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.

Initial Consultation

Anuj Varma – who has written posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.