I am currently developing a project with a huge amount of database transactions.
My estimate is around 70,000 inserts/updates/deletes/selects every 2 minutes, since I am not there yet, I can only estimate, but in the near future, it'll get there.
Since I am not a DBA, I'd like to hear your opinion.
I am running on a Windows Server 2008 R2 and I thought I can use SQL Server 2008 R2, the questions is, how many processors and what type exactly of SQL Server I need to use? there are plenty like Enterprise, Standard, Web Edition, etc.
Any suggestions folks?
Best Answer
It is difficult to estimate server load based on "number of transactions" because cost of a transaction can vary greatly depending on the design of your DB and the nature of the query. Enterprise and Datacenter editions are your versions to consider for situations with high volume and high scalability. Microsoft has comparison charts showing what the processor/memory limitations are for each, extra features, and virtualization restrictions. (Search: SQL Server version comparison)
What type of application is this supporting and for what business type? Will it be performing strictly transactional OLTP tasks or are you looking to support reporting and analysis with (a separate instance of) the same product?