Profiler new features, Sept Edition
The first feature is something that was frequently requested, but we kept deferring. Not because it was hard, but because it was tedious and we had cooler features to implement: Sorting.
Yep. Plain old sorting for all the grids in the application.
Not an exciting feature, I’ll admit, but an important one.
The feature that gets me exciting is the Go To Session. Let us take the Expensive Queries report as a great example for this feature:
As you can see, we have a very expensive query. Let us ignore the reason it is expensive, and assume that we aren’t sure about that.
The problem with the reports feature in the profiler is that while it exposes a lot of information (expensive queries, most common queries, etc), it also lose the context of where this query is running. That is why you can, in any of the reports, right click on a statement and go directly to the session where it originated from:
We bring the context back to the intelligence that we provide.
What happen if we have a statement that appear in several sessions?
You can select each session that this statement appears in, getting back the context of the statement and finding out a lot more about it.
I am very happy about this feature, because I think that it closes a circle with regards to the reports. The reports allows you to pull out a lot of data across you entire application, and the Go To Session feature allows you to connect the interesting pieces of the data back to originating session, giving you where and why this statement was issued.