Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

SQL Analysis - Aggregation Information Alarm

The SQL Analysis - Aggregation Information alarm is raised to indicate that some SQL statements have been discarded during the collection of SQL Analysis data.

The process of collecting SQL Analysis data limits the size of the aggregation of SQL statements returned from the monitored SQL Server instance to protect against high memory consumption by the Spotlight Diagnostic Server. When an event is collected from the SQL Server instance that causes the aggregation to grow beyond this limit, this alarm is raised.

To allow Spotlight to collect more SQL Analysis data without discarding SQL statements (and raising this alarm), consider increasing the value of the Aggregate the top n SQL statements option on the Advanced tab of the SQL Analysis Options dialog. Increasing this value is likely to increase Spotlight Diagnostic Server memory usage so adjusting this value to more than the default of 200 is not recommended. For more information, see Configure | SQL Analysis.

You can also reduce the number of SQL Server events being aggregated by increasing the collection filter settings.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating