Hi,
I have 15 or 16 jobs reterive the information from the database for previous day for daily report. All the jobs were running fine, for some reason since thursday night, all the daily reports instead of taking 30 seconds to 5 mintues, it taking 12 to 15 hours to accomplished the job.
we restarted SQL server agent but didn't help. can anyone please guide what we need to look into to further diagnosis the issue. ?
With Regards
We are using SQL 2005 , SSIS packages.