MSSQL replication speed

Posted on 2015-01-01
Medium Priority
Last Modified: 2015-01-12

We are currently working with MSSQL which is behind a load-balancer.
We have a new project which requires a high speed data storage and retrieve. we thought of using our MSSQL (running on Windows 2008 R2) which is of a high availability and replicates himself among two servers.
In our new project we are dealing with ~1000 requests per second which needs to be replicated in order to support high-availability environment (so if one server goes down the backup server will have all of the required data)
my question is: is the MSSQL is fast enough in order to support this pace of transactions while replicating?

Question by:Yaniv Gutman
1 Comment
LVL 81

Accepted Solution

arnold earned 1500 total points
ID: 40526779
If you have enterprise level of ms sql server, configuring database mirroring from the clustered instance to a separate system might be your best bet. Prior to running the queries you can use snapshot on the mirrored instance and performing all the queries you need without adversely affecting your production environment.

You've not said the type of queries, so I presume theses are report (read only) queries.

In an Ha setup, usually they have a common storage such that only one system accesses the storage at a time, a failure of the one node, transitions to the second which then gets access to the underlying storage. The data in this type of setup is not replicating, access to the data is switched.

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question