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
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.
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.