|
How long should I let this query run.. It has over 800,000 rows.. and I see the following task state = suspended command= alter table wait type = pageiolatch_sh.. Thank in advance! I'm wondering if I should just let let run, or if something is wrong.
(comments are locked)
|
The question has been closed Oct 15 '12 at 07:54 PM by ThomasRushton for the following reason:
Duplicate Question
|
The pageiolatch_sh is the server waiting for I believe a latch on a page in the buffer pool. Updating 800K rows with a new column very well could take some time depending on your disk IO subsystem and how your table is structured. If time is a concern, you could think about creating a new table with the new column and then import the data into the new structure, drop the old structure and then rename the new table to the old name. I would highly recommend that you test this first to see if it would be a faster alternative. Or you could just let it wait it out. Hope this helps!
(comments are locked)
|
did you let it run or kill it? how long did it take?
@aimyee this is a continuation/repetition of your earlier question http://ask.sqlservercentral.com/questions/94323/adding-column-taking-over-hour.html
Please don't duplicate questions. If you are still having issues after the answers on the original question, please post there and engage with those who have already started to help you.