MS SQL 2000 Standard Edition Capability

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alexander Zotkin - 07 Feb 2005 14:45 GMT

Hi,
I'm about to build data warehouse of approx 15 Gb. The biggest table is
expected to be of 10 000 000 records. How will MS SQL 2000 Standard Edition
cope with it?

Thanks,
Alex

Reply to this Message

Scott Delaney - 07 Feb 2005 23:23 GMT

Standard edition from memory only supports up to 2Gb of memory. This might
prove problematic depending on how the wareohuse is used.

> Hi,
> I'm about to build data warehouse of approx 15 Gb. The biggest table is
[quoted text clipped - 4 lines]
> Thanks,
> Alex

Reply to this Message

Tomasz Borawski - 11 Feb 2005 11:51 GMT

Hi,

Scott, you are wrong. If Sql Server Standard Edition is running on Windows
2000 Advance Server or Windows 2003 Server and /3GB switch is on in boot.ini,
Sql Server Standard Edition support up to 3GB.

It’s really a small data warehouse. If you don’t break data warehouse rules
in design and you will create necessary indexes, it will work ok.

Tomasz B.

> Standard edition from memory only supports up to 2Gb of memory. This might
> prove problematic depending on how the wareohuse is used.
[quoted text clipped - 7 lines]
> > Thanks,
> > Alex

Reply to this Message

Ray - 13 Feb 2005 22:51 GMT

Actually Tomasz you are incorrect and Scott is correct. While it is true
that you can enable the /3GB switch SQL Standard is hardcoded to not go
above 2GB.

Alex,
It all boils down to requirements and expectations but with a reasonable
design and proper indexing a 15GB warehouse is well within SQL Standards
capability.

Ray

> Hi,
>
[quoted text clipped - 22 lines]
>> > Thanks,
>> > Alex

Reply to this Message

Dave Wickert [MSFT] - 11 Feb 2005 15:25 GMT

I doubt if you will have any problems. 10M fact records is a very small
database. Unless there are other issues, such as several large dimensions,
you will be fine with Standard Edition. As you get into more complex
applications, you might start reading and thinking about the various best
practices outlined in the following two Guides:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx

Signature

Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi,
> I'm about to build data warehouse of approx 15 Gb. The biggest table is
[quoted text clipped - 3 lines]
> Thanks,
> Alex

Reply to this Message