Appreciate it Daniel. Currently on SQL 2012 SP1. From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Thursday, July 10, 2014 8:24 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. ________________________________ 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.
