Posted by Erland Sommarskog on 09/29/79 11:18

GG (gdabbara@gmail.com) writes:
> We have a prod server running on SQL server 2000 64 bit. It is a
> 4cpu server with 16GB of RAM. we have a maxmemory setting of 15.5GB
> for sql server. Inspite of 15GB being available for sql server, it
> still uses paging file space, a lot. When looking thru task maanger we
> can see sql server using 15.5GB of Memory usage and 22GB of Virtual
> memory usage. I don't understand why it should even be using closer to
> 7GB of Paging space, when it has so much memory. How does SQl server
> use Virtual memeory vs Physical memory?

Since I don't have any experience with 64 bit myself, I asked in our
internal MVP forum, to see if anyone would have any answer, but no luck.

So the only recommendation I can give, is that you should open a case
with Microsoft about this.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: sql2000 replication
• Prev in forum: Re: long running transactions w/ other users needing to read data
• Thread view: Re: SQl server using high Virtual Memory

[Reply to this message]