Post reply

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

  • October 25, 2011 at 11:10 am

    #259252

    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

  • October 25, 2011 at 2:24 pm

    #1399307

    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]

  • October 25, 2011 at 2:32 pm

    #1399315

    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

    Jared
    CE - Microsoft

  • October 25, 2011 at 2:37 pm

    #1399320

    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

  • October 25, 2011 at 2:50 pm

    #1399324

    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

    Jared
    CE - Microsoft

  • October 25, 2011 at 3:25 pm

    #1399343

    44 mins video, will listen for sure...

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

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