BizTalk Server Tip #17: Use fast disks for your BizTalk Database subsystem

|  Posted: February 19, 2014  |  Categories: BizTalk Server BizTalk360

tip17

SQL Server is vital for any BizTalk environment, ensure maximum performance for the most demanding databases with a fast disk subsystem, consider using RAID 1+0 and SSDs for a high performance environment. In the majority of the BizTalk environments this is the first physical bottleneck you will face.

When doing load testing you will find that after you configure you environment to avoid any logical bottlenecks you will finally find a physical one. Normally the very first physical bottleneck you see is the IO disk subsystem performance on the SQL Server, this makes investing in the disk subsystem the most important scaling you can do on an environment. Betting on a highly available RAID system with fast disks is very important.

Read more on Monitoring and Reducing Database I/O Contention

blog-action04_thumb23333333333[3]

Author: Ricardo Torre

Head of Technical Pre-Sales & Product Strategist at BizTalk360, an enterprise software that acts as an all-in-one solution for better administration, operation, support and monitoring of Microsoft BizTalk Server environments.

  • John Glisson

    Scaling out your databases to separate disks or lunds is also a good strategy as well. Isolating the MsgBox data file and transaction log on their own drive/lund decreases disk I/O and increases throughput.

    • Ricardo Torre

      Hi John,

      Those recommendations are to avoid the logical bottlenecks in the platform, those should be done first since they require no investment. Here I am trying recommend where to invest first after you optimized your environment.

      Best regards,

      Ricardo Torre

One Platform Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

One Platform - Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

One Platform - Operations, Monitoring and Analytics Software
ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

Back to Top