SQL Server Performance

Create index operation on a table in replication

Discussion in 'General DBA Questions' started by satya.sqldba, Mar 24, 2010.

  1. satya.sqldba New Member

    A table called 'Customer' is a part of publication and is being replicated via transactional replication to another server.
    If I have to create an index on the table 'Customer', I know it makes the table unavailable for any queries, but my question is will it prevent the replication from functioning properly because of the lock placed by the create index statement?
    The index will take about 45 minutes to complete.
  2. satya.sqldba New Member

    From the research I have done, the log reader agent reads only the transaction log and not the actual table. So we should be good in doing a create index statement, someone can chime in if they have any other ideas.
  3. shashank sharma New Member

    Can someone eloborate this? i am getting little confused.. :(

Share This Page