Receiving SQL I/O requests taking longer than 15 seconds to complete

  • ALIF-662928

    SSCertifiable

    Points: 6054

    Can someone give a step by step process to find out how to analyse the involvement of sql server for getting this kind of alerts every now and then. It seems to be SAN issue, but i want to make sure its not a sql related issue, any steps to check all the resources in sql server would be greatly appriciated.

    Issue: SQL I/O requests taking longer than 15 seconds to complete

    Thanks

  • okbangas

    SSChampion

    Points: 11773

    May I suggest

    How to prove it's a SAN problem[/url]



    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • SQLKnowItAll

    SSC Guru

    Points: 61781

    okbangas (10/25/2011)


    May I suggest

    How to prove it's a SAN problem[/url]

    And then if you cannot prive it is a SAN problem, how do you prove it is an SQL problem? 🙂

    Thanks,

    Jared

    Thanks,
    Jared
    PFE - Microsoft
    SQL Know-It-All
    How to post data/code on a forum to get the best help - Jeff Moden[/url]

  • Evil Kraig F

    SSC Guru

    Points: 100851

    jared-709193 (10/25/2011)


    okbangas (10/25/2011)


    May I suggest

    How to prove it's a SAN problem[/url]

    And then if you cannot prive it is a SAN problem, how do you prove it is an SQL problem? 🙂

    Thanks,

    Jared

    Heh, not sure if you read through Brent's blog on that, but it's pretty thorough. If you find out it's NOT a SAN problem... you found your problem. 😉


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • SQLKnowItAll

    SSC Guru

    Points: 61781

    Evil Kraig F (10/25/2011)


    jared-709193 (10/25/2011)


    okbangas (10/25/2011)


    May I suggest

    How to prove it's a SAN problem[/url]

    And then if you cannot prive it is a SAN problem, how do you prove it is an SQL problem? 🙂

    Thanks,

    Jared

    Heh, not sure if you read through Brent's blog on that, but it's pretty thorough. If you find out it's NOT a SAN problem... you found your problem. 😉

    I have not, but now intend to! Thanks!!!

    Jared

    Thanks,
    Jared
    PFE - Microsoft
    SQL Know-It-All
    How to post data/code on a forum to get the best help - Jeff Moden[/url]

  • ALIF-662928

    SSCertifiable

    Points: 6054

    44 mins video, will listen for sure...

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

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