Netflow Database Maintenance Best Practices

Question

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.

Donald_Francis · Answer

I would personally say a nightly reindex is overdoing it especially since with a large DB like that maintenance will be running for a good time each night as well.

ET · Answer

Please don't use flag /3GB in boot.ini. We have customers which had problem with that.

Please read follow link:

Understanding socket error

Thanks