June 4, 2011 at 12:11 pm
Hi Experts,
We have a ETL job having multiple step and the last step is not INSERT data. For the past few days the job is not completing the 8th step it will keep on running and when i checked the job percent_complete its showing 0%. The wait type is showing as PAGEIOLATCH_EX. Please help me in resolving this issue.
What are all the things i need to check the job status is showing as SUSPENDED and i think its because of internal I\O operations
TIA
June 4, 2011 at 12:19 pm
Few things to check:
i) run sp_who2 every 10 secs when the last step occurs and capture the data to see if any blocking
ii)are your indexes and statistics upto date?
iii)if you take the same query and run in your test environment does it take the same time?
I am sure other DBA's here can provide your with more tips 🙂
June 4, 2011 at 12:52 pm
sqldba_icon (6/4/2011)
Few things to check:i) run sp_who2 every 10 secs when the last step occurs and capture the data to see if any blocking
ii)are your indexes and statistics upto date?
iii)if you take the same query and run in your test environment does it take the same time?
I am sure other DBA's here can provide your with more tips 🙂
1.No blocking exists but can see exclusive lock on tables.
2. Not able to check the fragmentation as the process will get blocked by the job.
3. Since have only limited access and no test environment its not possible to do the same . The query is inserting around 2 million records.
June 4, 2011 at 2:01 pm
The waitresource in sysprocesses is shown as 5:1:5040288.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply