"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 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.
>
> --
>
> ******************
> Reggie
>
>
>

"Enric" <En***@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:
>
>> 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.
>>
>> --
>>
>> ******************
>> Reggie
>>
>>
>>

"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 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.
>
> --
>
> ******************
> Reggie
>
>
>

"John Bell" <jbellnewspo***@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:
>
>> 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.
>>
>> --
>>
>> ******************
>> Reggie
>>
>>
>>