4 Replies Latest reply on Dec 18, 2012 6:44 AM by hilbertd21

    Index rebuilds on Windows SQL 2008 R2


      NPM and NCM tables on a dedicated SQL instance using Windows Server 2008 R2 Standard on a NPM 10.4 and NCM 7.1.1., are averaging over 90% fragmentation.


      Therefore, we've scheduled index rebuilds, and given we are using  standard version, see that online rebuilds are not possible.


      Given that, wanted to see procedurally if this mainatenance is as simple as:


      1.) Ensure recent backups of NetPerfMon and ConfigMgmt dbases

      2.) Shut down ALL services on our integrated NPM/NCM instance

      3.) Perform the index rebuilds

      4.) Turn on ALL Orion services on NPM/NCM instance


      Thanks! Doug