SAP Note 75158 - Retaining deadlock statistics longer than 7 days

Composant : Microsoft SQL Server -

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

Mots Clés :
transaction st04 -> 'detailed analysis menu' -> deadlock -> 'single statistics ', transaction st04 -> 'detailed analysis menu' -> deadlock -> 'count statistics', update msscntdead set counter = <retention period>, background job sap_collector_for_perfmonitor - report rscoll00, deadlock entries'<retention period>, symptom detailed statistics, display detailed information, individual deadlock statistics, desired retention period, sap kernel writes

Notes associées :

111291FAQ: SQL server analysis and avoiding deadlocks