Monday, March 12, 2012

Multiple TB SQL 2000 Databases

I'm a SQL DBA but have only dealt with databases less than 1 TB in
size. Some of my programmers are asking how well SQL 2000 will handle
a 5 TB database. We're wondering if SQL is sufficient of if we need
to go to Oracle. I know the SQL 2000 specs say it can handle it but
I'm looking for real world experiences.SQL Server can handle much more data than that and does every day if done
properly. I can bring a server to it's knees with a 10MB database with a
poor schema and a poor app etc. With a proper design and planning size
really shouldn't matter.
Andrew J. Kelly SQL MVP
"Charles Crosby" <crosbyct@.yahoo.com> wrote in message
news:8433ccee.0403101124.280f58a8@.posting.google.com...
> I'm a SQL DBA but have only dealt with databases less than 1 TB in
> size. Some of my programmers are asking how well SQL 2000 will handle
> a 5 TB database. We're wondering if SQL is sufficient of if we need
> to go to Oracle. I know the SQL 2000 specs say it can handle it but
> I'm looking for real world experiences.

No comments:

Post a Comment