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 |
|
ColinD
Starting Member
40 Posts |
 Posted - 2007-05-21 : 03:35:09
|
| Hi,Can anybody explain to me what's going on with my Target memory and Total memory in Perfmon? Last week, before I upgraded my servers memory, they were both almost the same, at around 24 on the graph. Target was just fractionally above total, but there was almost no space between the two. Then I doubled my servers memory to 4GB and expected to see total go way up and target stay the same. However, target went up to 72, and total came down to 16. When I looked this morning, target is now around 47 and total is 25. I guess I expected these numbers to fluctuate, but not as much as this, and also why is there now such a big difference between target and total?ThanksColin |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-21 : 10:24:05
|
| Target memory is amount of memory sql server can use while Total memory is amount of memory sql server is using. What's your sql edition? Did you add '/3gb' in boot.ini file? |
 |
|
|
ColinD
Starting Member
40 Posts |
Posted - 2007-05-21 : 10:41:42
|
quote:
Originally posted by rmiao
Target memory is amount of memory sql server can use while Total memory is amount of memory sql server is using. What's your sql edition? Did you add '/3gb' in boot.ini file?
So I've got it the wrong way round? I thought that target was what SQL was looking to use, whilst total was the total amount available. We are using SQL 2000 as part of SBS 2003. No I didn't add anything to the boot.ini file.Colin |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-21 : 10:46:34
|
| Then your sql server can't use more than 2gb memory, only enterprise edition can. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-21 : 11:14:59
|
| ... but FWIW Windows can use a fair bit of the 4GB ...SQL2005 Standard edition memory only limited by what the O/S can support.Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-21 : 14:26:21
|
| But this is SQL 2000 as part of SBS 2003. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-21 : 14:36:08
|
| Indeed, sorry wasn't clear. What I as meaning was:Installing 4GB of memory with "bog standard windows and SQL Server" will result in:SQL Server using up to 2 GB of memory.2GB of memory left over, of which Windows will use a fair bit - perhaps 500MB at a guess.So it is probably NOT a false economy to install 4GB of RAM for "Standard" SQL 2000.And if & hen you upgrade to SQL 2005 then all the RAM available from the 4GB RAM installed will be used by SQL Server.Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-21 : 14:38:22
|
| Target is what SQL Server would like to use and Total is what it currently is using. What edition are you using?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|
|
Perfmon: Target versus Total memory