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.
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.
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.
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.
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.
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.