This allows you to customize limits on CPU and memory consumption.

AlwaysOn Availability Groups, especially for offloading read-only workloads to secondary replicas (and, you know have multiple standby instances ready to recover you from a disaster).

This allows you to very quickly load or archive huge chunks of data in an online operation. This is an extremely important limit, especially for data warehouse servers, which feel about memory and CPU like marathon runners do about pancakes and syrup. This is one list, based on a common set of needs I see at client sites, including performance, resource management, data warehousing, reporting, and change tracking. One top 10 list of Enterprise advantagesĮvery shop has their individual needs and wants, and so every shop will have a different top 10 (or 8, or 17) reasons why Enterprise would benefit them over Standard. In celebration of the impending SQL Server 2014 release, and in recognition that a large percentage of my clients are on that cusp of the Standard/Enterprise licensing decision for the currently available version…let’s talk about SQL Server 2012! Specifically, why Enterprise edition might be a huge advantage – or even an imperative – for your shop.

Sql server enterprise edition