Memory Usage

Hi and TIA! Problem I'm having is after or during when I work in SQL EM
designing views/sp/tables etc and I close down EM and I then start noticing
a degraded performance on my computer. I view task manager and notice that
the Mem. Usage is way up to 200mb and continues to grow. On the Performance
tab the Available Physical Memory will drop to 9K and continues to decrease
as well as the System Cache. If I stop and restart SQL server the Available
will normally shoot back up to 500mb or so and Cache will increase as well.
My question is why this happens and is there a way to prevent it. I'm
running XPPro(SP2), 768mb RAM, 2gb Virtual Memory, 1.5ghz, Toshiba Tecra.
Also, this is only installed on my machine with no clients connected.
Thanks for any advice you can provide and for your time.
******************
ReggieThat server plays with another one making up a cluster?
HD is full?
Any suspicious service associated to Sql Server is running all time?
"Reggie" wrote:

> Hi and TIA! Problem I'm having is after or during when I work in SQL EM
> designing views/sp/tables etc and I close down EM and I then start noticin
g
> a degraded performance on my computer. I view task manager and notice tha
t
> the Mem. Usage is way up to 200mb and continues to grow. On the Performan
ce
> tab the Available Physical Memory will drop to 9K and continues to decreas
e
> as well as the System Cache. If I stop and restart SQL server the Availab
le
> will normally shoot back up to 500mb or so and Cache will increase as well
.
> My question is why this happens and is there a way to prevent it. I'm
> running XPPro(SP2), 768mb RAM, 2gb Virtual Memory, 1.5ghz, Toshiba Tecra.
> Also, this is only installed on my machine with no clients connected.
> Thanks for any advice you can provide and for your time.
> --
> ******************
> Reggie
>
>|||Hi
If you are using a single machine that is not dedicated to only running SQL
Server, then you may want to limit the maximum memory that sql server using
by changing the "max server memory" settings in the server properties dialog
using EM or using sp_configure in Query Analyser. See the topic "Server
Memory Options" in Books online for more.
John
"Reggie" wrote:

> Hi and TIA! Problem I'm having is after or during when I work in SQL EM
> designing views/sp/tables etc and I close down EM and I then start noticin
g
> a degraded performance on my computer. I view task manager and notice tha
t
> the Mem. Usage is way up to 200mb and continues to grow. On the Performan
ce
> tab the Available Physical Memory will drop to 9K and continues to decreas
e
> as well as the System Cache. If I stop and restart SQL server the Availab
le
> will normally shoot back up to 500mb or so and Cache will increase as well
.
> My question is why this happens and is there a way to prevent it. I'm
> running XPPro(SP2), 768mb RAM, 2gb Virtual Memory, 1.5ghz, Toshiba Tecra.
> Also, this is only installed on my machine with no clients connected.
> Thanks for any advice you can provide and for your time.
> --
> ******************
> Reggie
>
>|||Enric, Not part of a cluster
HD is not full.
No services(that I know of) except SQLServerAgent.
I'm going to try limiting the Max server memory as John suggested and see if
this helps. Thanks for your time.
******************
Reggie
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:00B779BD-9FDE-402B-B905-A396947CC73B@.microsoft.com...
> That server plays with another one making up a cluster?
> HD is full?
> Any suspicious service associated to Sql Server is running all time?
> "Reggie" wrote:
>|||John, It is a single machine and not a dedicated server. I will try your
suggestion. Thanks for your time.
******************
Reggie
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:17602C4D-383B-4EF6-A53B-FB821C937707@.microsoft.com...
> Hi
> If you are using a single machine that is not dedicated to only running
> SQL
> Server, then you may want to limit the maximum memory that sql server
> using
> by changing the "max server memory" settings in the server properties
> dialog
> using EM or using sp_configure in Query Analyser. See the topic "Server
> Memory Options" in Books online for more.
> John
> "Reggie" wrote:
>