Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Performance for SQL Jobs Expand / Collapse
Author
Message
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


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 19, 2014 2:00 AM
Points: 56, Visits: 352
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.

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
Post #1596139
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse