Why is SQL Server using so much Virtual Memory?

Evert Wiesenekker

I have two instances of SQL Server running on my Development machine.
I am having some performance problems and while investigating the
problem I saw with the Process Explorer form Sysinternals that both
instances consume each 800 Mbytes of memory!

I experimented with sp_configure and by giving both instances a fixed
memory size. Both methods do not seem to have any effect.

Can anybody explain me why SQL Server is using so much memory?

Thanks for any information.

Evert Wiesenekker

PS
Besides the northwind database I only have one simple extra database
(70 Mb in size) installed.

Jul 23 '05 #1

Subscribe Reply

3098

Erland Sommarskog

Evert Wiesenekker (e.***********@ wisl.nl) writes:

I have two instances of SQL Server running on my Development machine.
I am having some performance problems and while investigating the
problem I saw with the Process Explorer form Sysinternals that both
instances consume each 800 Mbytes of memory!

I experimented with sp_configure and by giving both instances a fixed
memory size. Both methods do not seem to have any effect.

Can anybody explain me why SQL Server is using so much memory?

SQL Server is designed to grab as much memory as it can get. The idea
is that normally run you run SQL Server on a dedicated server, so no
other applications compete. And the purpose for that all memory is simply
cache. The more data SQL Server can have in cache, the better the response
times.

Of course, on a development machine, this behaviour is not really suitable,
and limiting the memory for SQL Server is a very good idea. SQL Server will
yield memory, if other applications are asking for memory, but it may not
yeild fast enough, and anyway, it's not fun to have all other apps paged
out.

I can't say why SQL Server does not yield memory despite your change. The
setting does not control all memory allocated by SQL Server, only the buffer
pool as I recall. Then again, that is the main body of allocated memory
normally. But a quick check: you did run RECONFIGURE after your change,
didn't you?
--
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

Jul 23 '05 #2

Evert Wiesenekker Wiesenekker

Thank you very much for your reply!

Yes, I did a reconfigure.

I did some Googling around but did not find a good answer

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 23 '05 #3

Similar topics

6942

SQl server using high Virtual Memory

by: GG | last post by:

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,...

Microsoft SQL Server

2892

Memory issues with Terminal Server??

by: Justin Lazanowski | last post by:

Cross posting this question on the recommendation of an I have a .NET application that I am developing in C# I am loading information in from a dataset, and then pushing the dataset to a grid, or other controls depending on the particular form. This application is setup with one MDI parent calling MDI children with the exception of one Modal form (the report viewer). When I run the application and run one of the screens that pulls...

.NET Framework

4671

How to use ISAXXMLReader in ATL Server Web Service Project

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 server program. I also know that the parser can be used for many different handlers in the DLL. I found...

.NET Framework

3945

Problem with wrapping an unmanaged C++ DLL using the header file

by: Lokkju | last post by:

I am pretty much lost here - I am trying to create a managed c++ wrapper for this dll, so that I can use it from c#/vb.net, however, it does not conform to any standard style of coding I have seen. It is almost like it is trying to implement it's own COM interfaces... below is the header, and a link to the dll+code: Zip file with header, example, and DLL:...

.NET Framework

4928

how to reflect changes in server-control to client?

by: Mike | last post by:

Hi, I am strugling with a simple problem which I can't seem to resolve. I have an asp.net page which contains a server-control (flytreeview, which is a kind of a tree to be exact). The tree is being updated by some other process through remoting. When the page loads, I init the tree, and in my browser I can see the initialized tree. The problem is that every time that I receive update to tree from the remote process,

ASP.NET

1609

Scaling with ASP and Server Memory Issues

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 starts to breach over 1500mb. So i recycle the App pool at a limit of 1500mb.

ASP / Active Server Pages

1540

Ecommerce Server Requires Daily Reboot

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. We're currently rebooting our server at 4 AM each night. This is a really lame idea, in my...

ASP.NET

2171

memory allocation using new operator

by: cikkamikka | last post by:

Hi friends, Sorry for such basic question. but I wanted to know where does new operator or malloc operator allocate memory? in actualy physical Main memory or virtual memory?

C / C++

2864

multithreaded tcp/ip server large page file

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 just noticed today that the program was using over a gig of virtual memory. Real memory was quite...

Visual Basic .NET

9700

What is ONU?

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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9564

Changing the language in Windows 10

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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10546

Problem With Comparison Operator <=> in G++

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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10310

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10068

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7603

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6841

Couldn’t get equations in html when convert word .docx file to html file in C#.

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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5498

Trying to create a lan-to-lan vpn between two differents networks

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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3796

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP