Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

I need SAM DB Always on template

Hi Thwack family,

We use the DB Always on architecture and ı need to monitor the DB Always on the system but I dont know how I monitor, That's way I need your help, My need, How can I monitor Always on system and How I create SAM template for Always On architecture

thank you so much

Find more posts tagged with

Accepted answers

Seashore

Here is a template we use to see that the SQL Availability Groups are in sync and cluster service is running. You might need to change the SQL instance the SQL query is running against.

[View:/cfs-file/__key/communityserver-discussions-components-files/194/SQL-Basic-AG.apm_2D00_template:640:480]

All comments

Seashore

Here is a template we use to see that the SQL Availability Groups are in sync and cluster service is running. You might need to change the SQL instance the SQL query is running against.

[View:/cfs-file/__key/communityserver-discussions-components-files/194/SQL-Basic-AG.apm_2D00_template:640:480]

jdudas

team does this also include monitoring of availability group events such as AG failover?

Seashore

No it does not, guess you then need to query the eventlog for failover events

jdudas

gotcha might need to use SQL user experience monitor then via a sql script

seymanur

Hi Seashore,

Thank you so much for template, I have been using and it works