Monitor Azure SQL Managed Instance with SQLBench
SQLBench Releases | Nov 08, 2023
We are proud to announce support for monitoring Azure SQL Managed Instance in our latest SQLBench Agent, version 2023.10.30.03.
SQLBench gathers the same telemetry from Azure SQL Managed Instance instances as from SQL Server instance types, including:
- Expensive queries
- CPU, DTU and other compute resource counters
- SQL Server Perfmon counters
- SQL Server Wait Statistics
- SQL Server Memory Clerks
- SQL Server Database Virtual File Statistics
- Exceptions
- SQL Agent Job execution statistics
- Server configurations
- Database properties, Objects, Files & Filegroups
To monitor Azure SQL Managed Instance, an upgrade to our latest SQLBench Agent version 2023.10.30.03 (or higher) is required.
This version includes the features necessary to monitor Azure SQL Managed Instance.
Download the latest version of the SQLBench Agent by logging in to our portal, choosing account settings, then Agent > Download.
- Select "Azure SQL Managed Instance"
- Enter the SQL Managed Instance Endpoint (from your Azure portal)
- Choose a SQL / Windows Login
- Click "Test" (to test accessibility & permissions)
- Click "Save"
View telemetry in our familiar pre-configured reports.
No need to set up your own reports, our pre-configured reports will get you started with:
- Top Queries
- Perfmon counters
- Backups
- Job History
- Wait Statistics
- Memory Clerks
- Errors
Build custom dashboards, in addition to our pre configured reports
Drag / drop any mix of metrics from single or multiple servers
Access raw data via our API.
