SAP Knowledge Base Article - Preview

2294651 - DBA Cockpit: Auto update stats async red alert

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.