SQl server using high Virtual Memory

[GG]

Hi,
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?

HAs anyone seen this before.

Thanks
GG

[Erland Sommarskog]

GG (gd******@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, es****@sommarskog.se

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

[Erland Sommarskog]

GG (gd******@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, es****@sommarskog.se

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