title: Performance of update operation on SQL Server
body: <p>I have to mention that I have two different SQL Server instances on two different servers.</p>
  <ol>
  <li><p>Process; Server A is applying 300 - 400 insert command to the local database. About 1 second.</p>
  </li>
  <li><p>Process; A 300 - 400 update command is sent from server A to server B over IIS. This update process is done on the indexed primary key and takes an average of 4 seconds.</p>
  </li>
  </ol>
  <p>In the second transaction, I closed the transaction on IIS, I used the same transaction with the database link feature, but the result is still the same.
  There is a trigger in the updated table on server B.
  Server B has the update command for each line, so there is a command starting with 300-400 update.</p>
  <p>My problems:</p>
  <p>Why is the process taking a long time in transaction 2?
  In the second process, what kind of points I need to pay attention to in the update query.</p>