August 21, 2009 at 3:42 am
Hi experts my scheduled job running slow compared earlier which is used to run 1hor 30 min ,now is running 8hrs
pls give any solution to increase.
August 21, 2009 at 7:45 am
Your question is too vague. But do consider to check indexes fragmentation on the tables this job is using and fix it with dbcc dbreindex ('table_name','', %(you want to put)) with full scan.
SQL DBA.
August 21, 2009 at 9:01 am
We need lots more info....yes the index could be causing this. But to go from 30 min to 8 hrs you most likely have something else going on...
1. are you on a SAN, if so you can get away with a lot of bad index depending on who powerful your SAN is
2. Are you calling creating any TEMP tables.... I recently had a problem where this happened and I just needed to tune the server......IE add a drive for temp DB create a file for each CPU and so on....this tool the SP from 4 hours to 30 min...
3. you can also track down you wait staticis....this mave give you a start
4. or try running you PROFiler you could have a blocking going on
5. all in all it could be a lot if things!!
6. WE need more info to help
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply