The most recent content from our members.
Description This alert will run against the monitored Oracle databases and retrieve the time a session has been waiting ("Seconds Blocked" column) on a blocking session. It will also give some details about the blocking session in the "Message" column and this can be customized with anything else from v$session. ALERT…
Description This alert will run against the monitored instance and retrieve the time each session has been blocked ("Seconds Blocked" column). It will also give some details about the blocking session in the "Message" column and this can be customized with anything else from sys.dm_exec_requests DMV. Alert Definition To…
Occasionally network design changes and we want to stop using certain subnets. The subnet may remain as a legacy segment but we want no new allocations. I tried using custom roles but the way permissions work today you have to start with the lowest permission (read only) and then added higher permission for all the other…
Description This query will report on blocking by pulling blocking information directly from the SQL Server DPA repository. SQL Query --This query will report on blocking directly from the DPA repository for a specific date / time range and a instance. DECLARE @start_time VARCHAR(16) , @end_time VARCHAR(16) , @DBNAME…
DESCRIPTION This procedure will return the top 30 SQL statements for the given instance and date range ordered by total seconds spent waiting on blocks. This report reads summary data, so running it for a time range less than one hour will not yield correct results. Note: See comments inside the procedure for more details…
Description This alert will look for time waiting on any of the SQL Server lock wait type (starts with LCK) in the Ignite repository and return the total time waited. This is executed against the Ignite repository while others listed here execute against the monitored instance. Alert Definition To create the alert, click…
It looks like you're new here. Sign in or register to get started.