Monday, March 12, 2012

Excessive memory usage

Hi.
my sqlservers are using 1.5 gigs of memory and
experiencing slow queries where large amount of rows are
returned. Some page swapping at the os is occurring as
well. Any ideas?
Hi -
Please check the KB Arcticle
http://support.microsoft.com/default...b;EN-US;110983
Some time when any relatively heavy query/process comes down... the system
starts paging because there are not enough free sectors to swap out data
Thanks
-Surajit
"KD" <anonymous@.discussions.microsoft.com> wrote in message
news:19ae701c44d63$7558ee40$a401280a@.phx.gbl...
> Hi.
> my sqlservers are using 1.5 gigs of memory and
> experiencing slow queries where large amount of rows are
> returned. Some page swapping at the os is occurring as
> well. Any ideas?

No comments:

Post a Comment