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 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.