EntityGroup and AlertRule Extensibility

Jul 14, 2009 at 12:41 PM

Can new EntityGroups and AlertRules be created easily? How can EntityGroups be created? Any API? only via .Net code seems closing out a lot of people to contribute to a powerful monitoring tool.

Is it possible to monitor and persist performance counter data?

Is it possible to integrate script based monitoring? TSQL scripts are widely available to monitor about anything. Integrating the strength of these scripts into sqlmonitor will increase its power.

This would lead to an open tool in which DBA can integrate their scripts.

Sep 18, 2009 at 3:48 PM

If you look at the EntityGroup table you will notice a CustomCollectorText column. You can put a T-SQL script in there which must generate a certain set of columns with data. I'm still testing with it but that will be the key. The adding of new alertrules or entitygroups will be possible through the gui in the next release.