Solved

MSSQL replication speed

Posted on 2015-01-01
1
118 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 78

Accepted Solution

by:
arnold earned 500 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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
Viewers will learn how the fundamental information of how to create a table.

749 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