The most recent content from our members.
As shown on this screen, SPID 122 was an idle blocker: For the SPID being blocked, there is a value in the SQL column. Of course, there is not one for SPID 122 because by definition, there is no active SQL for it. However, it would be very useful to have a link with text similar to "Most recent SQL for this session" that…
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…
DESCRIPTION This procedure finds all SQL statements for the given date range and SPID ordered by wait times. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the Ignite repository database. STORED PROCEDURE IF (SELECT COUNT(*) FROM SYS.OBJECTS…
It looks like you're new here. Sign in or register to get started.