Anomalies
AI-Powered Anomaly Detection AI-Powered Anomaly Detection Overview Deep Dive with AI Explanations Anomaly Settings and Fine-Tuning https://youtu.be/jNehbmoSXQohttps://www.youtube.com/watch?v=ZaZu1dzxToMhttps://youtu.be/R4YIk-CEPrk 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 […]
Maintenance
Experda Maintenance Rules Maintenance Overview Creating a new backup rule Restoring a database Creating a custom server maintenance rule https://www.youtube.com/watch?v=m1SiJB9wOs8&list=PL6oVVhSmzA3Y8RtOZctaL5MQVozi60Fwy&index=5https://youtu.be/lqDuv59kvHkhttps://youtu.be/BuNwEornygkhttps://youtu.be/bj4F5CD-JgY Maintanance Module delivers advanced tools and automation for maintaining the performance, reliability and integrity of MSSQL databases. From optimizing indexes to implementing robust backup strategies, it ensures your servers are always prepared for demanding workloads. […]
Alerts & Notifications
Setting up your database alerts Alert Actions Alert Overview Custom Alert Setup Template Link to Servers How to Configure an Alert https://www.youtube.com/watch?v=DDQVKmUXKP8&list=PL6oVVhSmzA3YVx5AxaDY4GrI_KCS5C8Rf&index=1&pp=iAQBhttps://youtu.be/sflMUy9Arwchttps://www.youtube.com/watch?v=SHXfSOD8F2w&list=PL6oVVhSmzA3YVx5AxaDY4GrI_KCS5C8Rf&index=3&pp=iAQBhttps://www.youtube.com/watch?v=dRqI8ml7Qmo&list=PL6oVVhSmzA3YVx5AxaDY4GrI_KCS5C8Rf&index=4&pp=iAQBhttps://www.youtube.com/watch?v=JmoFFc3BrTA&list=PL6oVVhSmzA3YVx5AxaDY4GrI_KCS5C8Rf&index=5&pp=iAQB Set up your server, operating system, performance, or database alerts in Experda using predefined templates or customizing new ones. Define alert types as critical, warning, or informational, and link specific servers to your […]
Capacity Planning
Monitor your capacity and optimize storage Capacity Planning Overview https://www.youtube.com/watch?v=sU4nQ9m8c9g&list=PL6oVVhSmzA3ZSiUfXcrABonUXw3JqY_RP&index=1&pp=iAQB With Experda, you can monitor disk and database growth while utilizing prediction algorithms to plan and optimize your storage needs proactively. More modules for you: See it in action! Start Your Free Trial FAQ What is Experda and how does it benefit DBAs and […]
Jobs
Learn the essential skills for monitoring jobs in your system to ensure efficiency and effectiveness Jobs Overview https://www.youtube.com/watch?v=ZQPJkKIXcq8&list=PL6oVVhSmzA3YzQO1UZ2GIdG8m8SrCa_Vp&index=1&pp=iAQB Experda provides a comprehensive Database Jobs Overview, allowing you to monitor jobs across all companies or focus on a specific company dashboard for more detailed insights. More modules for you: See it in action! Start Your Free […]
Always On Availability
Discover effective methods for monitoring and managing your database in clustering mode Always On https://www.youtube.com/watch?v=pkItOkwq96U&list=PL6oVVhSmzA3ZIYnJ0kAZLe2rnkx4Y9Fvd&index=1&pp=iAQB With Experda’s Always On Dashboard, you can continuously monitor lag time, track failovers, and identify performance bottlenecks to ensure optimal performance of your Always On SQL environments. More modules for you: See it in action! Start Your Free Trial FAQ […]
Server Security
Learn how to check and maintain the security of your databases Security Overview Security Health Check Security Settings Suspicious Activities https://youtu.be/-WXN-vS99Aohttps://www.youtube.com/watch?v=KBFBSHPfJ3A&list=PL6oVVhSmzA3YTMn98aVkM7vDEZmkLSBm6&index=2&pp=iAQBhttps://www.youtube.com/watch?v=dnMaRtIpZLM&list=PL6oVVhSmzA3YTMn98aVkM7vDEZmkLSBm6&index=3&pp=iAQBhttps://www.youtube.com/watch?v=9Tq7I8W0MXw Ensure your MSSQL instance security with health checks and suspicious activity monitoring in Experda. Strengthen security with detailed health check reports and analyze operations from non-whitelisted applications or logins to detect suspicious or harmful […]
Queries
Learn to understand the behaviour of your queries Queries Overview Specific Query https://www.youtube.com/watch?v=uoVh-wpOzks&list=PL6oVVhSmzA3ajV78k-Po-OTqOVwXTEOxs&index=1&pp=iAQBhttps://www.youtube.com/watch?v=dUfSIwTUExE&list=PL6oVVhSmzA3ajV78k-Po-OTqOVwXTEOxs&index=2&pp=iAQB Experda allows you to easily track your top queries based on any performance metric and analyze historical queries to optimize system performance. Dive deeper into performance by analyzing specific queries over time to identify trends and areas for improvement. More modules for […]
Blocks & Deadlocks
Learn how to quickly and effectively analyze tracking blocks and deadlocks in your queries Deadlocks Blocks https://www.youtube.com/watch?v=taP_n-t1L5s&list=PL6oVVhSmzA3bsJjrcZmxovbVsCw5A9EOw&index=1&pp=iAQBhttps://www.youtube.com/watch?v=qHN0VIVtb6U&list=PL6oVVhSmzA3bsJjrcZmxovbVsCw5A9EOw&index=2&pp=iAQB With Experda, you can easily track blocks and deadlocks in your SQL servers, quickly analyzing whether the issue stems from a specific session, application, or query. You can also dive deeper into deadlock events with a detailed view, […]
Performance Monitoring
A central control view for all your MSSQL instance needs Performance Overview Performance CPU Performance Tempdb Performance Wait Events Performance Processes Services https://www.youtube.com/watch?v=rU2-FPEhV9U&list=PL6oVVhSmzA3Ymn8PB0wH4c5NdK30-XoDX&index=1&pp=iAQBhttps://www.youtube.com/watch?v=P8cpeJVNxGo&list=PL6oVVhSmzA3Ymn8PB0wH4c5NdK30-XoDX&index=2&pp=iAQBhttps://www.youtube.com/watch?v=pB8HWvRu2a8&list=PL6oVVhSmzA3Ymn8PB0wH4c5NdK30-XoDX&index=3&pp=iAQBhttps://www.youtube.com/watch?v=TUI0FGIUpqM&list=PL6oVVhSmzA3Ymn8PB0wH4c5NdK30-XoDX&index=4&pp=iAQBhttps://www.youtube.com/watch?v=lf2ri6Ag7vo&list=PL6oVVhSmzA3Ymn8PB0wH4c5NdK30-XoDX&index=5&pp=iAQBhttps://youtu.be/YmwvXJC2vY4 Experda offers a Performance Overview, a central control view for all your MSSQL instance needs. Monitor CPU performance, including total and instance CPU usage, CPU by cores, and the top CPU-consuming processes. […]