It is not that simple, but Steve Thompson did a great job describing how to optimize those databases:
http://stevethompsonmvp.wordpress.com/2013/05/07/optimizing-configmgr-databases/ It uses the Ola script and gives two other scripts to set things up. You only need to change 3 lines in all of the scripts (two in the first and one in the Ola script) and then edit the new job properties. Very simple and easy to follow instructions. On Thu, Jul 10, 2014 at 9:39 AM, HELMS, DAVID C <[email protected]> wrote: > That’s what I have heard, but not exactly sure what all I need to do. > > > > Is it just a matter of downloading the maintenancesolution.sql script and > importing it in? > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *David O'Brien > *Sent:* Thursday, July 10, 2014 9:22 AM > > *To:* [email protected] > *Subject:* RE: [mssms] SCCM 2012 Indexing issue > > > > ***This is an EXTERNAL email. Please do not click on a link or open any > attachments unless you are confident it is from a trusted source. > ------------------------------ > > > > Implement Ola's solution for SQL, you'll very likely notice some > improvement after that. Don't rely on the built-in task. > > Sent from my Windows Phone > ------------------------------ > > *From: *Daniel Ratliff <[email protected]> > *Sent: *10/07/2014 10:25 PM > *To: *[email protected] > *Subject: *RE: [mssms] SCCM 2012 Indexing issue > > I will confirm with our admins, but we have had SQL issues all week and I > think upgrading SQL 2012 to SP2 resolved all of our issues. > > > > *Daniel Ratliff* > > > > *From:* [email protected] > [mailto:[email protected]] *On Behalf Of *HELMS, DAVID C > *Sent:* Thursday, July 10, 2014 8:20 AM > *To:* [email protected] > *Subject:* [mssms] SCCM 2012 Indexing issue > > > > I am having very poor performance within our SCCM console (software > updates) and other issues like running reports via SSRS. I have found > several sites talking about how the SQL maintenance for rebuilding indexes > isn’t working like it should and this is likely the root cause. > > > > I found the following link that others referenced to rebuild the indexes, > but I’m not a SQL guy so I’m a little unclear on what all I should do. > > > > http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html > > > > Is anyone experienced these types of issues and if you would share how you > were able to resolve this. > > > > > > > The information transmitted is intended only for the person or entity to > which it is addressed > and may contain CONFIDENTIAL material. If you receive this > material/information in error, > please contact the sender and delete or destroy the material/information. > > > >
