Not tested yet, but interesting …
If your SCCM console has ground to a halt then it’s more than likely that you need to run indexing on the SQL DB to sort your problem out.
The SCCM Site Maintenance Tasks have a built-in task you can enable to do this but you can also download Ola Hallengren’s SQL Server Maintenance Solution which is a cool SQL script that you can use to perform this and the script also comes with some pretty handy solutions for DB backup and integrity checking.
You can download the solution from here
Once downloaded, open up the .sql file in Notepad and edit the backup location in the line ‘SET @BackupDirectory = N’C:Backup’ — Specify the backup root directory.’ and choose a backup location that you prefer. You won’t need the backup directory for indexing but it’s worth setting as you can then use the cool DB backup scripts at your leisure.
View original post 124 more words