Hi all, I'm facing a problem of PAGEIOLATCH_SH while running a SP. The SP runs daily to update records in a table. Let says, I have two tables: APPLICATION, CUSTOMER. The SP reads from the two tables to find out some 'Outdated' applications, as well we the customer ID. The it stored the data into a temp table TEMP_APP. Then it reads from TEMP_APP, a cursor is used to store the data and CUSTOMER table is updated while looping the cursor. We must update the CUSTOMER record one-by-one since each record is updated with different values. The SP reads and updates around 10000 records. From PERMON, I could see % Processor Time hits nearly 100% as the Processor Queue Length increase. However, I can't see any CPU bottleneck as it is already a PIII 733 CPU and the number of records affected is so small. Other stat such as Disk Qeueue Length/ Read Writes and Buffer Cache Hit Ratio are normal. Can anyone help me? Thanks!