Configuration Manager 2012 Content Status Slow

When in the console for Systems Center Configuration Manager and you select to view the content status.

<Monitoring>

  <Distribution Status>

    <Content Status>

This takes approx 10 minutes once selected to populate.   Understanding we have 943 items when it populates.  Is there a indexing problem.  The function it calls is "fn_ListObjectContentInfo"

Please advise

  • Moved by arnavsharmaMVP Saturday, August 17, 2013 3:45 PM Posted in SCCM 2007
August 14th, 2013 4:00pm

Possibly. Do you have the default re-indexing maintenance task enabled? Have you run a re-indexing and statistics update script directly in SQL Server on the DB?
Free Windows Admin Tool Kit Click here and download it now
August 14th, 2013 5:03pm

I have checked and the indexes show as being last ran as of this morning.  I also checked the fragmentation of the tables and they are low.

August 14th, 2013 5:48pm

We're seeing the same behavior. We're at 2012 Sp1 CU2.
Free Windows Admin Tool Kit Click here and download it now
August 26th, 2013 5:31pm

You can also have a look at http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html.

August 26th, 2013 8:04pm

Copy and paste the link into your browser and delete the trailing period.
August 26th, 2013 8:19pm

I didn't write this, but got it from a source I trust thoroughly. It dramatically increased our content status response times. All warnings apply - no support, test in your lab, etc..

DECLARE @TableName VARCHAR(255) 
DECLARE @sql NVARCHAR(500) 
DECLARE @fillfactor INT 
SET @fillfactor = 80 
DECLARE TableCursor CURSOR FOR 
SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableName 
FROM sys.tables 
OPEN TableCursor 
FETCH NEXT FROM TableCursor INTO @TableName 
WHILE (@@FETCH_STATUS != -1) 
BEGIN 
SET @sql = 'ALTER INDEX ALL ON ' + @TableName + ' REBUILD WITH (ONLINE=OFF,MAXDOP=1,FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')' 
PRINT @sql 
EXEC (@sql) 
FETCH NEXT FROM TableCursor INTO @TableName 
END 
CLOSE TableCursor 
DEALLOCATE TableCursor 
GO 
 
EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN, ALL' 

Free Windows Admin Tool Kit Click here and download it now
September 9th, 2013 2:32pm

Does someone have a solution for this...in my environment the view in the console of Content Status also takes more then 10 minutes....very long !!!

How to solve this, create additional Index in SQL ?

November 27th, 2014 10:57am

Does someone have a solution for this...in my environment the view in the console of Content Status also takes more then 10 minutes....very long !!!

How to solve this, create additional Index in SQL ?

Assuming that you followed the suggestion above, did you see any difference? Did you check the performance of you site server and SQL server?
Free Windows Admin Tool Kit Click here and download it now
November 27th, 2014 11:34am

Does someone have a solution for this...in my environment the view in the console of Content Status also takes more then 10 minutes....very long !!!

Please avoid double postings. You already asked the same question in another thread (where Jrgen already provided a solution). Thanks
November 27th, 2014 1:09pm

https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

My listing of the device node was taking about 5 minutes. I implemented the solution in the link above using example A and it went down to less than 1 minute.  I ran the MaintenanceSolution.sql  script from the SQL tools and then took example A and pasted it into a new query. The query ran for 15 minutes and the message tab showed each procedures success.  Really amazing the difference. I don't have any DBA knowledge so I took a giant leap of faith. It worked that's all I can say. 

Free Windows Admin Tool Kit Click here and download it now
June 18th, 2015 3:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics