I run it with the default options, and just indexing the CM database. Checking fragmentation before and after, it made a huge difference.
Also, to clarify on Daniel’s comment, SQL 2012 SP2 was not a magic bullet. We are still working with Microsoft Support on post-R2 SQL performance issues, and looking to bump up SQL Server resources as well. Duncan Russell Technical Architect | Acquisitions and Configuration Management Software Humana 123 E. Main St. Ste. 600 | Louisville, KY 40202 T 502.476.3345 C 502.767.6047 F 502.508.2004 [email protected]<mailto:[email protected]> Humana.com From: [email protected] [mailto:[email protected]] On Behalf Of Todd Hemsell Sent: Friday, July 11, 2014 10:30 AM To: [email protected] Subject: Re: [mssms] SCCM 2012 Indexing issue bueller, bueller, anyone... On Thu, Jul 10, 2014 at 1:38 PM, Todd Hemsell <[email protected]<mailto:[email protected]>> wrote: what command options do you run it with? On Thu, Jul 10, 2014 at 1:10 PM, Lindenfeld, Ivan <[email protected]<mailto:[email protected]>> wrote: Strong endorsement for Ola’s script. It’s so good our DBA’s stole it. Ivan Lindenfeld FNF Jacksonville From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of David O'Brien Sent: Thursday, July 10, 2014 9:22 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] SCCM 2012 Indexing issue 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]] 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. ________________________________ NOTICE: The information contained in this message is proprietary and/or confidential and may be privileged. If you are not the intended recipient of this communication, you are hereby notified to: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. 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.
