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 Replies


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 of memory added for total now of 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 http://www.developersdex.com ***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

Copyrights 2005-15 www.BigResource.com, All rights reserved