Choosing the right SQL Server 2012 Edition for BizTalk Server 2013

If you are currently evaluating to use SQL Server Standard or Enterprise edition for your BizTalk Databases, below you can find some hints to help you taking that decision:

From a pure BizTalk perspective, you should consider to use Enterprise Edition:

• In order to use BAM real-time aggregation (RTA). It is not supported in the Standard Edition of SQL Server https://msdn.microsoft.com/en-us/library/jj248697(v=bts.80).aspx
• For large scale, enterprise-level solution that require high scalability/availability capabilities.
  • Scale up:

Feature Name	Enterprise	Standard
Maximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)	Operating System maximum	Limited to lesser of 4 Sockets or 16 cores
Maximum Compute Capacity Used by a Single Instance (Analysis Services, Reporting Services)	Operating System maximum	Limited to lesser of 4 Sockets or 16 cores
Maximum memory utilized (per instance of SQL Server Database Engine)	Operating System maximum	64 GB
Maximum memory utilized (per instance of Analysis Services)	Operating System maximum	64 GB
Maximum memory utilized (per instance of Reporting Services)	Operating System maximum	64 GB

 

• • Scale out / HighAvailability: In Standard Edition it is only possible to add two nodes to the Microsoft Failover Cluster.

Feature Name	Enterprise	Standard
AlwaysOn Failover Cluster Instances	Yes (Node support: Operating system máximum)	Yes (Node support: 2)

 

 

 

Further details: https://msdn.microsoft.com/en-us/library/cc645993.aspx

• Next security feature is also really interesting for troubleshooting/auditing purpose.

Feature Name	Enterprise	Standard
Fine Grained Auditing	Yes	No

 

 

 

Hope it helps to take you that important decission !!

Comments

• Anonymous
  July 20, 2016
  Fantastic Guide Thanks- Very Helpful for highlevel decision making on SQL