Thats kind of like asking us what kind of car you should buy.

1) you need to determine where your bottlenecks are

2) you need to determine if your locking scheme is correct

3) you need to determine if your indexing scheme is correct

4) you need to determine if you need RI

5) you need to establish maintenance process for the database (compacting data, updating statistics, etc.)