Using SSD for BizTalk DB. Real-life experience RRS feed

  • Question

  • Hi,

    We are considering to use SSD disk for the MessageBox [and maybe other] database.

    In theory it should increase speed of the BizTalk as a whole system.

    Did anybody try it in real life scenarios? If so, what are the real numbers in performance?

    What is the real danger of the SSD degradation over time? What is the reliability? What about HA, is it worth to use SSD for the HA on SQL level?

    Leonid Ganeline [BizTalk MVP]

    Friday, December 12, 2014 5:08 PM

All replies

  • I find this document about using SSD disk for the MessageBox database, http://msdn.microsoft.com/en-us/library/ee377059(v=bts.70).aspx
    Monday, December 15, 2014 3:09 AM
  • I'd say the larger question is how to best use SQL Server with SSD's.  I figure you've seen this: http://technet.microsoft.com/en-us/video/how-to-optimally-use-sql-server-with-ssds-without-burning-them-out.aspx

    The more important question is, do you really need it?  Meaning, have you exhausted all other reasonable options and need SSD's to meet some latency SLA.

    • Proposed as answer by Angie Xu Friday, December 19, 2014 2:45 AM
    Monday, December 15, 2014 3:53 AM
  • Hi Johns,

    BizTalk is OLTP system, yes. But latency is an issue in my case. I need <100 msec latency for the MessageBox round trip for most cases. In some cases I need <10 msec.

    And SSD is so cheap, we could replace burned disk each couple months, if we need. It would be still cheaper than good hard-drive subsystem.

    And we tolerate some message lost. At last we use now the custom made HA solution and didn't find any problems with, no lost messages.

    Leonid Ganeline [BizTalk MVP]

    Friday, December 19, 2014 4:34 AM