<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
We are currently working with MSSQL which is behind a load-balancer. <br />
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. <br />
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)<br />
my question is: is the MSSQL is fast enough in order to support this pace of transactions while replicating?<br />
<br />
Thanks
</div>
</div>


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

MSSQL replication speed

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.