April 13, 2010 at 2:45 pm
Is there any strict relation between Distribution DB size vs how it performance. We are using a third party tool to read changes out of Distribution database (as we are still using sql 2005). Issue here is, to support this CDC process we need retain data on distribution database for a couple of days to make sure we do not lose any data for downstream processing. Distribution clean-up agent currently runs every couple of hours. We need to make it run every couple of days.
My understanding is, if we size distribution database correctly, provide enough hard disk space, it should not hinder performance.
Please provide guidelines on distribution clean-up agent run frequency.
April 13, 2010 at 5:38 pm
For the tempdb questions, I recommend you check out Kimberly Tripps blog. You can find a link to her blog in my signature. Browse her articles on tempdb.
As for the distribution database, right size and cleanup will depend on expected usage.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 2:30 pm
I actually messed up the question. I wanted know, whether there will be any negative impact if Distribution DB size is large.
In my environment we have Transaction replication set-up to replicate data to 4 subscribers from a single publisher. CDC Process reads changes out of Distribution database.
Distribution DB size can grow to around 20 gigs in couple of days if we do run distribution cleanup agent every 2 days instead of every couple of hours (as we are doing now). Our fear is, we might see latency issues if size grows larger than 3/4 gigs. Is size of distribution DB a concern when it comes to replication Latency ?
April 14, 2010 at 2:46 pm
Yes, size will have an impact on performance - slightly. The larger the database and tables, the more data that may need to be maintained. You should keep the database maintained (indexes, cleanup, etc).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply