0

While trying to update a table definition (change a field type from NVARCHAR(5) to NVARCHAR(8)) we caused a lock on the database. There were a large number of rows (>11,000,000) so we decided to kill the process and roll back the update.

During the rollback the status of the process was showing as 'sleeping' with a Wait Type of IO_COMPLETION or PAGEIOLATCH_EX.

How can I give the KILL/ROLLBACK process a higher priority and prevent it going to sleep?

Swinders
  • 219
  • 6
  • 10

1 Answers1

2

ROFL, wouldn't it be great if assigning a greater priority to a process will make your hardware faster? Both of your wait types are due to IO subsystem not keeping up. You'll just going to have to wait it out.

Remus Rusanu
  • 8,253
  • 1
  • 19
  • 22
  • OK, thought it was probably going to be something like that. I think we had something else going on with the server at the time which was causing it to slow down generally. Sorry for the silly question and thanks for explaining the wait types were due to hardware. – Swinders Jan 26 '11 at 09:00