Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

SQL 2000 SP4 EE 32 Bit - SQL Is Not Using All Of The Memory Allocated To It.

I recently changed the max. memory option in SQL from 24 GB to 30GB but the perfmon counters still only show 24 GB. Any ideas on why it is not recognizing the change? The server has Win 2003 EE and 32 GB of RAM.

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
SQL Server 2000 Not Using All Memory Allocated To It.
One of our servers has 20GB of memory and SQL server has been allocated 18.5 GB out of it, however SQL Server only uses about 9GB or so.

OS: Windows 2003 Server
MS SQL Server 2000 SP4
awe enabled
min & max server memory (run values) are: 18432
/PAE switch in boot.ini

any help why SQL server is not using 18.5 GB allocated to it, would be greatly appreciated?

View Replies !   View Related
Total Space Allocated In SQL 2000
Could anybody tell me how to find out the total space allocated to a database excluding the log files in SQL server 2000. Thanks

View Replies !   View Related
Sql Server 2000 Using Less Memory After More Memory Added
sql server 2000 is running on windows server 2003 ... 4gb of memory on server .... 2003 was allocated 2.3gb nd sql server was allocated (and using all of it)1.6gb for total of approx 4gb based on idera monitor software ... all memory allocated betweeen the OS and sql server .... then 4 more gb ofmemory added for total nowof 8g ... now idera monitor shows 1.7gb for OS and 1.0 gb for sql server ..... 'system' info shows 8gb memory with PAE ... so I assume that the full 8gb can now be addressed .... why are less resources being used now with more total memory .... especially sql server ..... i thought about specifying a minimum memmry for sql server but i amnot convinced that would even work since it seems that this 1gb limit is artificial .... it it used 1.6 gb before why would it not use at least that much now ??

thank you

View Replies !   View Related
Failover Cluster Not Using All Allocated RAM
We are running on SQL 2000 on Windows 2003. We have active-passiveclustering set up. We have 16 GB of RAM on each box. This pastweekend, we failed over. I noticed that the Total Server Memory wentfrom about 15.5 GB to 8 GB. I have been trying to figure out why thishas occurred. Any help would be greatly appreciated.

View Replies !   View Related
Maximum Of DBprocess Already Allocated
Hi all,
Sql server 7.0

our client is getting the below error while accessing the web application
Maximum number of DBPROCESSes already allocated

when we check the server from our side its working fine.
please let us know is the solution for this.


View Replies !   View Related
Space Allocated In SQLServer
We are using SQL 2k.Can we shrink the space allocated in SQL databases.Please help.

View Replies !   View Related
SQL 7.0 Space Allocated Issue
I am new to SQL and have been handed the task of converting a 42 million document image system into our new system. I am running about 50,000 images into the system an hour. My problem is the database is not growing and halts all operations. I have automatically grow file checked and request a 1 gig increase. This has happened 4 times and I have not found any open issues for this problem. Maximum file size is also set at unrestricted filegrowth. Thanks for any help in this area.

View Replies !   View Related
SQL 2000 Memory Adjust
Does anyone know how or where to adjust Ram Memory usage for SQL 2000.
      I've just added Changed the 512 MB Ram that came with the Server and Exchanged it with 4 GIG Ram . Is it a good Idea to allow only 2GiG for SQL . I 've heard that SQL will take/use all Ram that you install if you let. If this is true
Can anyone advise on how/where to make adjustments. Thank You...

View Replies !   View Related
Memory Upgrade And SQL 2000
We have a SQL server that has a failover cluster on our network. We are looking to updrade the memory by adding a couple gigs of ram.

We don't need to upgrade the failover cluster to have the exact amount of memory as the primary do we?


View Replies !   View Related
SQL 2000 Memory Usage
Our production server has 3.3GB of memory and is running Windows 2000 server(service pack 2) and SQL 2000 Standard Edition(service pack 1).
We have configured SQL to use the maximum memory for standard edition (2GB)

In use, however, task manager shows SQL is only using 1.75GB maximum memory
Our database size is 11Gb and we wouldexpect to see SQL using the full 2GB

I have heard a similiar story from a colleague at another installation..

Does anyone have any insight into why this would be the case?

View Replies !   View Related
Configuration Of Memory For SQL 2000
I am looking for recommandations regarding the memory distribution for SQL 2000 server. In the memory tab of the server properties you can define use a fixed memory size or dynamically configure SQL server or even reserve physical memory for SQL server.
Are there any hints available or must it be handled according trial and error?

Thanks for any info


View Replies !   View Related
Memory In Sqlserver 2000
Running sqlserver 2000 on a w2k server with 1gb of memory. After a reboot the memory usage is around 500m but quickly climbs. At 1 point it was up to 1.5gb so it must have been swapping. Are there any good docs about this or any recommendations on how to limit sqlserver from using all the memory. It is the only application on the server so it isn't affecting anything else so maybe it isn't a problem. I just wanted to get people's inpit on this.

View Replies !   View Related
Memory Allocation In SQL 2000
I would like to ask regarding the memory allocation fo SQL Server 2000. For example if my Data Server have 8GB physical memory installed how much memory can SQL Server 2000 utilize? Based on my research and understing SQL 2000 Server can only utilize 3GB memory? But using the AWE you can set the memory to a maximum server memory?

View Replies !   View Related
SQL Server 2000 Std Memory
I have SQL Server 2000 STD installed on a Windows Server 2003 STD machine. It's essentially the only app on this box. I have 4GB of RAM installed. SQL is configured to dynamically allocate memory. I run a batch file daily to restart the SQL services as SQL does not seem to release memory once it's got it. I don't think this is a problem because, like I said, it's basically the only app. But I want to make sure my OS memory settings and SQL's memory settings are optimized. Will adding the /3gb switch to the boot.ini file make a difference? Also, can someone educate me a little on PAE and AWE?

View Replies !   View Related
EM Doesn't Show Database Space Allocated Info , Etc
Hi, all,
I found that the SQL2000 EM does not show database space allcoated information, as well as tables and indexes size while SQL 7.0 does.
Someitmes these information are fairly handy.
is there any other easy ways to find out the same info from SQL2000
through Em, or elsewhere ??

View Replies !   View Related
Can I Find The Space Allocated For A Database W/ Query Analyzer Using 7.0?
My group is trying to ensure that there is a sufficient amount of cushion between the space allocated and the current size of a database. I know that I can check this using the Enterprise Manager. Is there a stored procedure or a systems table that holds this information. I know that sp_spaceused will give me the unallocated space, but i want the allocated space. Any suggestions?

View Replies !   View Related
SQL Server 2000 Memory Issues
Every day or two I have to restart my SQL Server because users are receiving timeouts and very slow page loads.  My mem usage in Task Manager show that SQL Server is at 1,200,000k compared to 400,000k when I restart it.  Performance Monitor also shows that Buffer Manager/Target Pages and Total pages are maxed out.  Any advice?  Thanks!

View Replies !   View Related
SQL Server 2000 Memory Problem
I have a problem with an sql 2000 server running on a windows 2000 server (dual cpu, 2gig RAM). Wednesday night a heavy job is running and every thursday morning my server is running extremely slow (process runnning at 90% of cpu time and taking about 1,7 gig of memory).
My question is: is sql server not releasing the memory it used to run the job and how do you see a solution to make my server run normal again?
Restarting the server isn't a solution coz it's needed day and night. Is there a possibility to run a job that releases memry or something similar?

View Replies !   View Related
SQL Server 2000 And Memory Consumption

We have a SQL Server 2000 that has been working nice
without any issues. Lately we noticed the fact that the amount of memory that
it is using has increased and once it took down the web server as the total
amount of memory used was 2G. Due to this fact I have set Memory Max to 500MB.
Now as I look in Task Manager the Memory usage is at 530396k which is 518MB.
Any reason why would it exceed the 500MB?

What we did before was to stop the SQL Server and restart it, and it takes about
2 days until it gets back to +500MB.

What can I do to stop this behavior?


View Replies !   View Related
SQL Server 2000 2GB Memory Limit?
SQL Server 2000 SP3 on a Dell dual 2.4GHz Xeon box 3GB RAM Windows 2KSP4. Two aplication dbs, each less than 2GB in size.Had a problem where we would run Solomon queries and what not againstthe box. It had 2GB RAM, and sqlserv.exe would take up to 1.85GB ofRAM, exhausting the physical RAM on the box. SQL would choke and theSolomon users would have problems, and I would have to restart the SQLservice.I added another GB of RAM, bringing the box to 3GB, and increased thepaging file. The OS sees it, and SQL sees it. I check EnterpriseManager, and tell SQL to dynamically configure memory, and it offers anupper limit of 3071MB, so it "sees" the 3GB.I can stress the box with queries to the point that sqlserv.exe takes1.99GB of memory (as viewed through Task Manager) and then SQL serverchokes. It never goes past 2GB, and the OS and box continue runningfine.Does SQL server 2000 have some upper limit, or do I just need to changesome setting through EM?Thanks.

View Replies !   View Related
Memory Allocation In MS-SQL 2000 Instances
Hi,From a previous sys-admin I inherited a a MS-SQL (2000) machine with 3instances. It is a nice machine with 4 Gb of memory but the memory allocationis very weird:Instance A: 1400MbInstance B: 1000MbInstance C: 80Mb (!)Instance C is performing badly under a bit of pressure which seems not strangeconsidering these allocations.With that in mind, is there a way to check and re-allocate memory? I'd like tosee if the instances really need these amounts of memory and if not, to movesome over to other instances.Thanks!Dries Bessels

View Replies !   View Related
SQL Server 2000 Memory Reclaim
Hi,I guess SQL server does not release claimed memory even if it is notused. Is there anyway to free the unused memory?Thanks,John Jayaseelan*** Sent via Developersdex ***Don't just participate in USENET...get rewarded for it!

View Replies !   View Related
MSSQL 2000 SP4 Memory Leak
Greetings all!

On one of our intranet SQL servers running under Windows 2000 SP 3,
MSsql 2000 SP4 seems to gradually "eat" away all available memory (with no obvious reason for it) until a certain limit is reached, forcing the server to slow down substantially since the OS has to SWAP continuously.

I would appreciate any suggestions at this point on how to tackle this problem :)

Thank you!

View Replies !   View Related
MSSQL 2000 Memory Leaks
I have one application in two different companies with MSSQL2000 running on Windows2000 Server and Windows2003 Server.
It seems that memory needed for MSSQL2000 as displayed in task manager is increased every day.
Does anybody knows anything regarding memory leaks in MSSQL2000?

How can I find what version of service pack have I installed in a MSSQL2000 server machine?


View Replies !   View Related
SQL 2000 Cluster Memory Settings
I have an Active/Active/Passive cluster with 64GB RAM on each node running SQL 2000 EE, AWE is enabled as well as the PAE switch, all is dandy with that.

Should I configure each SQL Instance to have only a max mem usage of 32GB in the event both failover to the same node ? or will the memory allocation be handled without any issue if each node is configured to use 64GB ?


View Replies !   View Related
Insufficient Memory SQL Server 2000
Currently, I am experiencing memory problems with SQL Server 2000. Daily, I have many "Insufficient memory available" errors in my SQL logs, and "A time out occurred while waiting for memory resources to execute the query. Re-run the query." messages. I have already enabled Address Windowing Extensions. I do not have the /3GB in my boot.ini, but the /PAE is. Implemented is a startup option, -g256, which made no difference, but it is in place. Also, SQL Server is configured for thread mode processing. When I run the PerfMon, SQL Server: Memory Manager, and add up Maximum Workspace Memory, Connection Memory, Lock Memory, Optimizer Memory, and SQL Cache Memory I get around 1.2GB not anywhere near the 6.8GB that the SQL Server process has reserved.

System Summary: SQL Server 2000 Enterprise Edition; Windows 2000 Advanced Server; DELL PE8450 8-Way, 700 Mhz, 8GB RAM, MDAC 2.6.

Has anyone experienced memory problems with SQL Server 2000? The same code ran on 7.0 without this problem. Any help would be very appreciated.

Thank you.

View Replies !   View Related
SQL Server 2000 Memory Issues
Dear All,

We have a Windows 2003 Enterprise server with SQL Server 2000 Enterprise on it. This has the AWE settings for 'max memory setting' to 5120MB. This server has 6GB of memory, or rather about 5.8GB due to PAE. From yesterday morning the server has become almost unresponsive when the SQL service is running, and pretty much all the memory, ie < 1MB on average is listed as being free.

The database has been growing constantly and is now 46GB, with database file size of 67GB.

We moved the database onto a new box which was being prepared for another service, and this has 8GB or ram and no AWE settings. It is running fantastic.

We are going to rebuild the original box and the SAN structure, but I want to do some fiddling before we do. I was going to set awe-enabled to 0 to see if that setting was allowing the OS to have no memory, but from reading it says If AWE is enabled and is taking too much memory, SQL Server must be shut down to reconfigure it, causing downtime (which makes a high availability option such as failover clustering less available). Because the memory pages used by the instance of SQL Server are taken from the nonpageable pool of Windows memory, none of the memory can be exchanged. This means that if the physical memory is filled up, SQL Server cannot use the page file set up on a physical disk to account for the surplus in memory usage. How do you reconfigure AWE settings if the SQL service is shutdown?

Also, how can I figure out whether the server is deficient in physical RAM, or it is just a 'max memory' setting we need to tweak, or is it just trial and error?

Incase it might help, we have ~3 meaningful DB's on the server apart from 'master'. One is an archive DB ~80GB, one is ~5MB and the live DB which is the size mentioned above. Unfortunately I don't know table sizes.


View Replies !   View Related
Memory Usage For SQL SERVER 2000
Good day to all of you
I am faced SQL SERVER 2000 Memory usage problem. I am using Windows 2000 Server SP4 and SQL SERVER 2000 SP4. When User running some in-house application software, the memory for sqlservr.exe was increased . But, when user logout from the software. The sqlservr.exe did not decrease the memory. I have around 100 Users in my company. SQL Memory will countinues increase till max memory usage in CPU.

May i know how to order SQL SERVER need to purge memory when USER was log off from the Program? Or my SQL SERVER was corrupted /missing file?

Please advice

Many thanks!

View Replies !   View Related
SQL 2000 X32 OnWin2003 X64 Memory Config

We have a new server (4 dual-core CPUs and 8GB ram) with Windows 2003 x64 installed. We need to put SQL 2000 on the system and want to maximize it for sql performance (will be dedicate to SQL). Do we enable awe in SQL? Are there any 3GB switches we need to put in the boot.ini for the 32-bit subsystem? Should we use the 32bit version of Windows and just use awe and pae?


View Replies !   View Related
SQL Server 2000 - MSDN - AWE Memory
We use MSDN SQL 2000 , the enterprise edition for our development servers,
which have always had 2GB RAM.
Now they are bringing in a Win 2003 Enterprise with > 12GB RAM .
They want SQL SERVER 2000 to use AWE memory up to 12GB . Is there any limitation
on MSDN Ent. Edition using more memory.?

View Replies !   View Related
2000/2005 Memory Best Practices
Does anyone have any advice or useful experience configuring memory management for SQL Server 2000 and 2005 instances residing on the same box? I'm looking for advice on whether I should just completely leave it up to SQL Server and Windows to allocate memory or should I attempt to put ceilings on certain instances.

Any help is appreciated!

View Replies !   View Related
SQL Server 2000 Memory Problem
Hi to alll,

I use sql server 2000 ver 8.00.2039
I would like to know if is possible to free some ram memory without restart the service .

I have about 1.7 Gb of memory used

I have just tried to use these commands

dbcc free

but seems that nothing happens

Any idea?

thank you in advance

View Replies !   View Related
SQL 2000 Not Listening On Shared Memory. Why Not?
One of my production SQL Server 2000 systems is listening on TCP and Named Pipes, but not on Shared Memory.

This server has a lot of scheduled jobs that are internal to this box. I assume these jobswould benefit from using shared memory instead of TCP/IP, but I can't figure out why it doesn't use shared memory already and how to correct that.

Thanks in advance for all assistance.

View Replies !   View Related
Sql 2000 + Reporting Services = Memory Pig
How do you adjust Reporting services memory usage?

(I'm tired of telling MS who I am and having it be forgotten).

View Replies !   View Related
SQL Server 2000 -- Taking Over My Memory

I am running SQL Server 2000 on a desktop PC. Just recently upgraded my PC to 2gig of ram from 1 gig, in part, to try and fix the problem below. Didn't work. Have SP3 installed but notSP4 at this point.

When I open up query analyzer and edit some code, regardless of whether I actually execute the code, SQL server eventually sucks up available and cached memory to the point that my system comes to an effective halt --takes forever to do anything either in SQL server or other applications. In the task manager PF Usage climbs to just over the 2gig memorylimit.

I conceptuallyunderstand the dynamic memory operation of SQL server ... but why is it sucking upmost available memory when nothing is executing?

Is there a way I can release/clear thememory? Ideally,code that coould be run under a stored procedure would best meet my needs. Right now, I am "fixing" by shutting down andthen restarting SQL server.


View Replies !   View Related
Why SQL Server 2000 Service Eating So Much Memory?
Hi to all, i have a very important problem...pls help me

I have a server with Windows 2003 Server (3GB RAM) and SQL SERVER 2000 running on it, my problem is that sqlserv.exe eat 2GB RAM even if on this server nothing happen....if i restart the service of SQL Server everything is ok eat just 30 MB RAM but after some minutes...after i made a simple select or a simple delete....simple things he arrive to 2GB RAM...this not happen until now(2 days ago)...the problem is that when he arrive to ~2GB RAM the statio run very slow and i receive the error "Time out expire"

this problem happens and on my local station where i have Win XP PRO (1 GB RAM) SQL Server 2000....

thx a lot

View Replies !   View Related
SQL 2000 Server Memory Issue! CRITICAL!
Good day everyone!

The issue I'm going to pose here has to do with SQL Server allocated memory BEING EXHAUSTED by an application (a simple data receiver from GPS units) when the number of units connecting to it is considerably increasing.
This happens to an extent that no more connections from the units are valid and therefore lots of data (Afterwards) is being lost.
This causes a real problem with the installations and the projects which are running the system.

I will hereby post all of the info which might be useful for any Database Experts among you, so you can perhaps help me figure out the source(s) of the mentioned problem, and possible solution(s) of the issue.

1- The Operating System used:
Windows 2003 Server (Ent. Edition)

2- The Database Server used:
Microsoft SQL 2000 Server

3- The amount of memory:
1 GB (but on some sites there are 4 GB and the same problem
is faced)

4- The conditions where the issue happens
When the amount of the received data - which gets written to
the SQL Server tables - exceeds a certain limit.

5- Number of applications used:
We are using two applications:
a- The receiver, which is a simple application that only
receives the data from the GPS units installed at the cars
of the clients' fleet(s), and writes them to the database
(Day and Night - running all the time), so the memory used
gets bigger and bigger till it floats the memory used by
MS SQL Server 2000. As a result of this the connections
made from the units furtherly to this point (to the receiver)
are not being received and written to the database.

b- the other application is quite heavy.. it does data
management on SQL Server 2000 and exhausts the CPU.
It reads from tables and makes analysis for GPS data...
This is done while "vehicle tracking".. so it makes
calculations on the received data and stores them into
output tables.

6- The programming language used in writing these 2 applications:
Delphi 7

7- What are we doing right now to handle this problem?
We need to flush the memory on periodical basis.
This is being done by stopping the SQL Server, or by
restarting the PC.
And it is not solving the problem entirely, especially that
there must be a way to handle this.
BTW, the memory is not being flushed when we turn the
application off.

8- What do we need to know?

a- We've found, after research, that there are "Temporary tables" or
objects in SQL Server 2000, that the DB system creates.. also page
files, and temp tables.
What are these for? And does handling them in a certain manner help
solve the problem?
b- Is there a way to monitor our applications to see where they are
increasing the usage of memory and how this is happening?
c- Is there a script that writes to the database that we can use to see if
the problem is from our applications? And in case it is, then is there a
command we should write or a function or script we should run in order
to flush the MS SQL 2000 Server periodically, so that it doesn't flood?

What comments can you have on this issue?
Are there solutions at hand?

I thank everyone for trying to help!

All the best :beer: :beer:

P.S. you can write to me at: database1980 (AT) hotmail (DOT) com

View Replies !   View Related
SQL 2000 On Windows 2003 Memory Limits
Can anyone confirm that SQL 2000 Standard Edition is still limited to 2GB of memory utilization on Windows 2003 Server?

In addition, anyone have suggestions for deploying SQL 2000 on Windows 2003?


View Replies !   View Related
Sql 2000 Mem Setting Versus Real Memory
I have a client server that has win2000 on it with sql 2000 enterprise edition. The box has 4 gig of memory on it. I noticed today that the sql server was set to use all 4 gig (even though I know sql can't really access that memory because sql can't really utilize the 2-4 gig range). Is there overhead or a downside to leaving it at this, or should I set it to 2 gig

View Replies !   View Related
SQL Server 2000 - Provider Ran Out Of Memory Error

I have Oracle(9i) Server linked to the SQL Server 2000 Database. When executing a Stored Procedure from SQL Server 2000, I get the following error.

Server: Msg 7399, Level 16, State 1, Procedure SPECRAKOFF, Line 1984
OLE DB provider 'MSDAORA' reported an error. The provider ran out of memory.
OLE DB error trace [OLE/DB Provider 'MSDAORA' ICommandText::Execute returned 0x8007000e: The provider ran out of memory.].

I get this error only whenthe SQL query in the Stored procedure returns some records.
I tried this with Oracle ODBC provider but I get the same error. Kindly help me to diagnose and solve the issue.

Any help on this is really appreciated.

View Replies !   View Related
SQL Server 2000 Standard Memory Flatline
Hi all,

We have an SQL 2000 Standard SP4 system with 3gb of RAM running on Windows 2003 Server R2 Standard.

The SQL memory usage of this server flatlines at around 1665mb and will not go any higher.

I understand SQL 2000 Standard on Windows 2003 Server Standard has a 2gb memory limit, however why wont the memory push up to this limit? The OS shows there is around 700mb of the 3076 unused (SQL uses 1660, windows uses around 700 making the maximum used around 2300 of the 3076)

I have set the /3gb switch on windows boot, I have changed the SQL memory configurations many different times. If I try and set 'min server memory' to anything over around 1500mb I get the error on SQL startup;

Warning: unable to allocate 'min server memory' of 1720mb

In the above example surely if the Server has a 2gb limit it should let me set say 1720/2048 ? or 1920/2048 or even 2048/2048, however anything over around 1500 generates the above error.

Our server continues to flatline at 1660mb, any help to squeeze out an extra 200-400mb of RAM would be appreciated or an explination as to why it can not be done.

Thanks for your help


View Replies !   View Related

Copyright 2005-08, All rights reserved