If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: SP_UPDATESTATS

Hi
We have a MS-SQL dB that is more than 300 gb and have some performance problems.
One of the problems is, that the system do not automatically update statistics.
In the test system, which is a copy of production we have run sp_updatestats and all the tables and index is updated but when we run sp_updatestats in production, it return normally after one hour but it do not update all tables and index ??
Regards
John

Are you running this at a time frame that sql server is the least utilized (like between midnight and 4 a.m. - depending on your business model) ? Also, what is the output generated when you run sp_updatestats ? How do you know that it is not updating the statistics for all tables ?

Hi
The sp_updatestats was running Saturday, while the system performance is low.
The output was “statistics for all tables have been updated”

The application (SAP), have some dB information reports and it is possible to get information on tables and index. In the test system SAP reports, that the statistics is updated but not in the production.

When I make the following sql in the production and in the test system: