Post Undeleted by Gulli Meel
    Post Deleted by Gulli Meel
2 added 253 characters in body
source | link

Check theand compare execution plan when the query run during office hours and after office hours.

If plans are not same then a different plan might be causing issue .If the plans are same then it could be network issue or it might be possible that server has too much load during office hours due to high workload and thus waits are more..

Check the execution plan when the query run during office hours and after office hours.

Check and compare execution plan when the query run during office hours and after office hours.

If plans are not same then a different plan might be causing issue .If the plans are same then it could be network issue or it might be possible that server has too much load during office hours due to high workload and thus waits are more..

1
source | link

Check the execution plan when the query run during office hours and after office hours.