SQL Server Performance Forum – Threads Archive
Newbie Replication questionHi all<br /><br />We’re proposing a solution for a customer at the moment. They currently have a SQL server that they run their internal product system from. <br /><br />They want the information from this system to be made available to an extranet to be hosted locally. We initially proposed that we would export the required information from their current server to a web/sql server overnight. <br /><br />They have asked if their data could be realtime. They want the web server to mirror the current server.<br /><br />We would still propose two servers because of the potential strain on the current server.<br /><br />So my question is, what sort of work does SQL have to do, and what sort of strain on their network will their be, if SQL is synchronising all day.<br /><br />Would Transactional replication be the best way? Does this lock the database whilst it is updating? If so, the web server is locked out too isn’t it?<br /><br />I don’t like the sound of it!<br /><br />Cheers<br /><br />Gareth <br /><br />p.s. be gentle, its my first post [<img src=’/community/emoticons/emotion-5.gif’ alt=’‘ />]
No worries, transactional replication would be suitable for this kind of shop.
And go thru this linkhttp://www.sql-server-performance.com/replication_tuning.asp andhttp://www.sql-server-performance.com/transactional_replication.asp for performance tips. Do you have any other application running parallely on both the servers? _________
Transactional replication would be great, although not 100% real time. You are not planning to do any updating from the extranet? How much data is updated internally and is it regular or large batches? The replication work does lock rows as any other process would, but it is all based on primary keys so will be fast. We use transactional & merge replication here and have not had any problems to date. Cheers