Can we monitor Database Replication?

martian_monster 2 months ago

Greetings -

Can we monitor database replication using SQL Sentry, DPA, or something in Solarwinds Orion?

I did some quick searching and did not come up with anything yet.

Thanks!

Dave

Top Replies

marcrobinson 2 months ago in reply to bobmarley +2

SAM can do this with the SQL Experience component. I think the table was system state or something. I created a template to look up the AG status's. This table logs the replication state, master, etc.…
Seashore 2 months ago in reply to martian_monster +2

You can use a SAM SQL monitor to query the SQL instance if there are any AG's that is failing. Use below query: select g.name INTO #AGStatus from sys.dm_hadr_availability_group_states S inner…
bobmarley 2 months ago +1

It's been a few years (and a different employer) since I have set this up but I set up a SAM template that did a SQL query that determined if the SQL instance was primary or backup. Similar to this sys…

Parents

0 mandevil 2 months ago

What kind of replication are you doing? AGs, mirroring, other?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 martian_monster 2 months ago in reply to mandevil

The simple answer is AGs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 adam.beedell 2 months ago in reply to martian_monster

AG health is probably what you want, there's a windows event log for errors and then health can be done with powershell SAM or simmilar, perhaps just SQL SAM
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

0 Seashore 2 months ago in reply to martian_monster

You can use a SAM SQL monitor to query the SQL instance if there are any AG's that is failing. Use below query:

select 
	g.name
INTO #AGStatus
from sys.dm_hadr_availability_group_states S
inner join sys.availability_groups G on s.group_id=G.group_id
Where synchronization_health<2
AND s.primary_recovery_health=1

IF (Select COUNT(name) from #AGStatus)>0 
BEGIN
		Select 
		count(*) as "Rowcount", 
		t.FailingAG 
		from(
			Select 
				substring(
				(
					Select ', '+ags.name  AS [text()]
					From #AGStatus ags
					For XML PATH ('')
				)
				, 2, 1000) [FailingAG]
	From #AGStatus ags) 
	as t
	group by t.FailingAG 

END
ELSE
Select 0 AS "RowCount"

Drop table #AGStatus

Reply

0 Seashore 2 months ago in reply to martian_monster

You can use a SAM SQL monitor to query the SQL instance if there are any AG's that is failing. Use below query:

select 
	g.name
INTO #AGStatus
from sys.dm_hadr_availability_group_states S
inner join sys.availability_groups G on s.group_id=G.group_id
Where synchronization_health<2
AND s.primary_recovery_health=1

IF (Select COUNT(name) from #AGStatus)>0 
BEGIN
		Select 
		count(*) as "Rowcount", 
		t.FailingAG 
		from(
			Select 
				substring(
				(
					Select ', '+ags.name  AS [text()]
					From #AGStatus ags
					For XML PATH ('')
				)
				, 2, 1000) [FailingAG]
	From #AGStatus ags) 
	as t
	group by t.FailingAG 

END
ELSE
Select 0 AS "RowCount"

Drop table #AGStatus

Children

No Data