which gives good performance..snapshot replication or transactional replication?

for the same workload and same environment we are implimenting snapshot replication and transactional replication at diffrent locations over produdction servers. Both standby servers we are using for adhoc report generation and for end user interface. Which performs better?

more ▼

asked Mar 19, 2010 at 01:47 AM in Default

avatar image

562 29 31 36

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Depends how often the replication will occur and often the data in the production database are modified and also the amount of data being replicated.

Generally the transaction replication will give you a better performance as only the changes are propagated to the subscribers periodically. During the snapshot replication the whole snapshots needs to be redistributed. Also transactional replication will put less locks on the source system.

See: http://msdn.microsoft.com/en-us/library/ms151734.aspx and http://msdn.microsoft.com/en-us/library/aa179423%28SQL.80%29.aspx

more ▼

answered Mar 19, 2010 at 04:45 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

(comments are locked)
10|1200 characters needed characters left

I started to write a long answer but realized you need to define 'performs' before anyone can give an answer shorter than a book. What, and be very specific, do you expect this replica to do for you?

more ▼

answered Mar 19, 2010 at 03:58 AM

avatar image


can you give that long answer.,first be clear to understand my question.

Mar 19, 2010 at 04:04 AM venkatreddy

better you understand what i did asked.please be clear about the question, at least in understanding not in answering.I have clearly asked the things..

Mar 19, 2010 at 04:16 AM venkatreddy
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 19, 2010 at 01:47 AM

Seen: 4223 times

Last Updated: Mar 19, 2010 at 01:03 PM

Copyright 2018 Redgate Software. Privacy Policy