MS SQL 2000 Standard Edition Capability

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
Standard edition from memory only supports up to 2Gb of memory. This might
prove problematic depending on how the wareohuse is used.
"Alexander Zotkin" <a@.a> wrote in message
news:emLy0OSDFHA.2220@.TK2MSFTNGP09.phx.gbl...
> 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
>
|||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.
"Scott Delaney" wrote:

> Standard edition from memory only supports up to 2Gb of memory. This might
> prove problematic depending on how the wareohuse is used.
>
> "Alexander Zotkin" <a@.a> wrote in message
> news:emLy0OSDFHA.2220@.TK2MSFTNGP09.phx.gbl...
>
>
|||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/pro.../anservog.mspx
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
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.
"Alexander Zotkin" <a@.a> wrote in message
news:emLy0OSDFHA.2220@.TK2MSFTNGP09.phx.gbl...
> 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
>
|||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
"Tomasz Borawski" <TomaszBorawski@.discussions.microsoft.com> wrote in
message news:C4C34AFB-6747-4CD9-BB7B-12CE782BAED0@.microsoft.com...
> 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.
> "Scott Delaney" wrote:
>