Monday, March 26, 2012

How much does Replication use tempdb database?

Does Replication create temporary objects in tempdb that take up much space
other than monitoring log info?
Could such replication objects cause high IO on drive where tempdb resides?
A developer was telling me that tempdb is being used by replication to do
this and I am asking as a sanity check, since I couldn't find much mention of
it in MS documentation.
Thanks,
-Phil
It is used for monitoring, by the merge replication synchronization
process, and during snapshot generation and distribution.
If you are applying indexes on the subscriber (as part of the
replication process), it will also make use of tempdb at that time.
On Jan 15, 4:32 pm, Phil_0413 <Phil0...@.discussions.microsoft.com>
wrote:
> Does Replication create temporary objects in tempdb that take up much space
> other than monitoring log info?
> Could such replication objects cause high IO on drive where tempdb resides?
> A developer was telling me that tempdb is being used by replication to do
> this and I am asking as a sanity check, since I couldn't find much mention of
> it in MS documentation.
> Thanks,
> --
> -Phil

No comments:

Post a Comment