NH Prof New Feature: Query Duration
I keep adding new features and fixing strange bugs in NH Prof. Most of those aren't really interesting things.
Does anyone really care about sort order in a particular query? Those are things that are important for the overall UX, but they are not things that I can honestly call them features.
This thing, however, is a full blown feature. Even if it takes just a tiny bit of screen real estate.
And integrating it into the analysis section of NH Prof as well:
And in the views by method report:
And something that is important to remember, the moment that I have a piece of information, I can start making use of it in alerts and rules. I haven't decided yet if I want to do so for the v1.0 release, but I have a feeling that this is going to be a very useful base for additional features.
Comments
Not so long ago I've been fighting very hard to debug database problems - namely database query deadlocks or transaction timeouts. These errors were very often caused by interference between two parallel queries. It was hard to debug because I couldn't easily identify what queries were executing together with the problematic transaction. I don't know NH Profiler, but it would be nice if such tool had
a) statistics of errors for each query (with a reference to source code)
b) a quick way to identify queries executing at specific moment of time, especially at the time of exception