MSSQL %100 CPU - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

MSSQL %100 CPU

Author

Topic

macman64
Starting Member

2 Posts

Posted - 2005-12-27 : 13:38:02

I just installed windows server update services on a 2k3 system. I am using mssql dekstop edition as the database. trend micro office scan also uses mysql. When I try to approve an update it sometimes just times out. When it does work it takes for ever. The CPU usage shoots through the roof. about %99 by the sqlservr process. It also take 190,000 k of RAM. Is this normal and how can I fix it? I think its a problem with the mysql but i don't know what. I have tried restarting. Its a 2.4 GHz system with 1gb of RAM. It only has 2 machines connected to the WSUS(more to come) Anyone any ideas would be great

macman64
Starting Member

2 Posts

Posted - 2005-12-27 : 13:51:18

And i am getting this in the details pain in the time out:

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
at Microsoft.UpdateServices.Internal.SingleResultSetSPHandler.ExecuteStoredProcedure(DBConnection connection)
at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler)
at Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPSingleResultSet(String spName, DBParameterCollection args, Type resultType)
at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPDeployUpdate(Guid updateId, Int32 revisionNumber, Int32 deploymentAction, Guid targetGroupId, String adminName, DateTime deadline, Boolean isAssigned, DateTime goLiveTime, Int32 downloadPriority, Guid deploymentGuid, Boolean translateSqlException)
at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPDeployUpdate(UpdateRevisionId updateId, Int32 deploymentAction, Guid targetGroupId, DateTime deadline, String adminName)
at Microsoft.UpdateServices.Internal.BaseApi.Update.Approve(UpdateApprovalAction action, IComputerTargetGroup targetGroup, DateTime deadline)
at Microsoft.UpdateServices.Internal.BaseApi.Update.Approve(UpdateApprovalAction action, IComputerTargetGroup targetGroup)
at Administration.Updates.UpdateProxy.Deploy(String xpostXml)
at Administration.Updates.UpdateXPost.Page_Load(Object sender, EventArgs e)

at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
at Microsoft.UpdateServices.Internal.SingleResultSetSPHandler.ExecuteStoredProcedure(DBConnection connection)
at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler)
at Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPSingleResultSet(String spName, DBParameterCollection args, Type resultType)
at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPDeployUpdate(Guid updateId, Int32 revisionNumber, Int32 deploymentAction, Guid targetGroupId, String adminName, DateTime deadline, Boolean isAssigned, DateTime goLiveTime, Int32 downloadPriority, Guid deploymentGuid, Boolean translateSqlException)
at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPDeployUpdate(UpdateRevisionId updateId, Int32 deploymentAction, Guid targetGroupId, DateTime deadline, String adminName)
at Microsoft.UpdateServices.Internal.BaseApi.Update.Approve(UpdateApprovalAction action, IComputerTargetGroup targetGroup, DateTime deadline)
at Microsoft.UpdateServices.Internal.BaseApi.Update.Approve(UpdateApprovalAction action, IComputerTargetGroup targetGroup)
at Administration.Updates.UpdateProxy.Deploy(String xpostXml)
at Administration.Updates.UpdateXPost.Page_Load(Object sender, EventArgs e)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources