SAP Note 1178916 - Update_Tabstats job causes system performance problems

Composant : CCMS/Database Monitors for SQL Server - Microsoft SQL ServerBC-DB-ORA OracleHAN-DB SAP HANA Database

Solution : https://service.sap.com/sap/support/notes/1178916 (Connexion à SAP Service Marketplace requise)

Mots Clés :
symptom job sap ccms_<sid>_<sid>_update_tabstats runs, job executes stored procedure sap_update_tabstats, locate mssprocs item named sap_tabstats, stored procedure execute   dbcc updateusagefor, set @cmd = n'dbcc updateusage, choose edit->execute script, no_infomsgs'      exec sp_executesql @cmd, completely avoid dbcc updateusage, start running dbcc updateusage, sap basis version 7

Notes associées :

1027512MSSQL: DBA cockpit for basis release 7.00 and later