SCCM 2012 Poor Console Performance In Software Updates

UPDATE 5/21/2013: Just heard from the MVP community that some folks are referencing this article to improve performance: http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

From within Microsoft SQL Management Studio, run the query below to check fragmentation:

1
2
3
4
5
6
7
8
9
SELECT a.index_id, name, avg_fragmentation_in_percent FROM
 
sys.dm_db_index_physical_stats (NULL,NULL, NULL, NULL, NULL) AS a JOIN sys.indexes
 
AS b ON a.object_id = b.object_id AND a.index_id = b.index_id WHERE
 
avg_fragmentation_in_percent > 30
 
GO

 

2)    Run this command on the tables:

1
2
3
Exec sp_MSForEachtable 'DBCC DBREINDEX (''?'')'
 
go

 

3)    Once this was done, run the “Rebuild Indexes” task from Site Maintenance of the primary server.

 

4)    Finally run this command back on the SQL Server via SQL Management Studio.

1
2
3
EXEC sp_MSForEachTable "UPDATE STATISTICS ? with fullscan"
 
GO

 

 

This entry was posted in Configuration Manager, System Center 2012.

One Response to SCCM 2012 Poor Console Performance In Software Updates

  1. Pingback: SCCM SQL Queries Mega-Pack | automatizeblog

Leave a Reply