BizTalk server 2013R2 . Criteria to chose SQL 2014 edition RRS feed

  • Question

  • Can you use standard SQL 2014 edition for BizTalk 2013r2 in production environment over SQL enterprise edition.

    Our infra is less than the features provided by Standard edition and no plan for scalable or BAM RTA in future which are not supported by SQL standard edition. 

    • 16 CPU Cores
    • 128GB RAM
    • 524PB database size (same as Enterprise)

    Would like to know in terms of performance difference by using Standard over Enterprise SQL edition. 

    Sunday, October 13, 2019 7:42 PM

All replies

  • You've obviously read the Hardware and Software Requirements for BizTalk Server 2013 and 2013 R2, which certainly indicates that, yes you can use Standard SQL with the caveat of "For optimal performance, Microsoft recommends the Enterprise Edition of SQL Server."  I have had one client that even decided to downgrade from Enterprise SQL to Standard, with BizTalk 2010 and had no ill effects.

    For Enterprise vs SQL have a look at Editions and supported features of SQL Server 2016,  RDBMS Scalability and Performance.  Yes I'm aware this is a later version, but it would be similar to earlier versions.   

    What you will actually want to do is to know what your required throughput is, and then measure that throughput before you go live to ensure it is up to requirements.  The type of SQL is only one of many factors influencing performance.

    Any reason you are going with BizTalk 2013 R2 rather than BizTalk 2016?

    Sunday, October 13, 2019 8:32 PM