SQL Server Performance Forum – Threads Archive

Size of the queue in Transactional Replication

Hi In addition to my previous query, I wud also like to know the number of transactions possible(size of the queue) in transactional replication with queued updating. That is I want to know how many tranactions can be stored in a queue without loss of data when the connection between the Publisher and Subscriber is not there. Anyone on this please?…[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards Shantaram

Not sure what exactly you’re looking, may refer thishttp://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx link about fine tuning the performance. Also look under books online for Transactional replication topic. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi Satya
Thanx for the reply….I’ll try to make the question simpler…
In case of transactional replication, when there is no connection between the publisher & the subscriber how many transactions can get stored in a queue without any of the transaction getting lost till the time the connection is regained.
Hope now the question is more clear.
Regards
Shantaram.

I guess that depends on the memory available to SQL server and in order to continue the transactions there shouldn’t be any interruption between the servers. Refer tohttp://msdn.microsoft.com/library/d…patterns/html/ImpTransactionalReplication.asp about implementing master-slave type of replication that may be suited to the current issue. HTH Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>