Jump to content


TronixS

High CPU Usage after SCCM SP1 CU1

By TronixS, in Configuration Manager 2012

Recommended Posts

TronixS Newbie

TronixS

Posted
Posted

Hello there,

 

we have Problems with our Enviroment but bevor i tell you what the Problem is here the Configuration, we build it on 2 Servers.

 

The First Server is our Primary Server on VMWARE with following specs:

2 x 3,5Ghz

16GB RAM

Windows Server 2008 R2 Standard with SP1

 

50GB (10GB free) Systemdrive

150GB SCCM (130GB free) Partition for the Configmanager self

500GB SCCM (225GB free) DP Drive.

 

The Second Server is our SQL Server 2008 R2:

 

2 x 3,5Ghz

16GB RAM

 

50GB (10GB free) Systemdrive

50GB (35GB free) SQL DB Drive (DB Size is 5,5GB)

50GB (48GB free) SQL Logs

 

 

Windows Server 2008 R2 Standard with SP1

 

Microsoft SQL Server Management Studio 10.50.2861.0
Microsoft Analysis Services Client Tools 10.50.2861.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5466
Operating System 6.1.7601
What have we done:
All goes fine and is running but befor we Update to SP1 (CU1) we had a low CPU Usage on our SQL Server. The CPU Usage is now most Time at 80-90% and there are two Process that this doing:
SQLSERVR.exe
ReportingServicesService.exe
I think that we had forgotten a Update or Patch for our SQL Server but the Consulting does know it and has no Idea.
In the Logfiles for ReportingServiceService are now 3GB on Logfiles, the files are written any permantley and are 32MB (yeep there are 109 Files)
This is what are written there:
library!ReportServer_0-44!1040!04/25/2013-07:45:50:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:50:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:50:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:50:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:50:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:50:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:50:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:50:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:51:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:51:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:51:: Call to ListChildrenAction(/ConfigMgr_DMS/Administrative Security, True).
library!ReportServer_0-44!1040!04/25/2013-07:45:51:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:51:: Call to GetPropertiesAction(/ConfigMgr_DMS/Administrative Security, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:51:: Call to ListChildrenAction(/ConfigMgr_DMS/Administrative Security, True).
library!ReportServer_0-44!1040!04/25/2013-07:45:51:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:51:: Call to GetPropertiesAction(/ConfigMgr_DMS/Administrative Security, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:51:: Call to ListChildrenAction(/ConfigMgr_DMS/Administrative Security, True).
library!ReportServer_0-44!1040!04/25/2013-07:45:51:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:52:: Call to GetPropertiesAction(/ConfigMgr_DMS/Administrative Security, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:52:: Call to ListChildrenAction(/ConfigMgr_DMS/Administrative Security, True).
library!ReportServer_0-44!1040!04/25/2013-07:45:52:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:52:: Call to GetPropertiesAction(/ConfigMgr_DMS/Administrative Security, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:52:: Call to ListChildrenAction(/ConfigMgr_DMS/Administrative Security, True).
library!ReportServer_0-44!1040!04/25/2013-07:45:52:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:52:: Call to GetPropertiesAction(/ConfigMgr_DMS/Administrative Security, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:52:: Call to ListChildrenAction(/ConfigMgr_DMS/Asset Intelligence, True).
library!ReportServer_0-44!1040!04/25/2013-07:45:52:: Call to GetPropertiesAction(/ConfigMgr_DMS, PathBased).
library!ReportServer_0-44!1040!04/25/2013-07:45:52:: Call to GetPropertiesAction(/ConfigMgr_DMS/Asset Intelligence, PathBased).
I am not a SQL Specialist but that this is not normal i can see.
Has anyone an Idea what this is or what i can do, the System a little bit Laggy.
greetz and thx
aaj

post-2317-0-72525700-1366875589_thumb.jpg

Share this post

Link to post
Share on other sites
kostoprav Newbie

kostoprav

Posted
Posted

Hello!

 

I have exactly the same problem with my SCCM 2012 SP1 server. The problem started before I have had installed SP1. Trying to fix issue I have installed SP1 over existing installation, but no luck nor visible progress.

 

ReportingServicesService.exe is eating my servers cpu. Spike starts every minute then goes down for a minute and start over again after one minute. I will post some explaining screenshots below.

I am not SQL experts. For me it looks like SCCM is running some reports enumerations tasks every minute.

 

 

srsrp.log:

 

....

Folder [/ConfigMgr_RBP/Software - Companies and Products] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:16.631-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software - Files] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:16.831-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Distribution - Application Monitoring/Software Distribution - Application Monitoring - Hidden] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:17.298-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Distribution - Application Monitoring] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:17.298-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Distribution - Collections] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:17.426-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Distribution - Content] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:17.905-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Distribution - Package and Program Deployment] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:18.116-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Distribution - Package and Program Deployment Status] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:18.320-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Metering] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:18.872-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Updates - A Compliance] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:19.192-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Updates - B Deployment Management] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:19.515-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Updates - C Deployment States] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:19.764-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Updates - D Scan] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:19.932-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Software Updates - E Troubleshooting] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:20.105-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/State Migration] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:20.233-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Status Messages/Status Messages - Hidden] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:20.333-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Status Messages] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:20.333-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Status Messages - Audit] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:20.467-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Task Sequence - Deployment Status] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:20.921-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Task Sequence - Deployments] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:21.379-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Task Sequence - Progress] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:21.590-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Task Sequence - References] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:21.652-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/User - Device Affinity] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:21.746-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Users] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:21.880-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Virtual Applications] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.060-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP/Wake On LAN] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.269-120><thread=3028 (0xBD4)>
Folder [/ConfigMgr_RBP] is kept $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.287-120><thread=3028 (0xBD4)>
Invalid class $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.313-120><thread=3028 (0xBD4)>
Could not retrieve the reporting service name for instance 'MSSQLSERVER' $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.314-120><thread=3028 (0xBD4)>
Invalid class $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.329-120><thread=3028 (0xBD4)>
Could not stop the reporting service '' $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.329-120><thread=3028 (0xBD4)>
Next security configuration at [2013.02.08. 13:16:51] $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.869-120><thread=3028 (0xBD4)>
Root Folder exists $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.869-120><thread=3028 (0xBD4)>
Successfully checked that the SRS web service is healthy on server RONIS.RBP.lv~ $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.869-120><thread=3028 (0xBD4)>
~Waiting for changes for 1 minutes $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.869-120><thread=3028 (0xBD4)>
SRSRP registry key change notification triggered.~ $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.869-120><thread=3028 (0xBD4)>
~Waiting for changes for 1 minutes $$<SMS_SRS_REPORTING_POINT><02-08-2013 13:11:22.870-120><thread=3028 (0xBD4)>

 

ReportServerService.log

...

library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).

library!ReportServer_2-2-130047685099410381!d70!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!d70!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!d70!02/08/2013-13:00:01:: Call to ListChildrenAction(/ConfigMgr_RBP/Task Sequence - Deployments, False).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to ListChildrenAction(/ConfigMgr_RBP/Task Sequence - Deployments, False).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!d70!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!d70!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!d70!02/08/2013-13:00:01:: Call to ListChildrenAction(/ConfigMgr_RBP/Task Sequence - Progress, False).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to ListChildrenAction(/ConfigMgr_RBP/Task Sequence - Progress, False).
library!ReportServer_2-2-130047685099410381!d70!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!1110!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
library!ReportServer_2-2-130047685099410381!d70!02/08/2013-13:00:01:: Call to GetPropertiesAction(/ConfigMgr_RBP, PathBased).
...

srsrp.log

ReportServerService.log

post-20488-0-63681900-1371130122_thumb.jpg

post-20488-0-66189300-1371130127_thumb.jpg

post-20488-0-06807900-1371130134_thumb.jpg

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.