Does DBAs use 'Update Statistics' maintenance plan task?

Question

Does DBAs use 'Update Statistics' maintenance plan task?

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

Jpotucek (12/29/2009)
When migrating databases from SQL Server 2000 to 2005 using backup and restore, How do I verify that auto update statistics is turned on AND it is necessary to update statistics once the restore to 2005 is complete?? Wondering what the best practices for this are???

Please start new thread.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

klnsuddu SSCertifiable Points: 5836 More actions · Answer 2

How can u said no need ?
Always "it depends"

After reading this blog, I have deleted my Update Statistics maintenance job. Because, in my case, Update statistics is running after the index rebuild maintenance task job completion.

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Database-Maintenance-Best-Practices-Part-I-e28093-clarifying-ambiguous-recommendations-for-Sharepoint.aspx

please advice me on how to know what tables, indexes, statistics are get used more sothat I can rebuild & Updatestats for only those get used more frequently.

thank you very much

Steve Jones - SSC Editor SSC Guru Points: 737034 More actions · Answer 3

You would have to track updates or data changes across tables to know which ones are used the most. You could add triggers to track this, or run a trace and analyze it over time.

klnsuddu SSCertifiable Points: 5836 More actions · Answer 4

thanks Steve,

If the Index rebuild maintenance plan run on weekly basis, then does it required to run Update statistics maintenance job or NOT?

josantia Ten Centuries Points: 1255 More actions · Answer 5

Hi,

Ideally, you should rebuild the indexes only when their fragmentation is above 30%, if you are rebuilding all indexes, then you only need to update the column statistics:

http://sqlblog.com/blogs/ben_nevarez/archive/2009/10/06/rebuilding-indexes-vs-updating-statistics.aspx

Regards,

Jose Santiago Oyervides.

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 6

klnsuddu (12/29/2009)
How can u said no need ?
Always "it depends"
After reading this blog, I have deleted my Update Statistics maintenance job. Because, in my case, Update statistics is running after the index rebuild maintenance task job completion.
http://www.sqlskills.com/BLOGS/KIMBERLY/post/Database-Maintenance-Best-Practices-Part-I-e28093-clarifying-ambiguous-recommendations-for-Sharepoint.aspx
please advice me on how to know what tables, indexes, statistics are get used more sothat I can rebuild & Updatestats for only those get used more frequently.
thank you very much

Hi,

After rebuild no need to update the statistics its automatically updated.

See the my previous replays(1'st page).

Also I'd suggested read the 1'st link added in signature.

Edit:For added more info

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

EdVassie SSC Guru Points: 60490 More actions · Answer 7

These short videos from Andy Warren give good advice about updating statistics:

http://www.sqlshare.com/updating-statistics-part-1_695.aspx

http://www.sqlshare.com/updating-statistics-part-2_696.aspx

http://www.sqlshare.com/updating-statistics-part-3_697.aspx

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara