• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 59 subscribers
  • Views 4181 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Can rules be created based on database group service?

randy.scott
over 6 years ago

We want to create database groups based on Tiers of importance.  We would create something like this:

I have concerns about creating rules on services because I have found reference to a document that states not to go more than three levels deep. 

According to the thread "Custom rule causing CPU issues", a search "within ^3" can be expensive in larger environment.

If anyone has access to the thread about the custom rule causing issues, can you send me an updated link?  The link seems to be broken.

 

What is considers 3 levels in a service?

 

For instance, I want to create alarms based on the jobs under the "Agent Job List" above?  I am alerting based on job related information?  Would this be too deep?  

Parents
  • 0 over 6 years ago
    Hi Randy,

    Have you tried creating a rule with scope something like this :

    DBSS_Agent_Job_List where $object within^inf (FSMService where name = 'C-Tier1')

    This scope will return all instances of DBSS_Agent_Job_List in all SQL Server instances under included in FSMService C-Tier1.

    Regards
Reply
  • 0 over 6 years ago
    Hi Randy,

    Have you tried creating a rule with scope something like this :

    DBSS_Agent_Job_List where $object within^inf (FSMService where name = 'C-Tier1')

    This scope will return all instances of DBSS_Agent_Job_List in all SQL Server instances under included in FSMService C-Tier1.

    Regards
Children
No Data