We have a database that is 750GB, 1 primary file group and 4 data files. The 4 data files is spread out on 4 disks.
To increase performance we would like to do the following:
- Archive old data.
- Isolate heavily used tables.
So my question is how should we go about this?
Should we use create more file groups, one for old data and let the newest data stay in the primary file group.
How to isolate heavily used tables, should we put them in filegroups as well?
We haven't tried this before so a detailed description would be appreciated.
Thanks a lot