Date parsed: 19/10/2007 01:46:24
Date: Fri, 19 Oct 2007 06:46:24 -0500

> Could you guys please give your inputs on the pros and cons of Sql Server
> to
> Oracle migration,or will sql server be able to take this kind of load?

SQL Server and Oracle (and DB2 for that matter) are enterprise class
database products. I have no doubt that you could succeed with either
product. You could also fail miserably with either product due to a lousy
database or application design.

We use SQL Server as a back end to our IIS web farm and have the web best
response time of any of our competitors. Our volumes and number of users
are orders of magnitude higher than the stats you mention. In terms of
hardware, one of our main servers is similar to the DELL 6850 that's #2 on
the TPC-E list (http://www.tpc.org/tpce/tpce_perf_results.asp) except with
less memory and SAN storage.

Since you already have SQL Server and corresponding expertise, I don't see a
compelling reason to switch to another DBMS, although you might consider
upgrading to SQL 2005. SQL 2008 is just around the corner.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"jiten" <jiten@discussions.microsoft.com> wrote in message
news:21F7F4BE-F9D8-4179-AD5F-0B31A6D46C63@microsoft.com...
> Hello,
>
> We have an asp.net web application with server/stats as follows-
> Database server- Sql server 2000
> Web server - IIS 6
> Database size - about 5 million records
> No of users- 1000
>
> Since the size of the database and number of users are growing fast, there
> is a concern, will sql server be able to handle the load.Migrating
> database
> to Oracle is on the cards.
> Could you guys please give your inputs on the pros and cons of Sql Server
> to
> Oracle migration,or will sql server be able to take this kind of load?
>
> Cheers,
> Jiten

Date parsed: 19/10/2007 11:23:11
Date: Fri, 19 Oct 2007 11:23:11 -0000

On 19 Oct, 11:49, jiten <ji...@discussions.microsoft.com> wrote:
> Hello,
>
> We have an asp.net web application with server/stats as follows-
> Database server- Sql server 2000
> Web server - IIS 6
> Database size - about 5 million records
> No of users- 1000
>
> Since the size of the database and number of users are growing fast, there
> is a concern, will sql server be able to handle the load.Migrating database
> to Oracle is on the cards.
> Could you guys please give your inputs on the pros and cons of Sql Server to
> Oracle migration,or will sql server be able to take this kind of load?
>
> Cheers,
> Jiten


1000 users and 5 million rows is not large for SQL Server. The only
significant constraint on performance will be your hardware and your
application design, not the DBMS.

You can find case studies and benchmarks for SQL Server at
http://www.microsoft.com/sql/default.mspx - including benchmarks and
workings systems for x0,000s of users and a TPC-C benchmark of more
than 1 million transactions per minute.

--
David Portas