• The long running query log falls a bit short in an oltp environment, because it can only be set at the second level. For example if you want to track queries running over 100 ms, you can't use this feature out of the box. I say out of the box, because I know there is a tweak to the source code you can compile that does provide this functionality.

    ken kaufman
    Lead DBA, Zillow.com