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 |
|
Kristen
Test
22859 Posts |
 Posted - 2004-12-07 : 14:24:13
|
| I'm monitoring Target and Total Server Memory. The box has 4GB installed. Only running SQL Server.Total and Target are giving the same values, at around 1,681,000. Does this mean that it doesn't need to use any more (at the moment), or do I need to do something to "help it up to" 2GB limit?Kristen |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-07 : 14:26:35
|
| You want them to be equal. And yes it means it doesn't currently need anymore. When Target is greater than Total, it means SQL Server needs more but can't get it yet. You'll see this happen on a reboot which is why rebooting SQL Server should be avoided if at all possible. It takes SQL Server a little bit to catch up.Tara |
 |
|
|
|
|
|
Target / Total Server Memory