We have calculated the initial database size for this implementation to be 2TB, rising by 1TB per year. How much memory would you recommend for the server?
Its a business application, reads and writes across 100 tables. The server wont be upgraded for 3 years.
75% of the data will be historic, 200 transactions per second.