UPDATE [dbo].[EmployeeTable] SET [Name] = @0, [JoiningDate] = @1 WHERE ([EmpId]=@2);
typically not take two seconds. Even on a somewhat big table, updating a single row would not take less than two seconds. Do you own a list of
? If not, it would account for the two seconds and the possibility of a stalemate.
If you do have an index, maybe there is another issue. Look for any triggers on the table as a starting point.