Brianegge: Created page with 'In performance tuning complex Sybase queries, I usually keep an eye on the total logical IO. I've created the following one-liner to be used from within sqsh to sum up the logic…'

2010-01-20T00:12:36Z

Created page with 'In performance tuning complex Sybase queries, I usually keep an eye on the total logical IO. I've created the following one-liner to be used from within sqsh to sum up the logic…'

New page

In performance tuning complex Sybase queries, I usually keep an eye on the total logical IO. I've created the following one-liner to be used from within sqsh to sum up the logical IO.

<geshi lang="ruby">
| ruby -pe 'BEGIN{@sum=0}; if $_ =~ /logical reads: $regular=\d+ apf=\d+ total=(\d+)$/ then @sum += $1.to_i; end; END{puts "TOTAL = #{@sum}" }'
</geshi>

This requires '''set statistics io on;''' and optionally '''set showplan on;'''

[[Category:Sybase]]
[[Category:Ruby]]
[[Category:Performance]]

Sum Sybase Logical IO - Revision history

Brianegge: Created page with 'In performance tuning complex Sybase queries, I usually keep an eye on the total logical IO. I've created the following one-liner to be used from within sqsh to sum up the logic…'