1 Reply Latest reply on Aug 11, 2017 3:20 PM by wlouisharris

    NPM 12.01 database maintenance - not completing


      We have had ongoing issues with database maintenance(cases have been opened) with NPM version 12.01.


      1)We are running SQL 2014 on a Windows 2012 R2 server - 64 bit o/s.

      128GB RAM

      32 processors


      2)The recommended steps by support are to lower database retention rates on:


      • Lower retention settings on “Detailed statistics retention” and “Detailed UNDP statistics retention”



      3)Our customer needs to keep the retention settings.  We typically end up truncating the table - "Custompollerstatistics_detail"; then repeat database maintenance.  This table hits large row size:



      tablerowsdata sizeindex sizeunused
      CustomPollerStatistics_Detail695588513 105442344 KB91436616 KB43344 KB


      4)Another recommendation is moving to a physical server.  We have run I/O reports on other SQL servers and we have several other SQL servers of the same size(non Solarwinds); that are running on VM's.


      Just wondering if anyone else is facing this issue and what they are doing to resolve it.


      Thanks, WLH