July 25, 2014 at 12:45 am
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.
July 25, 2014 at 3:48 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply