Post reply

How to check disk queue length

  • August 2, 2011 at 8:43 am

    #145809

    hey

    One of the Production Server is slow.How to check disk queue length of the sql server.

    Thanks

  • August 2, 2011 at 8:56 am

    #1362225

    Don't bother. It's near-impossible to interpret correctly and SQL can drive it high during normal operation.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 2, 2011 at 9:07 am

    #1362231

    we can using perfmon and any other way to check

  • August 2, 2011 at 9:13 am

    #1362238

    HI ,

    Go to server -->CMD-->perfmon -->ADD -->Physical Disk [performance object]--> AVG disk Queue lenth[counter].

    Thanks,

    Lavanya Sri

  • August 2, 2011 at 9:17 am

    #1362244

    If you don't have anything setup before the problem to have a baseline the counters won't help you much (if at all).

    Check this out, it'll give you 1 month of monitoring free and a whole lot deeper view in your server.

    http://www.red-gate.com/products/dba/sql-monitor/

  • August 2, 2011 at 9:37 am

    #1362268

    Ninja's_RGR'us (8/2/2011)

    If you don't have anything setup before the problem to have a baseline the counters won't help you much (if at all).

    And even if he did, the queue length is not a useful counter. With all the stuff between SQL and the disks, there is virtually no way to get any meaning out of the value.

    The disk latency counters are far more useful, and that's assuming that the slow performance has been linked to IO and not to something else.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 2, 2011 at 10:00 am

    #1362297

    Agreed, that's why I'm offering an overall solution which lets you did everywhere and that keeps log and query traces to pinpoint the problem rather than just guessing at it.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply