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?