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 |
|
Simon_L
Starting Member
32 Posts |
 Posted - 2009-04-22 : 09:47:45
|
| Hi running an hour long perfmon trace with 5 sec intervals Im looking at (amongst other things) memory : pages/sec and buffer cache hit ratio. The pages per sec is an average of 9 peaking at 3495. Might suggest a memory problem .. but the buffer hit ratio is constantly at 90% which I interpret as SQL using buffer memory efficiently etc...Am I misreading this ? what should be my next step to confirm either way ? many thanks Simon |
|
|
|
|
|
Perfmon ... memory problem or red herring ?!