Azure SQL monitoring

• Auto-discovery and deployment technologies ensure monitoring scales with even the largest deployments.
• Metric thresholds and alerts are configured out of the box to ensure proactive alerting from the moment of installation.
• The AIOps engine within the eG Enterprise auto-baselines key metrics, learning about day-to-day, month-to-month and other seasonal patterns of usage to eliminate false positive alarm storms and provide proactive anomaly detection.
• Automated intelligent root cause diagnosis alongside detailed diagnosis information ensures faster MTTR.
• Continual monitoring of logs avoids the need to trawl and parse logs retrospectively and removes the effort of manual investigations and queries.
• Out-of-the-box customizable dashboards are available for all major databases including Azure SQL options. Providing actionable insights and detailed analytics. Role-based personalized dashboards can be made available to different stake holders.

Ensure optimal performance of databases and the applications depending on them. Over time, index fragmentation will cause a degradation in database performance and eventually poor application performance. eG Enterprise will automatically raise alerts if indexing issues start to occur, allowing the database administrator to rectify issues long before end users experience issues with application performance.

eG Enterprise provides detailed information of fragmented indexes and tables, as well as providing the details of unused indexes which are occupying space in the database and unnecessarily consuming resources for every update or insert into the database. eG Enterprise will also provide recommendations regarding missing indexes in the DB that would deliver better performance for application queries.

Beyond Azure SQL, eG Enterprise monitors and correlates data from across the whole of your IT application and Infrastructure landscape:

• Covers your Azure landscape including Azure Subscription, Backup, Storage, AVD, Azure AD and more.
• Domain specific monitoring and reporting of over 500+ technology stacks including technologies such as Digital WorkSpaces (Citrix, VMware, Microsoft AVD, Amazon WorkSpaces, Microsoft RDSH), Web Servers (Microsoft IIS, Apache, Nginx), Load Balancers and Gateways (NetScaler, F5, Cisco) and more.
• Comprehensive monitoring and auditing of authentication technologies including on-premises Active Directory and Azure AD, as well as other options such as Okta.

eG Enterprise application performance monitoring allows database performance to be monitored in the context of the applications using Azure SQL databases.

• Without requiring any agents on the database servers, eG Enterprise APM traces all application accesses and reports on slow queries and exceptions during database processing.
• When a specific web page, services or URL is slow, you don't have to spend hours figuring out what is causing the slowdown. eG Enterprise APM gives you the answers at your fingertips.
• Eliminates finger-pointing between application development, application operations, and database admin teams by finding the root cause and not the symptoms.
• Support for application delivery technologies including App Servers (Tomcat, WebLogic, WebSphere, JBoss) and code level insights into common languages including Java, .NET, PHA and Node.js.

eG Enterprise is designed to seamlessly integrate with Modern IT processes and technologies. Ensure that your Azure SQL landscape is tightly integrated with transparent and traceable observability for the assurance of the whole organization.

• Rich REST APIs enable integration for enhanced and bespoke automation with Terraform, Ansible and Nerdio, Data extraction to PowerBI, Tableau and Qlik for visualization. A CLI is available for DevOps like workflows.
• ITSM service and help desk tool integrations with all major vendors including ServiceNow, Autotask, JIRA and others; to ensure actions arising are processed within standard and traceable processes as needed.

• Real time and historical reporting on usage enable administrators to understand short term behavior and long term demands on your SQL landscape
• Capacity plan and optimize costs based on real user monitoring
• Test availability and verify pre-production systems with a powerful suite of full session synthetic monitoring tools
• Set and quantify SLAs and assess success based on quantifiable KPIs
• Flexible and transferable licensing allows you to migrate your eG Enterprise licenses alongside your SQL provision avoiding shelfware. Perfect for baselining migrations and quantifying the success of moving from on-premises options to Azure SQL