Data handling capabilities of SQL Server 2000 Enterprise Edition

I am developing an intranet portal on Microsoft .NET platform and using
SQL Server 2000 Enterprise Edition as the database.
I would like to know the maximum size to which the database can grow to
in SQL Server as many tables in the database will have over 1 million
records with each row having images, documents stored in it.
The server housing SQL Server is Dell PowerEdge 2950 with single CPU
dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.In reality the size of the database is limited by your disk space.
According to BOL the database size can be up to 1,048,516 TB (depending
on the edition that you have). If you meant to ask at what size the
database's performance will not be good, then that depends on the
database's structure, the quality of the code that works with the
database, the number of concurrent users and other factors much more
then it depends on the database's size.
Adi
ram2811 wrote:
> I am developing an intranet portal on Microsoft .NET platform and using
> SQL Server 2000 Enterprise Edition as the database.
> I would like to know the maximum size to which the database can grow to
> in SQL Server as many tables in the database will have over 1 million
> records with each row having images, documents stored in it.
> The server housing SQL Server is Dell PowerEdge 2950 with single CPU
> dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.|||"ram2811" <ram2811@.gmail.com> wrote in message
news:1163533063.339418.203140@.i42g2000cwa.googlegroups.com...
>I am developing an intranet portal on Microsoft .NET platform and using
> SQL Server 2000 Enterprise Edition as the database.
> I would like to know the maximum size to which the database can grow to
> in SQL Server as many tables in the database will have over 1 million
> records with each row having images, documents stored in it.
> The server housing SQL Server is Dell PowerEdge 2950 with single CPU
> dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.
In this case it sounds like the max size will be 73 GB.
I'd suggest NOT storing images in the database, but that's a different
debate.
btw, 1 million records is generally considered, "small" these days.
>|||thanks for the reply
Adi wrote:
> In reality the size of the database is limited by your disk space.
> According to BOL the database size can be up to 1,048,516 TB (depending
> on the edition that you have). If you meant to ask at what size the
> database's performance will not be good, then that depends on the
> database's structure, the quality of the code that works with the
> database, the number of concurrent users and other factors much more
> then it depends on the database's size.
> Adi
> ram2811 wrote:
> > I am developing an intranet portal on Microsoft .NET platform and using
> > SQL Server 2000 Enterprise Edition as the database.
> > I would like to know the maximum size to which the database can grow to
> > in SQL Server as many tables in the database will have over 1 million
> > records with each row having images, documents stored in it.
> > The server housing SQL Server is Dell PowerEdge 2950 with single CPU
> > dual Core Xeon 4MB Cache 3.0Ghz, 2GB memory, 73GB disk space and RAID 5.