• In all our PRD servers.

    Once the Full Backup finishes, I call the Check DB Integrity job from the Full Backup job.

    Then the Check DB Integrity job runs and when it finishes it calls the User DB Reindex job.

    The User DB Reindex job will call the Update Statistics job.

    So I have one job calling the next job.

    Now I have issue with Update Statistics is taking to long to complete

    as mentioned in my 1st post.

    @gilamonster: How do I troubleshoot hitting IO bottlenecks?

    and is there any other way to troubleshoot Update Statistics.

    What does the update Statistics job do internally?

    @MindOptimizer: thanks for your replay. But i am doing that by spliting the job and run it parallel.

    I want how to know trouble shoot do decrease the time.

    Thanks for your replays