SQL PL Profiler - Again, better than ever
I spent the time around the July 4th weekend at the IT building a major bank in Jersey City assiting in the "going-live" of their .com website on DB2 after moving their core internet application away from Oracle.
Needless to say there were the usual hiccups compounded by the fact that the app is non trivial and has stringent Service Level Agreements (SLA) to fullfill.
So, naturally, like any good tradesperson I brought my tools including the SQL PL Profiler I posted about a while ago.
When I wrote this profiler however I had left some gaps which now was a great time to close.
To make a long story short I have uploaded a new version of the profiler and as always I'm looking for feedback.
There are a few more/new gaps I would like to address in the future:
To not duplicate efforts and keep one version of the truth out there I have edited my post to update the documentation and sourcecode rather than repeating it here and here is the link:
Reality Check: SQL PL Profiler and plan explain with actual row counts