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:

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: http://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 !!