please help
Advice on how to design good performance for a database of 72GB planning to grow up to 778GB in the next two years
1. A database design to support the volumes, i.e. the separation of the physical files, layout of the database and so on.
2. Table and index partitioning. At the Phase 1 volume there are some tables between 5-10GB however going to Phase 2 these tables are in between 50-100GB. How do we best handle these tables, i.e. does SQL Server allow partitioning, should be looking at file groups and so on.
3. Thoughts about the transaction log and it's management.
4. Thoughts about the temp DB and its management.
5. Database configuration parameters, i.e. memory setting, initialization parameters and the like.
5. What version of SQL Server do we have here, I'm assuming we need Enterprise Edition to accommodate a large memory allocation, i.e. > 2GB.
pleaase help this is urgent