THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Jorg Klein

Microsoft Data Platform MVP from the Netherlands

Replication Services in a BI environment

You can read this blog post at this link: https://jorgklein.com/2011/02/02/replication-services-in-a-bi-environment

This blog has moved to www.jorgklein.com There will be no further posts on sqlblog.com. Please update your feeds accordingly.

You can follow me on twitter: http://twitter.com/jorg__klein

Published Thursday, February 24, 2011 4:13 PM by jorg

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Ted said:

I'm currently doing this now with Transactional Replication, and have been for a while.  There are some minor issues to grapple with, but for the most part this is a very good workable solution.

I also keep a 'dev' reporting database up to date using the exact same publications.

One thing to keep your eyes on is the performance of the replication and latency during your peek reporting demands.  If the intention of this replicated database is to be near real time having bad queries lock/block and tie up the database will slow down replication.

I have tweaked and fiddled and am finally happy with my installation and monitoring of the replication subsystems.  

February 24, 2011 11:00 AM
 

Jorg Klein said:

In my last blog post I explained the principles of Replication Services and the possibilities it offers

March 12, 2011 5:42 AM

Leave a Comment

(required) 
(required) 
Submit

About jorg

Jorg Klein, Microsoft Data Platform MVP from the Netherlands.
Privacy Statement