SQL Server Replication

Keep your Always On availability groups
running smoothly to avert disaster.

To achieve the highest level of data availability and disaster recovery for organizations, Always On availability groups for SQL Server are part of an integrated solution.

Always On availability groups allow database administrators to automatically or manually failover a group of SQL Server databases as a single unit with support for several secondary replicas.

Monitor the health of Always
On availability groups, databases,and replicas.

Replicas
topology

Display the topology of
the configuration of Always On availability groups.

View the state of SQL Server replication at a
selected point in time and compare statesat different points in time.

server_replication
alert

Receive alerts when metrics for
Always On availability groups areoutside of their baseline thresholds.

Send only a single message with
summary information for several relatedalerts for SQL Server replication.

server_replication
diagnose

Diagnose and resolve issues for
Always On availability groups tokeep the issues from reoccurring.

Easily and quickly monitor Always On availability groups with SQL Diagnostic Manager:

Display relevant charts, alerts, and alert response bundles in a dedicated window view.

Drill down to identify problems and locate their root cause.

Display problems with Always On availability groups that occurred in the past.

Display the topology and statistics ofAlways On availability groups.

diagnostic_manager

SQL Diagnostic Manager combines and collates
a lot of information that would otherwise have to be collected and
evaluated manually. It thereby creates efficiencies for the team,
improving monitoring, troubleshooting, and response times.

Jacob SoRelle, IT Specialist, Franchise Tax Board

(state and local government, USA, 500 to 999 SQL Server databases)

Learn more about how SQL Diagnostic Manager can help you keep your Always On availability groups running smoothly to avert disaster. Request a personalized product demonstration with a seasoned expert, download a free, fully functional, 14-day product trial, or request a price quotation.

Whitepaper: Why Your Always On Solution is Not Always On

Read this whitepaper to learn how to avoid pitfalls that can cause unexpected failures with Always On technologies. The whitepaper delves into three issues that can cause Always On solutions to not be always on. These are three common scenarios that many database administrators do not even consider when planning to deploy an Always On solution. These issues are generally not recognized until problems arise from them. With careful planning and preparation, be proactive and prevent these issues from taking solutions offline.