SQL Server Performance Forum – Threads Archive
Daily jobs taking unusually long timeHi all, Our SQL server from yesterday is taking a lot of time to run daily jobs. I am running the profiler and the performance monitor , its not showing any unusual trends but still the jobs are taking a very very long time, any ideas??
Hi,<br />is your sql server is dedicated one or running IIS also ! what SP version you have applied, is it latest one !<br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br /><br /><br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
What kind of jobs you are running?
True and check those job history log for any clue on this slow performance. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.