2

I get a alert email with the title:

SQL Server Alert System: 'Severity 17 - Potentially Fatal Error Insufficient Resources' occurred on myserver as 12:02

when I connect to myserver to check the log I see the below:

enter image description here

we are on sql server 2005.

and I am not sure what this local connection provider is.

any hints?

4
  • 2
    Is this server used for anything else? Looks like it's being forced to use the page file rather than memory. FYI, that's a named pipe: stackoverflow.com/questions/175579/what-are-named-pipes
    – dwjv
    Nov 19, 2015 at 14:32
  • What patch level you are running for sql server 2005 ?
    – Kin Shah
    Nov 19, 2015 at 14:35
  • @Kin from the screen shot looks like SP4 (bottom right corner).
    – dwjv
    Nov 19, 2015 at 14:36
  • 2
    You might also review this post: blogs.msdn.com/b/psssql/archive/2009/05/12/… This discusses start-up warnings and warnings that can occur later. Quoting: "So before spending a lot of time investigating why this is happening, please look at the values for the Working Set and committed memory."
    – RLF
    Nov 19, 2015 at 14:46

1 Answer 1

0

This looks like an error due to memory pressure.

Analysis

The errors in your screen shot are sequentially starting from the bottom and then ending at the top. This unfolds as follows:

  • Your SQL Server instance is coming under pressure due to a possibly low setting of the max server memory (MB) configuration setting. These are the memory errors.
  • Because you have a low memory setting or unavailable memory, the Named Pipes connection that was opened under the instance crashes.
  • The Named Pipes protocol for the instance has to be reinitialised.
  • This triggers the FATAL Error message.

I am basing my analysis on the error log and the following excerpt from the Microsoft SQL Server Documentation:

Named Pipes is a protocol developed for local area networks. A part of memory is used by one process to pass information to another process, so that the output of one is the input of the other. The second process can be local (on the same computer as the first) or remote (on a networked computer).

Reference: Choosing a Network Protocol (Microsoft | Docs)

The Named Pipes connection crashes and has to be reinitialised due to low available memory.

Solution

Increase the amount of memory for your SQL Server instance and/or the underlying Windows Server.

Reference Reading

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.