How can we help you today? How can we help you today?

Server metrics missing

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:
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.
Alex
0

Comments

2 comments

Sort by
  • Russell D
    It's a system error indicating a problem with available memory somewhere, assuming you definitely have enough space on the server.

    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.

    Russell D
    0
  • AlexP_DBH
    Thanks for the answer.

    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.
    AlexP_DBH
    0

Add comment

Please sign in to leave a comment.