SQL Server Performance

Dust out few tasks to gain transactional replication performance in SQL 2005

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 16, 2007.

  1. Anonymous New Member

    Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at the Publisher are usually delivered to the Subscriber as they occur (in near real time). So the consistency within the transactions is guaranteed and you cannot take any risks by changing the database recovery model. So coming to the performance bit,...(<a href="http://sqlserver-qa.net/blogs/replication/archive/2007/08/16/1479.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1479" width="1" height="1">

Share This Page