Version 1

    I have had an issue over the couple of weeks where my polling engine quit updating the database.  I found a temporary fix and had to keep doing this every time the updating stopped.


    After opening a case with support, they pointed out a few performance problems.  One of these is that there were a lot of fragmented indexes.  By default that maintenance piece in solarwinds is not turned on.  After turning it on, i was directed to rebuild or reorganize all of the indexes manually.  If you ever run across an instance where you have to do this, i found a script, that i have attached, that will find all indexes over whatever percent you decide, and reorganize them.  You can actually run this in the SQL Job Agent as a maintenance.