Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kharpoh
Starting Member
3 Posts |
 Posted - 2005-03-18 : 14:42:14
|
| I am running 2 Advance W2K with 8GB RAM with MSSQL 2000. I have set /3GB /PAE in the boot.ini and enabled AWE and set max memory to 7GB. On one of the server, when I look at the taskmanager under the performance tab, it tells me that memory usage is about 7GB+ but under the process tab, MSSQL process at that momment only uses 100+ MB. Is this normal?The other server with supposingly the same config shows a very different behaviour. All the memory in the process tab does add up to the total usage. I can't seems to figure out what is wrong with the first server.Please help!! Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-18 : 14:45:44
|
| Unless you told SQL Server to use a fixed memory size, it will use what it wants until it reaches the max.Also, task manager can sometimes be inaccurate on Windows 2000 for memory consumption of SQL Server. Use PerfMon instead for the accurate amount.Tara |
 |
|
|
kharpoh
Starting Member
3 Posts |
Posted - 2005-03-18 : 16:23:21
|
| Thank you for your reply. No both servers are set to use memory dynamically. I used PerfMon and added the SQL Server Memory Manager to track total server memory. It is show what the taskmanager is indicating. I am worry that the SQL Server is not using those memory because total server memory never passes 100MB. If seems like the server always garage collect whenever it get close to passing 100MB. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-18 : 16:25:37
|
| To determine if SQL Server needs more memory, compare Total Server Memory to Target Server Memory. If Target is higher, then SQL Server needs more but can't get it just yet. You'll see this when the SQL Server is rebooted as it takes a bit for SQL Server to consume what it wants. But if the server has been up for a while and you notice that Target is constantly greater than Total, then you've got a problem.Tara |
|
|
|
kharpoh
Starting Member
3 Posts |
Posted - 2005-03-18 : 16:51:37
|
| I am sorry. I misread the information on the perfmon. It is reporting that the total server memory is about 7GB. As for the target and total, they are always the same after been running for a while.The part that I don't understand is why does mssql server, took all my memory all at once for the first server but the 2nd doesn't do that. Load on those 2 machines are evenly distributed. |
|
|
|
|
|
|
AWE Total Memory Not Accounted For