For the best web experience, please use IE11+, Chrome, Firefox, or Safari

How to Monitor SQL Server Analysis Services (SSAS)

How to Monitor SQL Server Analysis Services (SSAS) 05:42
SQL Server Analysis Services (SSAS) is an online analytical processing and data mining tool that many organizations use for business intelligence. You can create a monitoring agent for SSAS within Foglight. Note that a SQL PI Repository server is required. This video demonstrates how to create the monitoring agent.

Related videos

How TransUnion uses Foglight to monitor their databases
How TransUnion uses Foglight to monitor their databases

Anthony Stephens of TransUnion explains how they use Foglight and Foglight Performance Investigator to diagnose and resolve database performance issues.

TransUnion improves database performance monitoring with Foglight
TransUnion improves database performance monitoring with Foglight

TransUnion shares how Foglight helps to maintain high levels of uptime and performance for their applications that manage 1 billion consumer files.

Monitor all your databases from a single, intuitive console
Monitor all your databases from a single, intuitive console

Proactively ensure peak performance across all your databases.

The angular user interface in Foglight 6.1
The angular user interface in Foglight 6.1

The angular user interface in Foglight 6.1

Defining Database Agent Alarm Sensitivity
Defining Database Agent Alarm Sensitivity

This quick video shows how to select and modify the sensitivity levels assigned to each agent. The sensitivity level controls which alarms are reported. For each agent, you can choose from Essential, Normal, Tuning or Performance for the sensitivity level. Normal is the default.

Introduction to Rules and Alarms
Introduction to Rules and Alarms

Foglight tracks system metrics and constantly evaluates those metrics against rules. If conditions are matched, an alarm is fired. This video gives an overview of the three types of rules and how alarms are displayed according to severity level. It also discusses how alarms are acknowledged and cleared by system operators.

Defining Database Agent Alarm Settings
Defining Database Agent Alarm Settings

Foglight gives you the ability to customize alarm settings for your environment. This video shows how to configure and modify alarms for selected agents and rules. Categories help group related alarms, and you can edit multiple alarms at once. In addition to the default settings, Foglight allows you to set thresholds for severity levels that make sense within your environment.

Viewing the Health of Your Instances
Viewing the Health of Your Instances

This video shows several different ways Foglight helps monitor database health. Pre-built alarms show the severity of issues across the entire environment and allow you to get more information on the host or instance. Performance baselines show how the instance is operating compared to normal status for that time/day. An instance overview shows more details, including which query might be slowing performance. Finally, Foglight offers advisories that include recommendations, additional reading and next steps for issue resolution.

What success factors do most companies overlook during cloud migrations?
What success factors do most companies overlook during cloud migrations?

As companies rush to embrace the cloud, they typically overlook two very important success factors. See what these success factors are in this video showcasing how Quest can help you not only see your entire IT environment, but also save you from common mistakes made by moving to the cloud too hastily.

How to setup email server settings in Foglight
How to setup email server settings in Foglight

Learn how to setup email server settings in Foglight, the solution from Quest that helps monitor, manage and resolve performance issues across your infrastructure.