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.
