Update statistics

[SAPSupport]

Hello SAP,
We are running SAP NW 7.5 on MS Server DIGITS DB: MS SQL Server DIGITS.

We would like to execute update stats on entire database and would like a recommendation as to how this 'update' on stats should be done.

Thanks!

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Hi

1. usually, it does not need to update table statistics manually, since SQL Server 2019 will do it automatically.
2. if you still needs to update the table statistics manually then refer to the following:

Open a new query window and execute the following commands:

use <SID> – where <SID> is your SAP database

go

EXEC sp_updatestats

go

It takes some time to replace the old SQL Server index statistics with new SQL Server 2019 statistics. You can execute this while the SAP system is online.

Upgrading SQL Server to SQL Server 2019 for an Existing Non-High-Availability SAP System
Use

https://help.sap.com/docs/help/4872fb4190244a9bafccfd80fcd6e13b/d10323571c1aed74e10000000a4450e5.htm...