AI-Powered Anomaly Detection
The AI-driven anomaly detection module in Experda App’s performance monitoring uses Machine Learning, specifically the isolation forest algorithm, to proactively identify database performance issues. This system continuously learns the normal behavior patterns of your database, monitoring key metrics like CPU utilization, Page Life Expectancy (PLE), disk performance, and query execution. By adapting to your unique workload and seasonal trends, the AI instantly spots significant deviations (anomalies) such as CPU spikes, memory pressure, or extreme query durations, providing immediate alerts and actionable insights. This approach minimizes false alarms, allowing your team to focus on strategic work rather than reacting to problems or chasing false positives.
Experda provides real-time monitoring by continuously collecting and analysing data from your SQL servers. The system automatically refreshes the data at regular intervals, but you can also manually refresh the data or pause the automatic refresh if needed.
In the Global settings section, you can override the sampling times for each sample type. This includes DMV queries or WMI operating system information. You can do this globally or for a selected managed server.
Experda supports a wide range of alerts, including CPU usage, memory consumption, disk activity, blocks, deadlocks and security breaches. These alerts can be configured using predefined templates or customised to meet specific requirements. Alerts can be categorized by severity, such as informational, warning, or critical. Alerts can automatically be sent to users or user groups by email or SMS. For advanced users alerts can be defined to be automatically dismissed or use enhanced configurations.
To set up an alert template, navigate to the alert configuration module and select a predefined template or create a new one. Customize the alert thresholds, severity levels, and notification settings as needed. Once the template is configured, you can affiliate it with multiple servers to apply the same alert settings across your environment.
See videos “Custom alerts”, “How to configure an alert”
Yes, Experda allows you to configure alerts to be sent via email or SMS. You can set up contact groups and associate them with specific alert templates to ensure the right people are notified when an alert is triggered.
See video “How to configure an alert”
With Experda, database teams trade manual work with automations and replace clunky operations with streamlined workflows.
With Experda, database teams trade manual work with automations and replace clunky operations with streamlined workflows.
This website uses cookies to remember you and improve your experience. To find out more see our Privacy Policy.
