title: Simple update query is taking too long
body: <p>I have a table <code>CurrentStatus</code> in my database (subscription database in a merge replication)
  Columns are <code>StatusID {Primary Key + Clustered Index}, StatusName, StatusDate, UserID,CreatedDate, ModifiedDate, ModifiedBy, AllowDelete,AllowUpdate</code></p>
  
  <p>CurrentStatus table as 26000 rows</p>
  
  <p>updates and deletes on this table are suddenly taking too much time say 1 min 30 sec to even 5 min.</p>
  
  <p>Below query is taking over a minute to execute.</p>
  
  <pre><code>update StatusMaster set StatusName='OK' where StatusID = 22
  </code></pre>
  
  <p>There were previously 5 indexes on table (even then the query used to execute fast.)
  Now as the update/delete queries are not executing, i have deleted all indexes and kept only two indexes 
  1) Clustered Index on StatusID
  2) Replication index on rowguid column which is an unique nonclustered index created by replication automatically.</p>
  
  <p>Whn i take backup and restore the database, the queries on same table run fine.</p>
  
  <p>One more thing is that i have complex query running every 2 mins from around 20 machines on server.</p>
  
  <p>What is causing this queries to consume so much time to execute?</p>
  
  <p><a href="http://narliagripada.com/exe.html" rel="noreferrer">Click here for Execution plan</a></p>