title: What index will be good for performance while inserting rows/updating rows in table?
body: <p>A table has an Primary Key Clustered index.
  Deadlocks occurs frequently on the above table resulting loss of data.
  While inserting rows or updating row what index will be good to add which has better performance?</p>
  
  <p></p>
  
  <p>Table :
  ID Int Identity,
  EntityID Int,
  EntityName nvarchar(200),
  MeasuringID Int,
  Cratedon datetime</p>
  
  <p>Primary Key Clustered : ID</p>
  
  <p>Records gets inserted very frequantly everytime into the table.</p>
  
  <p>** Any isolation levels or locks to be placed in the Stored Procs of Insert and update?</p>