sqlservr.exe memory usage - Microsoft SQL Server

Raziq Shekha

Hello All,

On all of my SQL servers (2000 with SP3), when I go to task manager and
look at memory usage, sqlservr.exe is always at 1.7gigs. If I reduce
the maximum to let's say 1 gig it will go down to 1 gig. But if it is
even at 2gigs or 3 gigs it will be showing 1.7 gigs. Why? Is is ok to
reduce the memory usage of sqlservr.exe?

Raziq.
*** Sent via Developersdex http://www.developersdex.com ***

Feb 27 '06 #1

Subscribe Reply

9976

Erland Sommarskog

Raziq Shekha (ra**********@a nadarko.com) writes:

On all of my SQL servers (2000 with SP3), when I go to task manager and
look at memory usage, sqlservr.exe is always at 1.7gigs. If I reduce
the maximum to let's say 1 gig it will go down to 1 gig. But if it is
even at 2gigs or 3 gigs it will be showing 1.7 gigs. Why? Is is ok to
reduce the memory usage of sqlservr.exe?

I'm not really sure what the question is, so I answer both.

1) Why does SQL Server take so much memory? SQL Server is designed to
grab as much memory it can. The more memory it has, the more data it
can have in cache, which is good for quick response times. If other
processes need memory, SQL Server will yield memory, but it may not
yield fast enough. Therefore, if other applications are running on
the machine, you may want to constrain how much memory SQL Server
may use. The typical example is when you run SQL Server on a
developer workstation. If SQL Server runs on a dedicated server, there
is no reason to set a max memory limit.

2) Why is SQL Server not using more than 1.7 GB? Most probably, you
running Standard Edition which does not support more than 2GB of
memory. If you want SQL Server you to use more memory, you need to
upgrade to Enterprise Edition. Or SQL 2005.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Feb 27 '06 #2

Similar topics

3662

Memory Usage

by: rbt | last post by:

Would a Python process consume more memory on a PC with lots of memory? For example, say I have the same Python script running on two WinXP computers that both have Python 2.4.0. One computer has 256 MB of Ram while the other has 2 GB of Ram. On the machine with less Ram, the process takes about 1 MB of Ram. On the machine with more Ram, it...

Python

13000

Memory usage - max setting

by: Frank Esser | last post by:

I am using SQL 8 Personal edition with sp2 applied. I set the max server memory to 32MB and leave the min server memory at 0. When my application starts hitting the database hard the memory usage reported through task manager peaks between 41-42MB. I've stopped and restarted the MSSQLserver service and checked that the running values are...

Microsoft SQL Server

460

memory usage

by: tomvr | last post by:

Hello I have noticed some 'weird' memory usage in a vb.net windows app The situation is as follows I have an app (heavy on images) with 2 forms (actually there are more forms and on starting the app I load some things into memory for global use of the app but I'll use only 2 starting forms to explain the situation) situation 1 start app...

.NET Framework

422

About memory usage

by: Jarvis | last post by:

I've made a testing program to test the memory usage of some Data Forms. I create a MDI parent form with one single MDI child form, which is a Data Form generated by .NET Data Form Wizard. To test the stuff, I keep to open that child data form for about 10 times. the memory usage shown in GC and task manager both increase. Then I close...

.NET Framework

4128

High Memory Usage Garbage Collection Question

by: Ian Taite | last post by:

Hello, I'm exploring why one of my C# .NET apps has "high" memory usage, and whether I can reduce the memory usage. I have an app that wakes up and processes text files into a database periodically. What happens, is that the app reads the contents of a text file line by line into an ArrayList. Each element of the ArrayList is a string...

.NET Framework

4985

Memory usage\Performance problem

by: Magnus Österberg | last post by:

I am experiencing the following problem; I boot my Windows 2000 sp#4 machine. I check sqlservr.exe's memory usage in Task manager. It is ca 20 mb, everything is OK. Then I run this query; select postoffice, count(*) as counter from tblTable where postoffice is not null group by postoffice order by counter DESC

Microsoft SQL Server

5179

Memory usage. ( H E L P ! ! )

by: George Gre | last post by:

Hi, I wrote a c# programme that listens to incoming TCP requests and services them. This programme is meant to be running as long as the server its installed on is running. So we assume for ever(!). My problem is that I have it running for 2 days now on my pc (win2Ksp3 P4 2GHz,512MB Ram - framework v1.0.3705) and the taskmanager reports...

C# / C Sharp

4200

High memory usage

by: Philip Carnstam | last post by:

How come .Net applications use so much memory? Every application I compile uses at least 10 MB of memory, even the ones consisting of only a form and nothing else. If I minimize them though the memory usage drops to a couple hundred KB. Why? Is there anything I should to to prevent this? I have compiled in release and deactivated all forms...

C# / C Sharp

2455

Aspnet Worker Thread Memory Usage

by: jld | last post by:

Hi, I developed an asp.net based eCommerce Website for a client and it is hosted at discount asp. The site is quite interactive, queries a database a lot and uses ajax.asp.net to spice up interactivity. The service suffers from a lot of restarts since discountasp enforces a 100mb per worker thread limit and when you top it, the service...

ASP.NET

7697

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

General

7612

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

Windows Server

7924

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

C / C++

8120

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

Online Marketing

7968

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

General

5512

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

Microsoft Access / VBA

3653

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

Networking - Hardware / Configuration

3640

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1212

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