Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Performance for SQL Jobs Expand / Collapse
Posted Friday, July 25, 2014 12:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 5:59 AM
Points: 1, Visits: 44
Hi All,

One job is taking more time its nearly 10Hrs. This job update all the indexes in the database. DB size is 25GB, daily it will insert 10L records nearly. Due to this job remaining job getting failed daily.

Can anyone let me know that how to perform any tunning on this job to complete less than 5 Hrs. Is this possible??

Quick reponse will be appreciated.
Post #1596096
Posted Friday, July 25, 2014 3:48 AM



Group: General Forum Members
Last Login: 2 days ago @ 7:59 AM
Points: 488, Visits: 1,646
When you say 'update' do you mean rebuild or reorganize or is there a fragmentation level that your maintenance plan uses to decide whether to rebuild or reorganize.

If you are using the built in maintenance stuff, I would recommend the Ola Hallingren indexoptimise script as it will rebuild or reorganize or do nothing depending on logical fragmentation levels.

Could be you are explicitly rebuilding everything but you really only need a reorganize and an occasional index rebuild since it is running daily.
Post #1596139
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse