Now translated to 34 different languages!

Since we migrated to a new platform in May, 2010, there are more options for us as bloggers to customize the readers’ experience.  I was making some changes to my blog recently and noticed we now have a translator widget available.  Not sure if this was an option from the start, but I didn’t notice…

2

The threshold for the Logical DiskAvg. Disk sec/Transfer performance counter has been exceeded

If you see these alerts generated by your Windows 2008 and Windows 2008 R2 servers with unusually high values, this is due to an issue with the RegQueryValueEx function, which is used in the Average Disk Seconds Per Transfer monitor. For Windows 2008 R2, apply this hotfix: http://support.microsoft.com/kb/2470949 For Windows 2008, apply this hotfix: http://support.microsoft.com/kb/2495300…

0

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

Inventory and Configuration Reports

Someone asked today if there was a way to generate a report displaying inventory/configuration of SQL Server.  Chris Harris, SCOM Program Manager, answered the question with one of our built-in configuration reports.  He was so kind as to provide screenshots and everything, and indicated that someone should blog it.  So, here you go.  Thanks, Chris! …

3

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