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/defaul...kb;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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment