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 |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2004-10-01 : 11:07:58
|
| Currently we are runnig 2000 Std on a machine with 8GB of ram. We are currently not experiencing any issues, but want to watch memory closly to see if we need to go to Enterprise to take advantage of the memory.We are currently watching SQLServer:Memory Manager: Total Server Memory (KB)SQLServer:Memory Manager: Target Server Memory (KB)Does any one suggest other perfmon or stats to watch also? |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-10-01 : 11:31:33
|
| Do you have PAE enabled?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-01 : 11:35:28
|
| what version of windows are you using? It doesn't do any good to enable PAE Michael. Standard only supports 2GB of RAM.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-10-01 : 12:24:19
|
| That's what I was kinda getting at. If he had PAE or AWE or 3GB (i forget which) then maybe the OS was using the rest.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-10-01 : 12:37:44
|
| PAE and AWE are not turned on. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-10-01 : 12:43:50
|
| You are watching the appropriate counters.If target memory exceeds total memory, then SQL Server needs more memory.-ec |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-01 : 13:17:34
|
| I would also look at my cache hit ratio and buffer cache hit ratio.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Std ed or Ent Ed ??