Few weeks ago, the OMS product team has made a very nice change for the Near Real Time (NRT) Performance data – the data aggregation has been removed! I’ve been waiting for the official announcement before posting this on my blog. Now Leyla from the OMS team has finally broke the silence and made this public: Raw searchable performance metrics in OMS.
I’m really excited about this update. Before this change, we were only able to search 30-minute aggregated data via Log Search. this behaviour brings some limitations to us:
- It’s difficult to calculate average values based on other intervals (i.e. 5-minute or 10-minute)
- Performance based Alert rules can be really outdated – this is because the search result is based on the aggregated value over the last 30 minutes. In critical environment, this can be a bit too late!
By removing the data aggregation and making the raw data searchable (and living a longer life), the limitations listed above are resolved.
Another advantage this update brings is, it greatly simplified the process of authoring your own OpsMgr performance collection rules for OMS NRT Perf data. Before this change, the NRT perf rules come in pairs – each perf counter you want to collect must have 2 rules (with the identical data source module configurations). One rule is for collecting raw data and another is to collect the 30-minute aggregated data. This has been discussed in great details in Chapter 11 of our Inside Microsoft Operations Management Suite book (TechNet, Amazon). Now, we no longer need to write 2 rules for each perf counter. We only need to write one rule – for the raw perf data.
The sample OpsMgr management pack below collects the “Log Cache Hit Ratio” counter for SQL Databases. It is targeting the Microsoft.SQLServer.Database class, which is the seedclass for pre-SQL 2014 databases (2005, 2008 and 2012):
OMS.NRT.Perf.Collection.Demo 0.0.0.2 OMS.NRT.Perf.Collection.Demo Microsoft.IntelligencePacks.Types 7.0.10013.0 31bf3856ad364e35 Microsoft.SQLServer.Library 184.108.40.206 31bf3856ad364e35 Microsoft.Windows.Library 7.5.8501.0 31bf3856ad364e35 System.Library 7.5.8501.0 31bf3856ad364e35 PerformanceCollection $Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ Log Cache Hit Ratio SQLServer:Databases $Target/Property[Type="SQL!Microsoft.SQLServer.Database"]/DatabaseName$ false 10 OMS NRT Perf Collection Demo OMS NRT Performance Collection Demo SQL Log Cache Hit Ratio Perf Rule
As you can see from the above sample MP, the rule that collects aggregated data is no longer required.
So if you have written some rules collecting NRT perf data for OMS in the past, you may want to revisit what you’ve done in the past and remove the aggreated data collection rules.