Heartbeat Failure and Failed to Connect Alerts with Duration

I find this especially useful in determining out of box heartbeat settings, since the default 3 minutes is almost never an optimal setting.  Without the information returned from this query, I generally suggest 9 minutes out of box (adjusting the agent interval from 60 to 180 seconds). /* Heartbeat Failure and Failed to Connect with…

1

Root Management Server Unavailable History with Reason

/* RMS Unavailable History with Reason http://blogs.technet.com/b/jonathanalmquist/ 04-19-2011 Updated 04-20-2011 with outage durations dd:hh:mm */ SELECT ME.Path, HSO.StartDateTime AS OutageStartDateTime, CAST (DATEDIFF(SECOND, HSO.StartDateTime, HSO.EndDateTime)/86400 AS VARCHAR(5)) + ‘:’ + CONVERT(CHAR(5), DATEADD(SECOND, DATEDIFF(SECOND, HSO.StartDateTime, HSO.EndDateTime), ”), 114) AS ‘Duration (dd:hh:mm)’, HSO.ReasonCode, DS.Name AS ReasonString FROM vManagedEntity AS ME INNER JOIN vHealthServiceOutage AS HSO ON HSO.ManagedEntityRowId =…

2

Report Dataset Samples

Putting this list of reporting dataset samples out here for your custom reporting needs or just to paste in for general purpose queries to the Data Warehouse.  I’ll update this list when I have new datasets to share. Updated: 09-23-2011 ·        Top alert generating monitors (tuning) http://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/top-monitor-generated-alerts-report-dataset.aspx ·        Top alert generating rules (tuning) http://blogs.technet.com/b/jonathanalmquist/archive/2011/04/08/top-rule-generated-alerts-report-dataset.aspx ·       …

4

Number of Events Collected Per Day (Report Dataset)

/*Number of events collected per day (trending) Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */   DECLARE @RowCount AS INT, @MGID AS INT, @TimeZoneOffset AS INT, @OffSetDays AS INT, @StartDate AS DATE, @EndDate AS DATE SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day, -@OffSetDays,…

0

Number of State Change Events Per Day (Report Dataset)

/*Number of state change events per day (trending) Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */   DECLARE @RowCount AS INT, @MGID AS INT, @TimeZoneOffset AS INT, @OffSetDays AS INT, @StartDate AS DATE, @EndDate AS DATE SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day,…

0

Number of Performance Samples Per Day (Report Dataset)

/*Number of performance samples per day (trending) Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */   DECLARE @RowCount AS INT, @MGID AS INT, @TimeZoneOffset AS INT, @OffSetDays AS INT, @StartDate AS DATE, @EndDate AS DATE SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day, -@OffSetDays,…

0

Top Performance Samples Collected (Report Dataset)

/*Top performance samples collected Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */   DECLARE @RowCount AS INT, @MGID AS INT, @TimeZoneOffset AS INT, @OffSetDays AS INT, @StartDate AS DATE, @EndDate AS DATE SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day, -@OffSetDays, GETDATE())) SET @EndDate…

0

Top Active Repeating Alerts (Report Dataset)

/*Top active repeating alerts Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */   DECLARE @RowCount AS INT, @MGID AS INT, @TimeZoneOffset AS INT, @OffSetDays AS INT, @StartDate AS DATE, @EndDate AS DATE SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day, -@OffSetDays, GETDATE())) SET @EndDate…

0

Top events collected (Report Dataset)

/*Top events collected Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */   DECLARE @RowCount AS INT, @MGID AS INT, @TimeZoneOffset AS INT, @OffSetDays AS INT, @StartDate AS DATE, @EndDate AS DATE SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day, -@OffSetDays, GETDATE())) SET @EndDate =…

0

Top Monitor Generated Alerts (Report Dataset)

/*Top monitor generated alerts Jonathan Almquist (http://blogs.technet.com/b/jonathanalmquist/) 04-08-2011 */   DECLARE @RowCount AS INT, @MGID AS INT, @TimeZoneOffset AS INT, @OffSetDays AS INT, @StartDate AS DATE, @EndDate AS DATE SET @RowCount = 20 SET @MGID = 1 SET @TimeZoneOffset = 5 SET @OffSetDays = 60 SET @StartDate = DATEADD(hour, @TimeZoneOffset, DATEADD(day, -@OffSetDays, GETDATE())) SET @EndDate…

0