Hi Tim,

Which tables should I check to monitor the performance of file buffering:

  * Configuration.FileIOStatistics or
  * Configuration.ServerSessionStatistics or
  * Configuration.SessionStatistics

Thanks.

= Steve

Steve,

<< Which tables should I check to monitor the performance of file buffering: >>

You want this one:

Configuration.FileIOStatistics

Tim Young
Elevate Software
www.elevatesoft.com

<< You want this one:

Configuration.FileIOStatistics >>

Cool, thanks Tim.

= Steve

Tim Young [Elevate Software] wrote:

Steve,

<< Which tables should I check to monitor the performance of file buffering: >>

You want this one:

Configuration.FileIOStatistics

Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim,

I share the statistics of my tables,
¿Do you think that the IO Buffers are working as you designed?

Everithing is going smooth, we have several thousands of records stored ok with IO Buffers activated, not any issue until now.

Good Day!

Jorge,

<< I share the statistics of my tables,
¿Do you think that the IO Buffers are working as you designed? >>

Please see my reply here for what to look for:

https://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&page=1&msg=20677#20677

At first glance, the two things that stand out are:

1) You're using the default 4K block size, which is fairly small for larger tables.  I typically use 64K blocks for larger tables.  Increasing the block size will also improve your avg. write size.

2) You're using the default 8MB buffer allocation for each file, which should be tuned further so that it is larger for the large files, and smaller for the small files.

Tim Young
Elevate Software
www.elevatesoft.com