Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

SQL Server Analysis Services

 

Spotlight displays for the Analysis Services connection type

Select Analysis Services from Monitored connections to show performance statistics for connections of type SQL Server Analysis Services.

Icon Help Reference Description
Heat map A display of monitored Analysis Services connections focusing on those connections with the comparatively larger number and severity of alarms.
Spotlight today A display of Analysis Services alarms raised, alarms are organized according to priority.
Alarms by time A display of Analysis Services alarms raised, alarms are shown according to their duration and severity.
Alarm log A display of Analysis Services alarms raised, alarms are sorted in a tabular format.

 

Spotlight displays for a single Analysis Services connection

Expand the Analysis Services connection type from Monitored connections to list connections by name.

Click on the connection name to show the Analysis Services | Home Page for the connection.

Icon Help Reference Description
Analysis Services | Home Page The Spotlight home page highlights obvious bottlenecks and problem areas. Statistics and flows are updated in real time.
Analysis Services | Activity Drilldown Drilldown on resource usage and activity information for open connections and sessions, and for commands currently executing or last executed on the Analysis Services server.
Analysis Services | Memory Drilldown Drilldown on memory usage for the Analysis Services server.
Analysis Services | Storage Drilldown Drilldown on the databases and cubes of data defined on the Analysis Services server.
Analysis Services | Configuration Drilldown Drilldown on the configuration options that control the Analysis Services server.

 

Configure

Icon Description

Add and delete monitored connections. Change connection properties.

Configure the thresholds and severities that determine when alarms are raised.

Setup actions for Spotlight to take when an alarm is raised. The actions Spotlight can take include running a program and sending an email. Conditions on taking the action can be defined, such as the day of the week, the time of day, the severity of the alarm, the alarm type and the connection type.

Schedule data collections.

Enter the scheduled maintenance times for monitored connections. Spotlight will treat monitored connections as unavailable at the scheduled times, so will not raise alarms or collect data during the outage period.

Configure the filters used to gather SQL Analysis data.

Define the SQL statement that is used to measure response time.


For monitoring connections to SQL Server and Windows servers, create and configure Custom Counters.


Define the SQL error log entries for Spotlight to alarm on.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating