locked
Diskspd testing against SSD's on SQL Server and microseconds RRS feed

  • Question

  • Hi, when using Diskspd against 4 SSD's (RAID 5 array) we are seeing higher than expected latency figures (see below), which are baffling us. However after some research it appears that some other users are saying when you use Diskspd against SSD's the figures are in Microseconds.   Please can someone from Microsoft confirm this is the case? 

    Thks Darren

      %-ile |  Read (ms) | Write (ms) | Total (ms)
    ----------------------------------------------
        min |        N/A |      4.720 |      4.720
       25th |        N/A |     18.149 |     18.149
       50th |        N/A |     26.806 |     26.806
       75th |        N/A |     47.153 |     47.153
       90th |        N/A |     92.725 |     92.725
       95th |        N/A |    143.233 |    143.233
       99th |        N/A |    318.068 |    318.068
    3-nines |        N/A |    864.756 |    864.756
    4-nines |        N/A |   1580.786 |   1580.786
    5-nines |        N/A |   2070.190 |   2070.190
    6-nines |        N/A |   2418.533 |   2418.533
    7-nines |        N/A |   2653.430 |   2653.430
    8-nines |        N/A |   2653.430 |   2653.430
    9-nines |        N/A |   2653.430 |   2653.430
        max |        N/A |   2653.430 |   2653.430

    Wednesday, October 25, 2017 6:52 AM

Answers