April 10, 2012 at 11:25 am
Hi,
I'm planning on setting up alerting for Availability Groups via SQL Alerts on Event IDs, unless anyone has a better suggestion? (WMI?)
I've been able to manually watch the app log and pull a list of related events.
1480
19406
35202
35266
35267
35299
41074
41093
I'm having trouble finding a MS article listing the specific Always On Event IDs (I don't want to miss any). Has anyone see such a list?
April 10, 2012 at 11:39 am
Add
-namespace "root\Microsoft\SqlServer\ComputerManagement11"
-class HADRServiceSettings
...to the list of Documentation I'm looking for
April 11, 2012 at 4:59 am
I haven't tried setting up an alert, but I have set up monitoring using some of the DMOs available. This Book Online entry lays out a bunch of the options.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply