Re: Outrageously low write cache %

In article <93ikud$ikl$1@nnrp1.deja.com>, Lyzander Marantal <zandy@my- deja.com> writes >Can anybody help? > Checkpoints are fast, lio and pio vps are virtually idle. I assume that since ER is being used that your databases are logged. Perhaps it is just that you are hardly writing anything to the database? Or that all writes are going to different pages? 'Hits' in the write cache only occur when >1 write to the same page occurs! -- David Williams

Thanks for your reply David. I think most of my writes are going to the logical logs. For what transactions, that I still have to find out. In article <su46phABvlX6Ewey@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: > In article <93ikud$ikl$1@nnrp1.deja.com>, Lyzander Marantal <zandy@my- > deja.com> writes > >Can anybody help? > > > > Checkpoints are fast, lio and pio vps are virtually idle. I assume > that since ER is being used that your databases are logged. > > Perhaps it is just that you are hardly writing anything to the > database? Or that all writes are going to different pages? > > 'Hits' in the write cache only occur when >1 write to the same > page occurs! > > -- > David Williams > Sent via Deja.com http://www.deja.com/