8 indexes including the primary key. The data space is 17.5G, and the index space is 7G.

There are no foreign keys.

Some additional information:

It stalled out while there was no other activity against that database. The activity monitor shows only sleeping sessions from my open SSMS. Nothing else was running against that particular database.

The wait type is listed as PAGEIOLATCH_EX and PAGEIOLATCH_SH. The wait begins immediately when I start running it.

It slows down the entire server as soon as I start running it. Things like the Activity Monitor and Job Activity Monitor take noticeably longer to refresh. Users get timeouts inside our ERP system.

It appears that the statement "DELETE FROM fact.WorkOrder WHERE WOStatus NOT IN ('C', 'X')" is completing immediately, but the statement "DELETE FROM fact.WorkOrder WHERE CreateDate >= @startdate" took 8 minutes to complete.