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.
Thanks
