November 3, 2012 at 6:59 am
HI,
I am running a script in test environment and using sql 2008. the script will do inserts and update some 1 million rows.
It has been running for last 12 hours. when i checked in activity monitor, spid shows as suspended and waittype shows 'pageIOlatchwait_EX' , and very next second waittype shows as 'waitfor'
Does that mean it will resume or has it stopped?
how to check, where the waits happening...
November 3, 2012 at 10:02 am
nihal9200_kwada (11/3/2012)
HI,I am running a script in test environment and using sql 2008. the script will do inserts and update some 1 million rows.
It has been running for last 12 hours. when i checked in activity monitor, spid shows as suspended and waittype shows 'pageIOlatchwait_EX' , and very next second waittype shows as 'waitfor'
Does that mean it will resume or has it stopped?
how to check, where the waits happening...
Updating a million rows should take scant seconds. Post the update query... I may know what's wrong.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 4, 2012 at 10:01 pm
Yes, Inserting a few million records just takes a few seconds.....I have a feeling you are getting data from one table....performing RBAR operations on the data and then Inserting the data into another table........That's just a hitch....Need to see your script to be sure. Please post the script you are using.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply