Solution : https://service.sap.com/sap/support/notes/1171828 (SAP Service marketplace login required)
Summary :
This SAP Note addresses an issue where counters such as 'Data Cache' and 'Proc Cache' show as 0 in the DBACOCKPIT transaction's "Performance"-"Overview" screen for SQL Server due to a PRIMARY KEY constraint violation (SQL error 2627). This occurs because the sys.dm_os_performance_counters view produces multiple result rows on NUMA systems with multiple nodes where only one is expected. The issue affects SQL Server 2005 and 2008 on SAP_BASIS 701 SP0 systems. Resolution involves applying a provided correction script, updating SQL data via SQL Server Management Studio, and activating changes through DBACOCKPIT.
Key words :
setuser <sid> update msssource set srcline = ' ''sqlserver, primary key constraint 'pk__#perfinfo, start sql server management studio, monitor multiple sql server databases, counter 'page life expectancy', attached snote correction instruction, dm_os_performance_counters returns multiple rows, sql server view sys, sql server databases, terms sql server
Related Notes :
| 1260586 | Runtime error in SQL Server Performance History |