• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 46
  • Last Modified:

how to monitoring MS SQL AOG

hi,

for the experts who keep using SQL server 2014/2016 AOG, other than the AOG dashboard from SSMS, what kind of script / tools you all use to monitor AOG healthy, throughput of data replication ,e.g. ?
0
marrowyung
Asked:
marrowyung
  • 2
  • 2
2 Solutions
 
Paul MacDonaldDirector, Information SystemsCommented:
I use an old product called IPMonitor that essentially looks to see if SQL is running on the AOG Listener.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I guess I already told you few times about monitoring SQL Server. Invest in a good monitoring tool.
From my experience and especially for Microsoft's products, I use SCOM.
When you need to expand the monitoring to other OS and DBMS, then I'll recommend BMC Patrol.

Mind that they aren't cheap solutions but what they provide, pays for dozens of people monitoring and customizing their own monitoring scripts.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
tks victor,

but do you use any script to monitor it ? basic monitoring ?

I use Idera SQL tools  before and it seems it doesn't support it but I might try it later.

SCOM is expensive and I heard it is not good, isn't it ?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
No. Like I said, if we're paying for SCOM and BMC Patrol, why should we loose time developing monitoring scripts? The idea is to take from us those kind of tasks and not put more work on us.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now