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<mailto:[email protected]> Sent: 10/07/2014 10:25 PM To: [email protected]<mailto:[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]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of HELMS, DAVID C Sent: Thursday, July 10, 2014 8:20 AM To: [email protected]<mailto:[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.
