SQL Server Performance

What is the syncobj_xxx generated in views?

Discussion in 'Performance Tuning for SQL Server Replication' started by lshores, May 27, 2003.

  1. lshores New Member

    I am a novice at setting up replication, and tried to do so for the first time last week. After I set up Snapshot replication and then synchronization on the SQL Server 2000 db, there were many new views generated with the prefix of syncobj_. Can anyone offer an explanation to what these objects are and why they are created? Will they disappear after the first Snapshot is run? If anyone can be of any help, I would greatly appreciate it.

    Thank you.
  2. satya Moderator

    I believe those are auto-generated by system during snapshot replication, which is also controlled automatically and will not cause any issues in performance.

    Satya SKJ
  3. vbkenya New Member

    quote:Originally posted by lshores

    ....Will they disappear after the first Snapshot is run? .

    No they normally don't just disappear (at least on most servers I've seen). In fact you might have to deal with them later when you remove replication from your boxes - They sometimes don't get removed together with everything else. They are SCHEMABOUND views and may not allow you to issue DDL statements on the underlying tables. So you might have to manually remove them later.

    ..But that's later. For now , just replicate.


Share This Page