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
> >
> >
>