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