Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > MS SQL Server Replication in SolarWinds Orion Database

MS SQL Server Replication in SolarWinds Orion Database

Created by Magdalena.Markova, last modified by Magdalena.Markova on Jul 11, 2018

Views: 4,131 Votes: 2 Revisions: 11

Overview

SQL Replication is a Microsoft technology for sharing a database across multiple SQL servers. Orion is fully compatible with many forms of SQL Replication but some cause problems. 

 

Supported SQL Replication Technologies:

 

Unsupported SQL Replication Technologies:

 

Environment

  • All Orion Platform products
  • Microsoft SQL Server

Detail 

All SQL Replication technologies may cause performance issues. Please consult your Database Administrator to verify Physical Requirements before enabling any Replication technology.

See Considerations for All Types of Replication (© 2018 Microsoft, available at https://technet.microsoft.com/en-us/library/ms152479(v=sql.105).aspx, obtained on July 11, 2018).

 

Replication has several common uses:

 

High Availability

SQL Server has several HA options all of which require some form of Replication. The most common is SQL Always On which can provide Automatic Failover for SQL databases. This may require Merge Replication which is not supported because of the GUID requirement for Primary Keys in our Database. 

See Configure Replication for Always On Availability Groups (SQL Server) (© 2018 Microsoft, available at https://msdn.microsoft.com/en-us/library/hh710046.aspx, obtained on July 11, 2018).

If you set the database to FULL recovery mode which is necessary for Always On, you need to have a fine tuned backup policy. See SQL Server configuration best practices for NPM.

 

Disaster Recovery

Disaster Recovery for SQL Servers can be accomplished using Database Mirroring, Log Shipping, Transaction Log Replication, Snapshot Replication or by using SQL Backups.

See Description of disaster recovery options for Microsoft SQL Server (© 2018 Microsoft, available at https://support.microsoft.com/en-us/kb/822400 obtained on July 11, 2018).

 

Distributed Storage Applications

SQL Database Mirroring can be used to make the same Database available across multiple Data Centers. This can be useful for Distributed Data Applications however this is not usually compatible with HA or DR. 

Concepts

High Availability https://en.wikipedia.org/wiki/High_availability
Disaster Recovery https://en.wikipedia.org/wiki/Disaster_recovery
Distributed Data  https://en.wikipedia.org/wiki/Distributed_data_store

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

 

Last modified

Tags

Classifications

Public