https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056253#M28906 The CPU utilization is constantly running between 80 and 100 percent whenever a simple server query is initiated. We have a DL380 G4 w/ 2 3.6 Xeon Procs with 3.5 GB of ram. Does anyone have an idea? Fri, 17 Aug 2007 13:16:59 GMT CPU Utilitzation High 2007-08-17T13:16:59Z https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056253#M28906 The CPU utilization is constantly running between 80 and 100 percent whenever a simple server query is initiated. We have a DL380 G4 w/ 2 3.6 Xeon Procs with 3.5 GB of ram. Does anyone have an idea? Fri, 17 Aug 2007 13:16:59 GMT https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056253#M28906 CPU Utilitzation High 2007-08-17T13:16:59Z https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056254#M28907 And how much monitored device you have in SIM? do you have Perfomance management pack? if yes, how much license are you deploy?<BR /><BR />Are you install SP1 to SIM? Sat, 18 Aug 2007 05:49:23 GMT https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056254#M28907 Dmitri Manushin 2007-08-18T05:49:23Z https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056255#M28908 Thanks for the reply Dmitri. We have a little over 1000 devices (most of them servers). We have only 10 licenses for PMP but I have not licensed any servers for monitoring. Mon, 20 Aug 2007 07:04:05 GMT https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056255#M28908 CPU Utilitzation High 2007-08-20T07:04:05Z https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056256#M28909 What schedule do you have for Tasks <BR /><BR />Hardware Status Polling for non Servers<BR />and<BR />Hardware Status Polling for Servers Mon, 20 Aug 2007 07:22:48 GMT https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056256#M28909 Dmitri Manushin 2007-08-20T07:22:48Z https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056257#M28910 I'm not sure if it's a problem unique to our set up here, but for quite a while I've not been able to use PMP.<BR />Whenever the service is enabled, IO on the HPSIM database leaps to around 2,000 IO/sec and higher.<BR />I disabled PMP and it stops.<BR />I'm going to be rebuilding HPSIM from scratch soon on a new server to see if the problem goes away.<BR /><BR />You may want to stop / start some of the additional HPSIM products to see if there's any relationship. Mon, 20 Aug 2007 17:20:07 GMT https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056257#M28910 Rob Buxton 2007-08-20T17:20:07Z https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056258#M28911 It seems that whenever I run a task or attempt to run a report on only 10 - 30 servers it peaks the sqlserver.exe to 100% for up to 10 minutes. I just moved the database to a 4 proc 2.0 GHz Xeon system with 8GB of ram and it is peaking it our as well. I just disabled PMP service and it has not had an affect. I appreciate all the help and replies. Has anyone had a similar problem? Tue, 21 Aug 2007 08:25:54 GMT https://community.hpe.com/t5/server-management-systems/sql-server-2005-cpu-utilitzation-100-with-sim-5-1/m-p/4056258#M28911 CPU Utilitzation High 2007-08-21T08:25:54Z