December 8, 2013 at 9:54 pm
Hi
Recently SQL 2008 edition upgraded to enterprise edition from standard edition on top of windows 2008 server 32 bit operating system, and applied latest service pack 3. After installed everything working fine for 5 days.. Unexpectedly all SQL jobs failed even backup job also.. Pls. guide me what could be issues? Server Remote Desktop also not working..
Error Message as below..
Unhandled Exception:
System.IO.FileLoadException: Could not load file or assembly 'SQLPS, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Insufficient system resources exist to complete the requested service. (Exception from HRESULT: 0x800705AA) File name: 'SQLPS, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ---> System.Runtime.InteropServices.COMException (0x800705AA): Insufficient system resources exist to complete the requested service. (Exception from HRESULT: 0x800705AA). Process Exit Code -532459699. The step failed.
December 9, 2013 at 7:52 am
It sounds like you are running into some sort of resource issue according to the error message:
Insufficient system resources exist to complete the requested service
Without more information, I'm not sure what it is, but it sounds like some type of issue with memory, although it could also be storage. I would look further into the windows log to see if there are application or system errors there. Is SQL Server sharing resources on the server with other applications? Is this running on a VM which could be starving it of necessary resources? More investigation is needed.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 10, 2013 at 8:41 am
Are you running multiple concurrent jobs using Powershell?
There is a default limitation in the msdb.dbo.syssubsystems table limiting you to 2 instances of powershell running concurrently. You can safely update this value to 4 (or more) providing you allow the server resources for it.
December 10, 2013 at 9:35 pm
Thanks for your valuable replay..
I have verified in Application event log- Error apperaing related to SEP (symantec Endpoint Protection) due to updateing new version of SEP.. it was courrupted some system In-built Dotnet Framework DLL files (related to SQL Maintenance plan DTS package), all the jobs working after restart the server..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply