December 22, 2015 at 7:19 am
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
December 22, 2015 at 7:26 am
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
December 22, 2015 at 7:43 am
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?
December 22, 2015 at 7:51 am
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply