Your Azure SQL environment continues to grow and you’re working harder than ever to improve Azure SQL performance. But you can’t fix what you can’t see. Once an Azure SQL performance problem occurs, you’re already in reactive mode, spending time fixing issues instead of innovating and preventing problems. But what if you had a better Azure SQL performance management tool with built-in tools to help you be more proactive and find causes of problems faster?
Foglight supports monitoring Azure SQL Managed Instances, Single Databases, and Elastic Pools, and the databases in each pool, so that performance or availability issues due to resource consumption or workload volumes anywhere in your Azure SQL do not go undetected. If problems do arise, the information available in Foglight will help lead your team to a resolution as quickly as possible so repeating problems can be mitigated.
Azure SQL Managed Instances are monitored by Foglight for SQL Server, and the optional Performance Investigator for SQL Server provides deep workload analytic tools that further assist database managers and application teams in locating root causes of issues and suggest recommended remediation.
Azure SQL Elastic Pools and Elastic Pool Databases, as well as Single Databases, are monitored by Foglight for Azure SQL. Again, the optional Performance Investigator can assist in analyzing the workloads running on each of those environments where it is deemed helpful.
User Level Access provides a layer of security and convenience by indicating for specific users or groups which Azure SQL connections, database and Elastic Pools they should be able to view within Foglight.
So, wherever performance or availability issues arise in your Azure SQL environments, Foglight can help you detect those problems quickly, and diagnose the cause so the appropriate action can be taken.
See critical issues across platforms and take immediate action to improve Azure SQL performance.
Understand health and activity at a glance. Get pop-up advice with workflows. Simplify Azure SQL performance tuning.
Receive alerts when activity deviates from normal metrics.
Resolve Azure SQL performance issues through diagnostics and alarm data from any drilldown screen.
Use data you have collected to develop customized views and reports.
Investigate workload by drilling into data on users, programs, SQL and sessions.
Resolve concurrency issues with historical reviews of blocking-lock scenarios.
MANAGE MULTIPLE PLATFORMS
PERFORMANCE #1 RESPONSIBILITY
IMPROVED RESOLUTION TIME
View wait-event data at the statement level to resolve resource-related performance problems.
Search for past solutions, set up blackouts and manage your alarms.
Integrate your other end-to-end enterprise monitors seamlessly.
Determine the location and cause of waits by diagnosing your wait statistics.
You can easily add database monitoring to your infrastructure or configure as a standalone solution.
Proactively optimize performance with information about locking and offensive SQL.
Both on-premises and cloud deployments - including: