1 of 1 people found this helpful
I was able to get this issue resolved with Solarwinds tech support help. Here is the solution.
Enable Index Defragmentation
This is to rebuild indexes of the tables on your solarwinds database. You can also do it manually if that would not work and let the Nightly database Maintenance to run.
Go to C:\ProgramData\Solarwinds\Logs\Orion and review the swdebugmaintenance.log
Look for the following warning. I had a bunch, but this is a snippet.
2016-02-11 12:56:29,566  WARN SolarWinds.Data.IndexDefragmentation.IndexDefragmenter - Indexes with fragmentation over 90% found during DB maintenance.
2016-02-11 12:56:29,566  WARN SolarWinds.Data.IndexDefragmentation.IndexDefragmenter - Index IX_InterfaceID on table InterfaceTraffic_Detail_20160210 has fragmentation 99.3311036789298% and should be defragmented.
You will need to rebuild the indexes manually. Use MS SQL management studio to do so. Will take a while but after its not, everything loads back.