| Author |
Topic |
|
bigbelly
Starting Member
39 Posts |
 Posted - 2003-02-19 : 00:45:03
|
| Recently we upgraded our database server's memory from 1GB(4*256MB RAM cards) to 2.5GB (2*1GB RAM cards and 2*256MB RAM cards). After that by looking at Task Manager, I found that the Maximum Memory Usage of sqlserver is only up to 1.83GB. I've tried to play around by adjusting SQL server from "dynamically configure SQL server memory" or "Use fixed memory size". The maximum amount SQL server used is just up to 1.83 GB. Anyone can share some lights on this issue? |
|
|
szakszi
Starting Member
9 Posts |
Posted - 2003-02-19 : 09:36:02
|
| What is OS version?See SQL Books Online: Server Memory Option."Windows NT provides a 4-GB virtual address space; the lower 2 GB of which is private per process and available for application use. The upper 2 GB is reserved for system use."BRSzakszi |
 |
|
|
bigbelly
Starting Member
39 Posts |
Posted - 2003-02-19 : 18:55:09
|
| Our server's OS is Windows 2000 Server Enterprise version |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-19 : 19:10:54
|
| Quote from www.winnetmag.com :"Under NT 4.0, Enterprise Edition's Virtual Memory Manager (VMM), SQL Server 7.0 can address up to the NT 4.0 maximum of 4GB of RAM. With NT 5.0, SQL Server 7.0 supports 64-bit addressing, which lets SQL Server address up to 32GB of RAM on 64-bit platforms such as Alpha."Edited by - tduggan on 02/19/2003 19:11:40 |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-02-19 : 19:16:00
|
| [EDIT]You said SQL 7.0 Forget what I said below.[/EDIT]Windows 2000 Server Enterprise? Do you mean advanced?Look on this page about 2/3rds of the way down. You'll see a table that shows what combinations allow what amount of RAM. If you are using SQL 2000 Std. Ed., you may be limited to 2GB'shttp://www.sql-server-performance.com/awe_memory.aspMichael<Yoda>Use the Search page you must. Find the answer you will.</Yoda>Edited by - michaelp on 02/19/2003 19:19:54 |
|
|
|
bigbelly
Starting Member
39 Posts |
Posted - 2003-02-19 : 20:17:43
|
| Sorry. Just OS is just Windows 2000 server and SQL server version is 7. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-02-19 : 20:36:09
|
| In that case, I'm thinking that SQL server will use a MAX of 2GB's and Windows should use the other .5GB's.Now why it's only using 1.8GB's I don't know. How big is your database? Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
bigbelly
Starting Member
39 Posts |
Posted - 2003-02-19 : 23:45:45
|
| We have 3 database running on that server. All of them add up is around 15 GB. I'm pretty sure that it should be able to eat up more than 1.8GB memory. But dont know why it just stays 1.83 GB.(It rarely drop down too)From task manager, I can see there are always more than 500MB "Physical Memory" available.Thanks for all of u guys answers! |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-06-26 : 05:04:05
|
| Enable the usage of memory above 2 Gb by using the /3GB win.ini setting.from this link : http://www.microsoft.com/whdc/hwdev/platform/server/pae/paemem.mspxthe following :The virtual address space of processes and applications is still limited to 2 GB, unless the /3GB switch is used in the Boot.ini file.It is a fairly simple thing to add, but I believe it takes a reboot to apply.HTH*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
any memory limitation for SQL 7?