Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Jobs failed - Unexpectedly? Expand / Collapse
Author
Message
Posted Sunday, December 08, 2013 9:54 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:56 PM
Points: 1,015, Visits: 2,840
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.
Post #1520907
Posted Monday, December 09, 2013 7:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 14,802, Visits: 27,278
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1521099
Posted Tuesday, December 10, 2013 8:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 2:08 AM
Points: 1,350, Visits: 15,200
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.
Post #1521558
Posted Tuesday, December 10, 2013 9:35 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:56 PM
Points: 1,015, Visits: 2,840
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..

Post #1521732
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse