Oninit cdi / Archive
Talk to an expert →

Buffer Turnover Rate for IDS11.x

Posted in 2009

Topics: Storage & Space Management, Stored Procedures & SPL

fandelau — — source: Usenet: comp.databases.informix

All: I was wondering if there is a way to calculate the BTR on an instance that has both 2k and 16k page sized dbspaces, with buffers defined with 2 of the new BUFFERPOOL configuration parameter. Yeah, I know, I'll standardize 16k pages soon enough... but in the meanwhile, since onstat -p doesn't split the figures if displays per BUFFERPOOL values,I was wondering how to calculate the BTR with the new configuration... or should this metric be deprecated? Art? David? Thanks in advance! Ramon

↪ replying to fandelau
Mark Jamison — — source: Usenet: comp.databases.informix

Hi Ramon, Use onstat -g buf That output should allow you to calculate BTR based on Buffer Size. ________________________________ From: fandelau <fandelau@gmail.com> To: informix-list@iiug.org Sent: Wednesday, August 26, 2009 2:19:42 PM Subject: Buffer Turnover Rate for IDS11.x All: I was wondering if there is a way to calculate the BTR on an instance that has both 2k and 16k page sized dbspaces, with buffers defined with 2 of the new BUFFERPOOL configuration parameter. Yeah, I know, I'll standardize 16k pages soon enough... but in the meanwhile, since onstat -p doesn't split the figures if displays per BUFFERPOOL values,I was wondering how to calculate the BTR with the new configuration... or should this metric be deprecated? Art? David? Thanks in advance! Ramon _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

Related threads

Glossary