SQL Server Performance Forum – Threads Archive

Do and Don’t

I am planning to configure replication. I was wondering, what are replication Do’s and Don’ts on a production environment? Is there standard replication performance related guide which list’s, what we need to do here? Appreciated any input on this. Thanks,
Cali

---

Well, Replication is vast area. Before answering to ur question, what is your requirement. How do you want to replicate. Does your requirement needs to allow to update from both end There is presentation slides on SQL Server replicationhttp://sqlserveruniverse.com/files/folders/101/download.aspx —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

Thanks for your email. I was looking more into, how to configure the distributer? What about memory consideration? what about other check marks which needs to keep in mind before implementing replication? Any standard replication setup guidelines? Common solutions for replication? These are the areas, i am looking into. If you have anything related to this, that will be great. Thanks,
Cali

---

What type of replication are you planning to implement? Raulie

---

Transactional replication. Please Note: My production database environment is a very busy system and users are doing inserts,update and deletes constantly. I.E every seconds there are tons of transactions running against this database. I am planning to implement replication for reporting purposes. Therefore before i implement, i want to know all the details and see, which one will best suit us. Thanks,
Cali

---

It depends on how much you want to replicate and how reliable your network etc…
It is not advisable to replicate whole db for reporting unless there is no option…
Do you really need upto the minute data for reporting? If not then there other ways better than replication… Read the following which will also apply to sql 2005… Transactional Replication Performance Tuning and Optimization
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx Setting Up Transactional Replication with SQL Server 2005
http://www.awprofessional.com/articles/article.asp?p=599700&seqNum=1&rl=1
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

… also don’t foreget to refer through SQL Server 2005 books online specific to changes in replication as compared to previous versions, also Dinesh’s presentation covers most of it. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Thanks for the answer MohammedU and Satya. MohammedU my reporting data need’s to be available in real time. is there better way to do this? My SQL Server version is 2000. I read about 2005 and one of the thing came to my mind was mirroring. Yes have my production database mirror and run snapshot’s on this mirror copy. i believe, this would be a real time data. but since i am still with 2000, i need to look a better solution on 2000. Any comments? thanks,
Cali

---

Please post the question in relevent topic so that you get the correct reply… In 2000 replication is the best approach for realtime reporting… Note: you may be get into issue if the size of the tables are huge…and when you need to initialize the snapshot specially during the day… MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

Follow as referred by Mohammed to get information on your issue. YOu are correct that SQL 2005 offer various mix and match with dbmirroring and replication in this case, but before that you should look at the data feasibility & availability.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

]]>