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 |
|
DHeath66
Starting Member
5 Posts |
 Posted - 2006-06-28 : 13:22:07
|
| Anyone aware of mssql2k reporting memory incorrectly in task manager? Is there a hotfix or patch for this? Already have some scripts to show memory being used but just thought this "fix" would help or is it something you just ignore and use scripts?Please help with ideas....DHeathDHEATH |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2006-06-28 : 20:18:35
|
Can you elaborate on "reporting memory incorrectly?" Why is it inaccurate?Also, what edition/version are you using?select @@version Nathan Skerl |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-28 : 20:22:11
|
| How do you know it's incorrect?Tara Kizeraka tduggan |
|
|
|
DHeath66
Starting Member
5 Posts |
Posted - 2006-06-29 : 09:47:07
|
| Well how do i know its incorrect. If i go into SQL and set min and max memory on the machine and we will set it to 1.5GB min and 1.8GB Max remember there is 6GB on the machine(just pick any number it doesnt matter). Anyways it will only show that approx 95MB to 103MB is used. Regaurdless of what thresholds i set. Do you have a query that may tell me what is actually being used? Maybe the ones i use are incorrect? versions i am using is OS Win2k sp3 and SQL2k sp4.DHEATH |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-29 : 11:29:12
|
| I have noticed the same thing as well but I have yet to prove that Task Manager is wrong. I have even tried the SQL Server memory objects in Performance Monitor.Tara Kizeraka tduggan |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-29 : 11:48:53
|
quote:
Originally posted by DHeath66
Well how do i know its incorrect. If i go into SQL and set min and max memory on the machine and we will set it to 1.5GB min and 1.8GB Max remember there is 6GB on the machine(just pick any number it doesnt matter). Anyways it will only show that approx 95MB to 103MB is used. Regaurdless of what thresholds i set. Do you have a query that may tell me what is actually being used? Maybe the ones i use are incorrect? versions i am using is OS Win2k sp3 and SQL2k sp4.DHEATH
You are assuming that SQL Server will use the memory use set for the min. If your database is small, it will only allocate the memory it needs.You can see what is actually being used by looking at the Task manager, Process tab, and Mem Usage column for the SQL Server process.You can also use Performance Monitor, Process object, Working Set counter, sqlservr instance to see the memory currently being used. You can also look at the SQL Server Memory Manager object, Total Server Memory(KB) counter. CODO ERGO SUM |
|
|
|
DHeath66
Starting Member
5 Posts |
Posted - 2006-06-29 : 13:37:07
|
| Thanks for the help and explanations...much appreciated, the memory aspects is always a bit confusing..thanks againDHEATH |
|
|
|
|
|
|
Mssql2k reporting memory incorrectly