Viewing 4 posts - 1 through 4 (of 4 total)
Hi Thanks for your reply.
The problem is because of many indexes on the table i feel (they are )the insert/update/delete(there's a lot of insert and update on this table daily...
February 15, 2011 at 2:45 pm
Can i use SP_updatestats 'resample' instead of the update stats maintainence task .
February 7, 2011 at 12:37 pm
what about the statistics? i have another Import job that kicks off at the same time when the Update statistics step starts . Is there a possibility that Update statistics...
February 7, 2011 at 9:02 am
hi thanks for you reply actually there has been a huge amounts of I/o waits ,long running queries and also query timeout ....so i guess was may be an increase...
November 9, 2010 at 7:06 pm
Viewing 4 posts - 1 through 4 (of 4 total)