RE: MS SQL Standard Edition Memory.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kumar Part (Part_at_discussions.microsoft.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 16:17:01 -0700

2GB address space is per SQLServer process(sqlserver.exe). It is nothing to
do with the processor. You can increase the SQLServer address space by
setting /3GB switch in boot.ini

This will leave just 1 GB for OS. May interfere with some of your video
drivers

-kumar

"ddavids@idfbins.com" wrote:

> I understand that MS SQL Standard Edition has a 2GB memory
> limit. Windows 2000 server supports 4GB of memory. My
> hardware supports two processors. If I license per
> Processor method and install two processors and license
> two Standard editions will there be 2GB of memory per
> processor or 2GB for both processors?
>
> Thanks
>
>

Relevant Pages

  • Questions about the SQL Server 2000 Devleopment Licence
    ... I'm about to set up a project for SQLServer 2000 ... Enterprise Edition and do not want to have the full product ... Is the ReportServer included in the dev-license ...
    (microsoft.public.sqlserver.server)
  • Re: Disk or Network Error
    ... Oh, as I 'm learning with ASP.NET, I'd switch do the switch to SQLServer ... it has triggers, the triggers get deleted as well...D'oh! ... but if you're on a wireless connection ... ...
    (microsoft.public.access.modulesdaovba)
  • Re: Available Scsi Bandwidth
    ... yes, SQLServer is really IO bound, but when you have enough memory, this will be memory IO instead of disk IO, so you could say that SQLSErver is a memory intensive application instead of an IO intensive application. ... No matter how fast you disk and disk controllers are, ... the controllers you mention have a 2Gb/sec per channel peak bandwidth. ...
    (microsoft.public.windows.server.general)
  • Re: Available Scsi Bandwidth
    ... will be memory IO instead of disk IO, so you could say that SQLSErver is a memory intensive application instead of an IO intensive application. ... No matter how fast you disk and disk controllers are, ... In an optimum situation, SQLServer only needs the disks to for inserts, updates and deletes, not for selects. ... the controllers you mention have a 2Gb/sec per channel peak bandwidth. ...
    (microsoft.public.windows.server.general)
  • Re: Why the memory usage of SqlServer doesnt go down
    ... Because after we exit our system, there is no memory ... SQLServer can just hold 512M memory. ... shrink memory usage if there is no more database accessing. ...
    (comp.databases.ms-sqlserver)