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 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.
Learn how to setup email server settings in Foglight, the solution from Quest that helps monitor, manage and resolve performance issues across your infrastructure.