Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Location Expand / Collapse
Author
Message
Posted Tuesday, March 30, 2010 8:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 03, 2014 3:20 PM
Points: 7, Visits: 30
Location, Location, Location.

I find key is to ensure the Distribution database is located on its own physical disk or LUN (for SAN). This ensures the IO needs of the LogReader Writer Thread or the Distribution Agent Reader Thread are not waiting behind IO needs of other queries for user databases.

To learn more about LogReader Reader/Writer threads see my posting on ReplTalk.

http://blogs.msdn.com/repltalk/archive/2010/02/21/transactional-replication-conversations.aspx

--Chris Skorlinski
--Microsoft SQL Server Replication Escalation Services



Post #892781
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse