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 2 6929
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****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
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****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: czidak |
last post by:
I am running McAfee ePO and SQL Server 2000 on a dual Xeon 900Mhz box
currently. It is slow. I am going to be ordering 2 new servers, 1 for
ePO and 1 for SQL Server 2000. Anybody have any suggestions for the
SQL Server's hardware specs. Thanks,
Chris
|
by: FS Liu |
last post by:
Hi,
In my current ATL server project, I have to parse the
input in the client application's request to find out
the different combination of parameters, instead of
using SOAP. For this reason, I am not using ATL server
web service project. On client side, I use POST to send
XML to web server. I know I should use ISAXXMLReader in
the...
|
by: Fabuloussites |
last post by:
I'm considering deploying an application that will us an IP address locaiton
database provided by Ip2location.com...
http://www.ip2location.net/ip2location-dotnet-component.aspx
their .net component reads data from a binary file. I'm guess i'm wondering
which of the two options would be best.
1) read data from the binary files (~27 mb...
|
by: greg |
last post by:
Hi,
I am hosting hundreds of websites on a webserver using a combination of sql
and asp.
SQL is on a different server. The web server is running win 2003 iis 6 with
a single processor and 1 GB Ram. All websites are in 1 app pool.
I find that i get out of memory errors or no new sessions are created when
the virtual bytes for an App pool...
|
by: dm1608 |
last post by:
I have an Ecommerce application that uses mostly ASP and a bit of ASP.NET.
Monitoring the servers memory via SNMP every 5 minutes would indicate that
there is a memory leak somewhere within the application. Of course, the
vendor says its a "Microsoft IIS" issue and tells us to reboot the server
each day or kill the worker process for IIS.
...
| |
by: Lenny Wintfeld |
last post by:
Hi
I'm attempting additions/changes to a Java program that (among other
things) uses XSLT to transform a large (96 Mb) XML file. It runs fine on
small XML files but generates OutOfMemory exceptions with large XML
files. I tried a simple punt of -Xmx512MB but that didn't work. In the
future, the input XML file may become considerably bigger...
|
by: cj |
last post by:
I have a 2005 TCP/IP server that creates a new thread to handle each
incoming TCP/IP request. Once the request has been answered by the
thread the TCP/IP socket is disconnected and the sub/thread ends. This
program originally written in 2003 and I rewrote it in 2005 earlier this
year. I don't know how long this has been going on but we...
|
by: Tenacious |
last post by:
I am trying to shutdown a database server in the Application_End event
handler on the Global.asax page. So far I am trying this only on the
development server that comes with Visual Studio 2005. When I close
the browser, this does not cause the Application_End event to trigger.
It also will not occur when I shut down the development server. At...
|
by: Tinku |
last post by:
I am sorry for asking this silly question, but i don't understand why
it is happening please suggest me
=================================
#include <stdio.h>
int main()
{
static int i=1;
printf("function call: %d time \n", i);
i++;
main();
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |