Customized alert settings at 'All Servers' level.

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Customized alert settings at 'All Servers' level.

Postby fruyven » Thu Nov 10, 2011 10:45 am

How can I see what alert have been customized at this level?

This seems to be true: "You can see which alerts have been customized at which levels in the Monitored servers list; they are indicated by the number in brackets"

But at this level (All Servers) this seems to be untrue: "When you select a level in the Monitored servers list, those alerts that have been customized at the selected level are identified by <This level> and highlighted in bold"

(Quotes from http://www.red-gate.com/supportcenter/C ... 418820.htm)
fruyven
 
Posts: 6
Joined: Tue Aug 23, 2011 11:01 am

Postby fruyven » Thu Nov 10, 2011 12:06 pm

I think I found a work-around.

select * from [alert].[Alert_Type] where [AlertType] in (select [_AlertType] from [config].[AlertConfiguration])
fruyven
 
Posts: 6
Joined: Tue Aug 23, 2011 11:01 am

Postby priyasinha » Thu Nov 10, 2011 12:16 pm

Hi,

Thanks for your post.

Unfortunately, this is not very visible at 'All Servers' level. The idea was that if you change something at this level then it becomes default for you. Though you can see how many have changed (from factory default) by seeing the number against 'All Servers' level.

It would be nice to know why you would like to know what has been changed from factory defaults at 'All Servers' level?

Note: You can always retrieve this directly from SQL Monitor database repository.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Re:

Postby priyasinha » Thu Nov 10, 2011 12:18 pm

fruyven wrote:I think I found a work-around.

select * from [alert].[Alert_Type] where [AlertType] in (select [_AlertType] from [config].[AlertConfiguration])


Yes, you are absolutely correct :).

Regards,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby fruyven » Thu Nov 10, 2011 1:00 pm

"It would be nice to know why you would like to know what has been changed from factory defaults at 'All Servers' level?"

The reason is that we have just recently started using SQL monitor and now I want to review the configuration changes we made before.

Thank you for your reply.

Regards,
Frits
fruyven
 
Posts: 6
Joined: Tue Aug 23, 2011 11:01 am

Postby priyasinha » Thu Nov 10, 2011 1:02 pm

Thanks a lot for your reply Frits.
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests