Sql Server Enterprise versus Standard Editions
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.
Leave a Reply