none
Will running sp_UpdateStats improve performance RRS feed

  • Question

  • Our DBA suggested that we run sp_updatestats on the SQL server that is part of a environment with about 1000 projects on it.  The cube building performance has declined drastically and it is thought that the queries during build time are running slow.

    Is there a downside to this... is it worth a try?

    Wednesday, December 22, 2010 8:42 PM

Answers

  • Yes. Its worth.

    sp_updatestats effectively executes UPDATE STATISTICS, by specifying the ALL keyword, against all user-defined and internal tables in the database. sp_updatestats displays messages that indicate its progress. When the update is completed, it reports that statistics have been updated for all tables. Statistics on disabled nonclustered indexes are also updated by sp_updatestats. sp_updatestats ignores tables with a disabled clustered index.

    http://technet.microsoft.com/en-us/library/cc966419.aspx

    "Reorganize data and index pages"

    "Update statistics used by query optimizer"


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Saturday, December 25, 2010 2:21 AM
    Moderator

All replies

  • Yes. Its worth.

    sp_updatestats effectively executes UPDATE STATISTICS, by specifying the ALL keyword, against all user-defined and internal tables in the database. sp_updatestats displays messages that indicate its progress. When the update is completed, it reports that statistics have been updated for all tables. Statistics on disabled nonclustered indexes are also updated by sp_updatestats. sp_updatestats ignores tables with a disabled clustered index.

    http://technet.microsoft.com/en-us/library/cc966419.aspx

    "Reorganize data and index pages"

    "Update statistics used by query optimizer"


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Saturday, December 25, 2010 2:21 AM
    Moderator
  • Thanks for the answer!
    Tuesday, January 11, 2011 6:07 PM