mallikachowdhary 98955 (7/24/2014)
Hi ,I have a issue regarding a query showing very late response on one server while it works perfectly on another.
I have a job defined in SQL server 2008 which runs a stored procedure of select query which fetches around 230000 rows . One one server this job runs in 6 hr but on another server this jobs takes around 1 day and 15Hr+.
Can anyone help me out in debugging this issue.
Thanks in advance.
Quick thought, even the "faster" server is only returning around 650 records a minute, for a non-transactional activity (select) it is very slow, which indicates that it is hitting bottlenecks in one form or another. I suggest looking into this first as it doesn't take much of a change in the environment to make it 6-7 times slower i.e. IO, memory pressure etc.. I have come across similar situations quite few times where the main difference was the actual hardware.
😎
Regarding the execution plans, I guess you are better off using estimated plans;-)