Dear all,
One of my process is running very slow. It was working very fine few hours before.
This process actually updating nearly 3500-4000 records from a table having count(records) 722135.
when it gets executed it goes in hung state. & after that shows error message- 'Time out Expired'
I check progress of this process using sp_who2, then it shows that DiskIO column for this process not changing frequently. It shows value 0 most of the time, but CPUTime changing/updating frequently.
I think because of this it shows error message 'Time out Expired'.
Can anyone suggest me that how can tackle this issue..
Regards
Majid Jafar