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?

  • 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 '15 at 14:32
  • What patch level you are running for sql server 2005 ? – Kin Shah Nov 19 '15 at 14:35
  • @Kin from the screen shot looks like SP4 (bottom right corner). – dwjv Nov 19 '15 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 '15 at 14:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.