Posted by Erland Sommarskog on 10/01/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

[Back to original message]