Server metrics missing
AlexP_DBH
Posts: 2 New member
When I look at the server metrics, they stop a few days ago. The SQL metrics are still up-to-date. The status of the monitored server shows repeated occurences of:
The base monitor log shows repeated messages like:
2018-10-02 06:56:44,289 [ 1268] WARN RedGate.Response.Common.Utilities.Status.StatusLogger - <MySQLServer\Instance>: Registry / GetBinaryValue: 238 230 : ConnectivityError
System.IO.IOException: Not enough server storage is available to process this command.
I do see incidental login failures on the monitored server for the Monitor-account (2-3 times a day), but nothing else in the eventviewer.
The monitored instance is SQL 2005.
SQL Monitor 7.0.7.7367
Any help on this is appreciated.
| 2 Oct 2018 10:00 | Registry | GetBinaryValue: 236 510 | Cannot connect | IOException | Not enough server storage is available to process this command. |
The base monitor log shows repeated messages like:
2018-10-02 06:56:44,289 [ 1268] WARN RedGate.Response.Common.Utilities.Status.StatusLogger - <MySQLServer\Instance>: Registry / GetBinaryValue: 238 230 : ConnectivityError
System.IO.IOException: Not enough server storage is available to process this command.
I do see incidental login failures on the monitored server for the Monitor-account (2-3 times a day), but nothing else in the eventviewer.
The monitored instance is SQL 2005.
SQL Monitor 7.0.7.7367
Any help on this is appreciated.
Tagged:
Answers
Unfortunately there is limited information on Microsoft.com. https://support.microsoft.com/en-us/help/106167/error-message-not-enough-server-storage-is-available-to-process-this-c may be of help, but I'd recommend you contact Microsoft about this directly.
Playing with the setting in the link doesn't sound like a solution we'd want to try, seeing that we've got numerous servers with the same settings that are not having any problems. And we don't want to create a snowflake.
We'll start by rebooting the server (if we can get a maintenance window) to see if that helps.