MSSQL2000 Maximum Memory

Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinhold
Hi
You need to use:
Windows 2003 Enterprise Edition
SQL Server 2000 Enterprise Edition
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Reinhold" wrote:

> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>
>
|||See if this helps:
http://support.microsoft.com/default...274750&sd=tech
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinhold
|||> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
Assuming 32-bit, you need Windows 2003 Server Enterprise Edition and SQL
Server Enterprise Edition. SQL Server AWE needs to be enabled to address
over 3GB. Windows 2003 Standard has a 4GB max memory limitation and SQL
Server Standard is limited to 2Gb.
Windows 2003 system requirements:
http://www.microsoft.com/windowsserv...s/default.mspx
How to configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/default...b;en-us;274750
Hope this helps.
Dan Guzman
SQL Server MVP
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>

MSSQL2000 Maximum Memory

Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinholdHi
You need to use:
Windows 2003 Enterprise Edition
SQL Server 2000 Enterprise Edition
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Reinhold" wrote:

> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>
>|||See if this helps:
http://support.microsoft.com/defaul...;274750&sd=tech
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinhold|||> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
Assuming 32-bit, you need Windows 2003 Server Enterprise Edition and SQL
Server Enterprise Edition. SQL Server AWE needs to be enabled to address
over 3GB. Windows 2003 Standard has a 4GB max memory limitation and SQL
Server Standard is limited to 2Gb.
Windows 2003 system requirements:
http://www.microsoft.com/windowsser...qs/default.mspx
How to configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/defaul...kb;en-us;274750
Hope this helps.
Dan Guzman
SQL Server MVP
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>

MSSQL2000 Maximum Memory

Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinholdHi
You need to use:
Windows 2003 Enterprise Edition
SQL Server 2000 Enterprise Edition
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Reinhold" wrote:
> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>
>|||See if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinhold|||> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
Assuming 32-bit, you need Windows 2003 Server Enterprise Edition and SQL
Server Enterprise Edition. SQL Server AWE needs to be enabled to address
over 3GB. Windows 2003 Standard has a 4GB max memory limitation and SQL
Server Standard is limited to 2Gb.
Windows 2003 system requirements:
http://www.microsoft.com/windowsserver2003/evaluation/sysreqs/default.mspx
How to configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>

MSSQL/Server setup/running issue/question...

i have a client with a windows 2003 server with 4 processors & 32 GB RAM, then MSSQL 2000 SP3. our software seems to run fine on it until the Task Manager shows the MSSQL using 1.7GB of RAM. At this point the whole system seems to slow down to a snails pace. Any ideas as to why 1.7GB and it never goes over that amount no matter how much activity i run on it. Restart mssql and everything seems to run good up until we see the 1.7GB again.Quite simple: The server is installed with 32-bit edition of the OS and SQL Server 2000. You can increase the memory usage of SQL server to approx 2.7GB by using the /3GB switch in boot.ini, or use AWE to use memory above 4GB, but I won't recommend it since it works more or less like himem.sys and emm386 in the old days. What you should do is really reinstall the server, using 64-bit edition of both the OS and SQL Server software. Unless there is some piece of software or hardware which is not supported in the 64-bit edition.

MSSQL Server 2000 Memory Grows Incrementally

Hi All
My SQL Server keeps on taking memory(RAM) on the server without
releasing it.
There seems to be a memory leak.
On every query that gets executed the memory occupied by MSSQL grows.
Does this make the subsequent queries execute slowly?
Also even though i execute the same query multiple time the memory size
still increases.
What could be the possible reason for this?
Thanks & Regards
Vishal.
Vishal wrote:
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>
This is normal behavior. SQL Server will cache data pages in memory as
they are loaded from disk. It won't release memory unless it is
configured for dynamic memory allocation, AND the OS requests it.
Having SQL data cached in memory is a good thing, let it use as much as
it needs.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||The behaviour you are seeing is by design. Here is a KB article on the
subject:
INF: SQL Server Memory Usage
http://support.microsoft.com/default...;en-us;q321363
Keith Kratochvil
"Vishal" <vishal.bhute@.gmail.com> wrote in message
news:1160134477.258235.198120@.h48g2000cwc.googlegr oups.com...
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>
|||Dear Tracy,
How to set up the "dynamic memory allocation" ?
Thanks
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:4526486E.4090509@.realsqlguy.com...
> Vishal wrote:
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it. Having
> SQL data cached in memory is a good thing, let it use as much as it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|||Thanks Tracy
How to configure dynamic Memory Allocation?
Rgds
Vishal.
Tracy McKibben wrote:
> Vishal wrote:
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it.
> Having SQL data cached in memory is a good thing, let it use as much as
> it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|||Vishal wrote:
> Thanks Tracy
> How to configure dynamic Memory Allocation?
See "Server Memory Options" under "Setting Configuration Options" in
Books Online...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Dear Tracy,
Thank you for your advice.
Peter
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452B94DC.8000706@.realsqlguy.com...
> Vishal wrote:
> See "Server Memory Options" under "Setting Configuration Options" in Books
> Online...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

MSSQL Server 2000 Memory Grows Incrementally

Hi All
My SQL Server keeps on taking memory(RAM) on the server without
releasing it.
There seems to be a memory leak.
On every query that gets executed the memory occupied by MSSQL grows.
Does this make the subsequent queries execute slowly?
Also even though i execute the same query multiple time the memory size
still increases.
What could be the possible reason for this?
Thanks & Regards
Vishal.Vishal wrote:
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>
This is normal behavior. SQL Server will cache data pages in memory as
they are loaded from disk. It won't release memory unless it is
configured for dynamic memory allocation, AND the OS requests it.
Having SQL data cached in memory is a good thing, let it use as much as
it needs.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||The behaviour you are seeing is by design. Here is a KB article on the
subject:
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
--
Keith Kratochvil
"Vishal" <vishal.bhute@.gmail.com> wrote in message
news:1160134477.258235.198120@.h48g2000cwc.googlegroups.com...
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>|||Dear Tracy,
How to set up the "dynamic memory allocation" ?
Thanks
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:4526486E.4090509@.realsqlguy.com...
> Vishal wrote:
>> Hi All
>> My SQL Server keeps on taking memory(RAM) on the server without
>> releasing it.
>> There seems to be a memory leak.
>> On every query that gets executed the memory occupied by MSSQL grows.
>> Does this make the subsequent queries execute slowly?
>> Also even though i execute the same query multiple time the memory size
>> still increases.
>> What could be the possible reason for this?
>> Thanks & Regards
>> Vishal.
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it. Having
> SQL data cached in memory is a good thing, let it use as much as it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks Tracy
How to configure dynamic Memory Allocation'
Rgds
Vishal.
Tracy McKibben wrote:
> Vishal wrote:
> > Hi All
> >
> > My SQL Server keeps on taking memory(RAM) on the server without
> > releasing it.
> > There seems to be a memory leak.
> > On every query that gets executed the memory occupied by MSSQL grows.
> > Does this make the subsequent queries execute slowly?
> >
> > Also even though i execute the same query multiple time the memory size
> > still increases.
> > What could be the possible reason for this?
> >
> > Thanks & Regards
> > Vishal.
> >
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it.
> Having SQL data cached in memory is a good thing, let it use as much as
> it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Vishal wrote:
> Thanks Tracy
> How to configure dynamic Memory Allocation'
See "Server Memory Options" under "Setting Configuration Options" in
Books Online...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Dear Tracy,
Thank you for your advice.
Peter
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452B94DC.8000706@.realsqlguy.com...
> Vishal wrote:
>> Thanks Tracy
>> How to configure dynamic Memory Allocation'
> See "Server Memory Options" under "Setting Configuration Options" in Books
> Online...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

MSSQL Server 2000 Memory Grows Incrementally

Hi All
My SQL Server keeps on taking memory(RAM) on the server without
releasing it.
There seems to be a memory leak.
On every query that gets executed the memory occupied by MSSQL grows.
Does this make the subsequent queries execute slowly?
Also even though i execute the same query multiple time the memory size
still increases.
What could be the possible reason for this?
Thanks & Regards
Vishal.Vishal wrote:
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>
This is normal behavior. SQL Server will cache data pages in memory as
they are loaded from disk. It won't release memory unless it is
configured for dynamic memory allocation, AND the OS requests it.
Having SQL data cached in memory is a good thing, let it use as much as
it needs.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||The behaviour you are seeing is by design. Here is a KB article on the
subject:
INF: SQL Server Memory Usage
http://support.microsoft.com/defaul...b;en-us;q321363
Keith Kratochvil
"Vishal" <vishal.bhute@.gmail.com> wrote in message
news:1160134477.258235.198120@.h48g2000cwc.googlegroups.com...
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>|||Dear Tracy,
How to set up the "dynamic memory allocation" ?
Thanks
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:4526486E.4090509@.realsqlguy.com...
> Vishal wrote:
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it. Having
> SQL data cached in memory is a good thing, let it use as much as it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks Tracy
How to configure dynamic Memory Allocation'
Rgds
Vishal.
Tracy McKibben wrote:
> Vishal wrote:
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it.
> Having SQL data cached in memory is a good thing, let it use as much as
> it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Vishal wrote:
> Thanks Tracy
> How to configure dynamic Memory Allocation'
See "Server Memory Options" under "Setting Configuration Options" in
Books Online...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Dear Tracy,
Thank you for your advice.
Peter
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452B94DC.8000706@.realsqlguy.com...
> Vishal wrote:
> See "Server Memory Options" under "Setting Configuration Options" in Books
> Online...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com