2 Replies Latest reply on Sep 8, 2009 1:43 PM by Donald_Francis

    Netflow Database Maintenance Best Practices

      According to my net admins, things are "slow" and i need to make them faster.

      Status:

      DB size ~50G

      • Interesting delivered filegroup configuration (4 filegroups); not sure yet why the DB was originally setup this way. Thought: particular objects are assigned to FG's which can be allocated across disks?

      Here's what I plan to do:

      • Enable /3GB in boot.ini, PAE in SQL Server 2k5
      • Reindex nightly, current index framentation shows > 30% for 1/2 THE tables 
      • Move tempDB to it's own raid 1 array, keep Netflow DB on its own Raid10 array
      • keep db in SIMPLE recovery mode 

      Anyone else have input/ ideas?

      Thank You.