Symptom
Upon checking the SQL Server Setup Check for red alerts, you notice a red alert for "Auto update stats async is not on for db <SID> (OK for BW)", but your system is a BW system.
Read more...
Environment
- SAP NetWeaver 7.3 (BW)
- MS SQL Server 2005 and higher;
- SAP_BASIS 730 SP12.
Product
SAP NetWeaver 7.3
Keywords
statistics, stats, updatestats, updstats, mssql, msql, ms_sql, mss, monitoring, SSSC, AUTO_UPDATE_STATISTICS_ASYNC, ALTER DATABASE, , KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft SQL Server , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.