sql server 2014 becomming non responsive

  • We have a few instances in the past few days where sql has become unresponsive. The cpu gets to 55% then we cant access it. In the logs right before it happens we get the below error. Any ideas as far as an avenue to explore to resole this issue?

    Message

    average writes per second: 5.22 writes/sec

    average throughput: 0.07 MB/sec, I/O saturation: 295, context switches 676

  • Snargables (12/22/2015)


    We have a few instances in the past few days where sql has become unresponsive. The cpu gets to 55% then we cant access it. In the logs right before it happens we get the below error. Any ideas as far as an avenue to explore to resole this issue?

    Message

    average writes per second: 5.22 writes/sec

    average throughput: 0.07 MB/sec, I/O saturation: 295, context switches 676

    Even though 'standard' connections appear unresponsive, you may (as an admin) still be able to create a DAC (see here) to help troubleshooting.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • sorry, i misspoke. the sql server is still availible however it is the sql instance that is not. I'm able to resolve the issue by stopping the sql instance on a different server that accesses the instance in question.

    Couple questions? Why would the server never get over 56% cpu. I'm not aware of a setting in sql to force max cpu. Is this perhaps a setting that our server guys have put on sql?

    2) anyone see this issue w/ i/o saturation then the sql instance gets beaten so badly that it becomes unresponsive?

    Are you suggesting i use the DAC to get into the sql intance to identify whats killing it while it's happening?

  • Are you suggesting i use the DAC to get into the sql intance to identify whats killing it while it's happening?

    Just an idea which may help your troubleshooting, yes.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 4 posts - 1 through 3 (of 3 total)

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