Types:
1. Stand Alone - does not have analysis service and so you loose reporting capabilities. Not scalable
2. Server farm
Recommended / Based on requirement :
seperate data and application (with NLB and multiple boxes in each.)
Databases:
1. Draft - All changes until publishing
2. Published - all published content, security and timesheet information
3. Archive - backup project plans
4. Reporting - After project data is published, system write info to reporting db. Near real time information for reporting.
No comments:
Post a Comment