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 ??
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 ?
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:
select * from sysobjects so, sysindexes si where so.name = 'KNA1' and si.name like 'KNA1% Z'
I can see, that the number in the rows column is zero. I expect that the number is different from zero.