none
Database updates statistics maintenance plan issue.

    Question


  • Hi team,

    We are configured one job through maintenance plan that job name is “database update statistics” and database size is 280 Gb, this job executing 13 to 15 hours but job was not finished  still it’s continually running.

    This same job I am running through below script it’s executing within 2 hours.

    Use database

    Go

    Exec sp_updatestats

    What is the main problem if this maintenance plan.

    Note: on this server no jobs and no traffic, only abc_update subpaln1 Job.

    Monday, January 06, 2014 8:29 AM

Answers

All replies