Sorting DB statements in DB dashlet by time executed
How do I get a timestamp column and sort by that on the database dashlet? I've looked at the available columns and don't see it.
Thank you!
Hi Bennett,
The database dashlet is an "aggregate" dashlet, just like the Web Requests, Methods, etc dashlets. That means that any SQL statement you see there doesn't necessarily represent a single execution of that query. That's why there's not an execution timestamp column - it doesn't apply here.
You can see any statement in the context of its actual PurePath though, by r-click, Drill Down->PurePaths. The PurePath does have a timestamp on it, and from the Elapsed Time column you can get an idea when any particular query executed.
Hope this helps,
Rob
