Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I had 1 million records inserted par day. and my front end is c#.net 4.0.

So what is the best option for database server to gain the best performance. this is my par day traffic.

Oracle 11g vs MS Sql Server 2008 R2

share|improve this question

closed as not constructive by SvW, Chopper3 Sep 22 '11 at 10:32

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.

1 Answer

Your design, code and indexing matter far more than your choice of RDBMS. Or a poor choice of disk layout (eg one RAID 5 volume for everything)

In this case, SQL Server because your are using .net. That's all.

share|improve this answer
Thanks for your reply. – Ronak Sep 22 '11 at 10:56

Not the answer you're looking for? Browse other questions tagged or ask your own question.