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 |
|
mcrowley
Aged Yak Warrior
771 Posts |
 Posted - 2006-04-27 : 11:30:44
|
I have seen several people say that memory:pages/sec should be kept at 20 or lower. But in the MS SQL Server 2000 Performance Tuning book, it says (page 17):quote:
A low number of occasional pages per second is normal (bouncing between 0 and 100, for example), but a continuously high...
Kalen Delaney says (page 978):quote:
As the system settles into a steady state, you want these values to be 0-that is no paging going on in the system.
Try as I might with Google and these books, I can not find any microsoft source that states what a "high" amount of pages/sec is. Do any of you have any such "authoritative" sources? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-04-27 : 12:11:47
|
| It is really not that simple. It depends on the reason you are paging, and how much is actually being read and written to the page file on disk.For example, when you run a backup, the system will allocate pages to the file system cache to handle the data. This is normal, but will appear in the Performance Monitor as very high paging.You should see close to zero paging most of the time, if your system is setup with enough memory.CODO ERGO SUM |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-04-27 : 16:51:45
|
| During normal business operation (minus the backups), it should be zero as Kalen stated. You need to take backups into account though. If you shutoff the transaction log backups, or you can track the time they begin and end, you should be able to metric a zero usage period. I wouldn't worry about it during the backup period, unless you are also seeing an IO queue length issue during the same period. At that point, you need to figure out how to either spread the window out more or increase your IOPS capacity to take spike periods into account.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
Acceptable Perfmon limits