Database mirroring is a way to increase SQL database availability by maintaining two copies of a single database that must reside on different server instances. This feature is supported on Microsoft SQL Server 2008, 2012, and 2014.
Your team may want to consider database mirroring for your Analysis Expert queries and SQL Reporting, as reporting, especially on larger amounts of data, can be CPU-intensive for your SQL server. By creating a mirror of your SQL database, you can run your reports and queries on the mirror instead of your production database, giving you better performance for clients who are completing reports and clients who are entering data.
Before implementing database mirroring, it's important to consider the frequency of the updates as your users will expect any updates they've made to the data entry to appear in Analysis Expert.
Set Up Database Mirroring
Note: Because database mirroring is a Microsoft SQL Server feature, Resolver is unable to provide full support or instructions for setting up database mirroring on your system. However, the links below will provide you with detailed information based on your version of Microsoft SQL Server. If you need more information, contact Microsoft.
Link the Mirrored Database to the Perspective
Once the initial setup has been completed, you can link the mirrored database to Perspective.
-
Open the Perspective production database.
-
Click the AE Connection tab.
-
Select the Enable AE Mirror Connection checkbox.
-
Enter the name of the SQL server that the mirrored database is on.
-
Enter the Authentication Type.
-
Enter the Database Name.
-
Click OK.
-
Reset IIS to complete your changes.