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 http://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:
|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.
|AlwaysOn Failover Cluster Instances||Yes (Node support: Operating system máximum)||Yes (Node support: 2)|
Further details: http://msdn.microsoft.com/en-us/library/cc645993.aspx
- Next security feature is also really interesting for troubleshooting/auditing purpose.
|Fine Grained Auditing||Yes||No|
Hope it helps to take you that important decission !!