Submit a ticketCall us
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 Feb 08, 2017

Views: 3,579 Votes: 2 Revisions: 8


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:



  • All Orion Core products
  • Microsoft SQL Server


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




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. 




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.




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. 




Microsoft References


SQL Server
SQL Translog Replication
SQL Replication
SQL Log Shipping
SQL DB Mirroring
SQL Snapshot Replication
SQL Merge Replication
SQL Always On
SQL Distributed database
SQL Replication Performance Considerations


High Availability
Disaster Recovery
Distributed Data

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