?
Solved

MSSQL replication speed

Posted on 2015-01-01
1
Medium Priority
?
139 Views
Last Modified: 2015-01-12
Hi,

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?

Thanks
0
Comment
Question by:Yaniv Gutman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 79

Accepted Solution

by:
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.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

762 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