etechpartner
Starting Member
3 Posts |
Posted - 12/23/2012 : 11:55:29
|
I need to set up a VM ( or physical machine ) for a web application that looks a lot like Quicken Online ( Accounting System ). It will have approximately 100 concurrent users and 500 total users to start with. Using either SQL 2008R3 or 2012, could you please recommend a machine config and DB settings that make the most sense. Is it a good idea to use SSD drives? Should tempdb have its own drive and number of files equal to cores used by the machine. For low user count like this, with low frequency of commits, should the db be set to READ_COMMITED_SNAPSHOT Any best practice suggestions? This is a completely new setup so I am very open to recommendations from this forum. |
|