I would like to be able to click on the 122 in the following screen and have it take me to the detail page for the SPID for this same date and time selection:
Instead, I now have to click on the Sessions tab, and then visually attempt to find 122 in the list of sessions on this screen:
The SPID numbers are not searchable using Ctrl-F in the browser because of the way they are displayed. The list could contain hundreds or thousands of entries, and only appear in order by amount of wait and cannot be sorted by SPID number to make a specific entry easier to find.
In my case, SPID 122 does not appear in the list at all. My intent is to find the most recent SQL statement executed by the SPID during the selected date and time range. If there is no activity for the SPID in the selected date and time range, the page would have no data to display. However, it should still have the SPID shown in the navigation bar at the top of the screen. I could then select the previous time range in the drop-down (which would be 5:00PM to 6:00PM in my example), and then hopefully see the SQL for the session displayed as expected:
Sadly, in my case, SPID 122 does not appear in the list for the previous hours either, but hopefully the data for it is in the repository somewhere even though it isn't considered a "Top Session" during the selected time range.
