When SQL Server is running it open and exclusively locks all files that are used to store the database. If you want want to see which tables are being affected by the update, try enabling STATISTICS I/O. It should list the tables that SQL Server is generating I/O on.