I have MS SQL 2005/SP3 running on Windows 2003 standard. The server has 4GB and that is the maximum based on the OS. I am running SSIS as well as SQL server. Max memory is 3168 mb.
I have SSIS packages that poll for files on a scheduled basis that can fail intermittently.
I have also been seeing this in the SQL server logs.
Error: 26050, Severity: 17, State: 1.
Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ] due to a failure. Error: 0xe8, state: 4. The server will automatically attempt to re-establish listening.
Server local connection provider has successfully re-established listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
I am thinking of backing down max memory to 2500 mb on the theory that the OS/SSIS is a bit starved.