memory usage jumps

I have an instance of SQL server installed on a P3 1GHz with 512Mb RAM. This
is a small development machine so there's very little stress on it. SQL
server is pretty much the only app running as I turned off IIS and all web
server stuff.
When I start the server, the RAM usage is around 150Mb. After a little while
(seems random but within an hour) the RAM usage jumps to 600Mb. This is not
a gradual increase to 600Mb but rather a jump. If I restart the mssqlserver
service, then the RAM usage goes back down to 150Mb and the cycle starts
again.
There are only 6 DBs defined, I turned off all the jobs and there is no such
things as DTS etc... the config is very simple
Any idea what could be causing that?
ThanksIt doesn't take much to eat up a few 100 MB of ram. A large regular join or
Cartesian join can easily do this. I would suggest running profiler to see
what is happening when this occurs.
--
Andrew J. Kelly
SQL Server MVP
"Benoit Martin" <bmartin_hpu@.hotmail.com> wrote in message
news:ukTtPGTiDHA.2984@.TK2MSFTNGP11.phx.gbl...
> I have an instance of SQL server installed on a P3 1GHz with 512Mb RAM.
This
> is a small development machine so there's very little stress on it. SQL
> server is pretty much the only app running as I turned off IIS and all web
> server stuff.
> When I start the server, the RAM usage is around 150Mb. After a little
while
> (seems random but within an hour) the RAM usage jumps to 600Mb. This is
not
> a gradual increase to 600Mb but rather a jump. If I restart the
mssqlserver
> service, then the RAM usage goes back down to 150Mb and the cycle starts
> again.
> There are only 6 DBs defined, I turned off all the jobs and there is no
such
> things as DTS etc... the config is very simple
> Any idea what could be causing that?
> Thanks
>|||Try to avoid pulling data from the disk into the buffer pool. To do this,
avoid all DML, like Select's or Updates.
You should then see memory remain pretty constant.
"Benoit Martin" <bmartin_hpu@.hotmail.com> wrote in message
news:ukTtPGTiDHA.2984@.TK2MSFTNGP11.phx.gbl...
> I have an instance of SQL server installed on a P3 1GHz with 512Mb RAM.
This
> is a small development machine so there's very little stress on it. SQL
> server is pretty much the only app running as I turned off IIS and all web
> server stuff.
> When I start the server, the RAM usage is around 150Mb. After a little
while
> (seems random but within an hour) the RAM usage jumps to 600Mb. This is
not
> a gradual increase to 600Mb but rather a jump. If I restart the
mssqlserver
> service, then the RAM usage goes back down to 150Mb and the cycle starts
> again.
> There are only 6 DBs defined, I turned off all the jobs and there is no
such
> things as DTS etc... the config is very simple
> Any idea what could be causing that?
> Thanks
>|||what do you mean by DML?
do you mean replacing SELECT and UPDATE by stored procs?
"Anthony Zessin" <Anthony.Zessin@.rrtc.com> wrote in message
news:us3SVPWiDHA.2960@.TK2MSFTNGP11.phx.gbl...
> Try to avoid pulling data from the disk into the buffer pool. To do this,
> avoid all DML, like Select's or Updates.
> You should then see memory remain pretty constant.
>
> "Benoit Martin" <bmartin_hpu@.hotmail.com> wrote in message
> news:ukTtPGTiDHA.2984@.TK2MSFTNGP11.phx.gbl...
> > I have an instance of SQL server installed on a P3 1GHz with 512Mb RAM.
> This
> > is a small development machine so there's very little stress on it. SQL
> > server is pretty much the only app running as I turned off IIS and all
web
> > server stuff.
> >
> > When I start the server, the RAM usage is around 150Mb. After a little
> while
> > (seems random but within an hour) the RAM usage jumps to 600Mb. This is
> not
> > a gradual increase to 600Mb but rather a jump. If I restart the
> mssqlserver
> > service, then the RAM usage goes back down to 150Mb and the cycle starts
> > again.
> >
> > There are only 6 DBs defined, I turned off all the jobs and there is no
> such
> > things as DTS etc... the config is very simple
> >
> > Any idea what could be causing that?
> >
> > Thanks
> >
> >
>|||> Try to avoid pulling data from the disk into the buffer pool. To do this,
> avoid all DML, like Select's or Updates.
Eh, doesn't that make SQL Server a pretty useless product?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Anthony Zessin" <Anthony.Zessin@.rrtc.com> wrote in message
news:us3SVPWiDHA.2960@.TK2MSFTNGP11.phx.gbl...
> Try to avoid pulling data from the disk into the buffer pool. To do this,
> avoid all DML, like Select's or Updates.
> You should then see memory remain pretty constant.
>
> "Benoit Martin" <bmartin_hpu@.hotmail.com> wrote in message
> news:ukTtPGTiDHA.2984@.TK2MSFTNGP11.phx.gbl...
> > I have an instance of SQL server installed on a P3 1GHz with 512Mb RAM.
> This
> > is a small development machine so there's very little stress on it. SQL
> > server is pretty much the only app running as I turned off IIS and all web
> > server stuff.
> >
> > When I start the server, the RAM usage is around 150Mb. After a little
> while
> > (seems random but within an hour) the RAM usage jumps to 600Mb. This is
> not
> > a gradual increase to 600Mb but rather a jump. If I restart the
> mssqlserver
> > service, then the RAM usage goes back down to 150Mb and the cycle starts
> > again.
> >
> > There are only 6 DBs defined, I turned off all the jobs and there is no
> such
> > things as DTS etc... the config is very simple
> >
> > Any idea what could be causing that?
> >
> > Thanks
> >
> >
>

Memory Usage Exceeded Maximum Memory Configuration

Hi,
I'm running SQL Server 2000 on an NT Workstation with 1GB
of memory. I've configured the maximum memory of the SQL
Server to be 512MB, but when I check Task Manager it shows
the Memory Usage of sqlservr.exe to be more than 512MB.
(Currently at 560MB). Is it normal that sqlservr.exe will
use more than the maximum allowed?
Thanks in advance,
Alice
SQL Server Version I'm running:
Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 4.0 (Build 1381:
Service Pack 6)
Maximum memory is for Physical Memory.
Task manager shows all, physical and virtual memory.
"Alice" wrote:

> Hi,
> I'm running SQL Server 2000 on an NT Workstation with 1GB
> of memory. I've configured the maximum memory of the SQL
> Server to be 512MB, but when I check Task Manager it shows
> the Memory Usage of sqlservr.exe to be more than 512MB.
> (Currently at 560MB). Is it normal that sqlservr.exe will
> use more than the maximum allowed?
> Thanks in advance,
> Alice
> SQL Server Version I'm running:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
> Nov 19 2001 13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
>
>
>
>
|||The Max setting is for the memory pool only. There is an area called
MemtoLeave (by default up to 256MB) that is not part of that setting so it
is possible for SQL Server to use more than the Max under certain
conditions.
Andrew J. Kelly SQL MVP
"Alice" <achan@.icescape.com> wrote in message
news:278f601c46392$73dd3b30$a401280a@.phx.gbl...
> Hi,
> I'm running SQL Server 2000 on an NT Workstation with 1GB
> of memory. I've configured the maximum memory of the SQL
> Server to be 512MB, but when I check Task Manager it shows
> the Memory Usage of sqlservr.exe to be more than 512MB.
> (Currently at 560MB). Is it normal that sqlservr.exe will
> use more than the maximum allowed?
> Thanks in advance,
> Alice
> SQL Server Version I'm running:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
> Nov 19 2001 13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
>
>
>
>

Memory Usage Exceeded Maximum Memory Configuration

Hi,
I'm running SQL Server 2000 on an NT Workstation with 1GB
of memory. I've configured the maximum memory of the SQL
Server to be 512MB, but when I check Task Manager it shows
the Memory Usage of sqlservr.exe to be more than 512MB.
(Currently at 560MB). Is it normal that sqlservr.exe will
use more than the maximum allowed?
Thanks in advance,
Alice
SQL Server Version I'm running:
Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 4.0 (Build 1381:
Service Pack 6)Maximum memory is for Physical Memory.
Task manager shows all, physical and virtual memory.
"Alice" wrote:

> Hi,
> I'm running SQL Server 2000 on an NT Workstation with 1GB
> of memory. I've configured the maximum memory of the SQL
> Server to be 512MB, but when I check Task Manager it shows
> the Memory Usage of sqlservr.exe to be more than 512MB.
> (Currently at 560MB). Is it normal that sqlservr.exe will
> use more than the maximum allowed?
> Thanks in advance,
> Alice
> SQL Server Version I'm running:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
> Nov 19 2001 13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
>
>
>
>|||The Max setting is for the memory pool only. There is an area called
MemtoLeave (by default up to 256MB) that is not part of that setting so it
is possible for SQL Server to use more than the Max under certain
conditions.
Andrew J. Kelly SQL MVP
"Alice" <achan@.icescape.com> wrote in message
news:278f601c46392$73dd3b30$a401280a@.phx
.gbl...
> Hi,
> I'm running SQL Server 2000 on an NT Workstation with 1GB
> of memory. I've configured the maximum memory of the SQL
> Server to be 512MB, but when I check Task Manager it shows
> the Memory Usage of sqlservr.exe to be more than 512MB.
> (Currently at 560MB). Is it normal that sqlservr.exe will
> use more than the maximum allowed?
> Thanks in advance,
> Alice
> SQL Server Version I'm running:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
> Nov 19 2001 13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
>
>
>
>

Memory Usage Exceeded Maximum Memory Configuration

Hi,
I'm running SQL Server 2000 on an NT Workstation with 1GB
of memory. I've configured the maximum memory of the SQL
Server to be 512MB, but when I check Task Manager it shows
the Memory Usage of sqlservr.exe to be more than 512MB.
(Currently at 560MB). Is it normal that sqlservr.exe will
use more than the maximum allowed?
Thanks in advance,
Alice
SQL Server Version I'm running:
Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 4.0 (Build 1381:
Service Pack 6)Maximum memory is for Physical Memory.
Task manager shows all, physical and virtual memory.
"Alice" wrote:
> Hi,
> I'm running SQL Server 2000 on an NT Workstation with 1GB
> of memory. I've configured the maximum memory of the SQL
> Server to be 512MB, but when I check Task Manager it shows
> the Memory Usage of sqlservr.exe to be more than 512MB.
> (Currently at 560MB). Is it normal that sqlservr.exe will
> use more than the maximum allowed?
> Thanks in advance,
> Alice
> SQL Server Version I'm running:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
> Nov 19 2001 13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
>
>
>
>|||The Max setting is for the memory pool only. There is an area called
MemtoLeave (by default up to 256MB) that is not part of that setting so it
is possible for SQL Server to use more than the Max under certain
conditions.
--
Andrew J. Kelly SQL MVP
"Alice" <achan@.icescape.com> wrote in message
news:278f601c46392$73dd3b30$a401280a@.phx.gbl...
> Hi,
> I'm running SQL Server 2000 on an NT Workstation with 1GB
> of memory. I've configured the maximum memory of the SQL
> Server to be 512MB, but when I check Task Manager it shows
> the Memory Usage of sqlservr.exe to be more than 512MB.
> (Currently at 560MB). Is it normal that sqlservr.exe will
> use more than the maximum allowed?
> Thanks in advance,
> Alice
> SQL Server Version I'm running:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
> Nov 19 2001 13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
>
>
>
>