How to Use Database Agents in Microsoft Fabric | Data Exposed

by Patrick LeBlanc and Anna Hoffman

In this Data Exposed episode, Patrick LeBlanc and Anna Hoffman explore how DBAs can use the Database Agents experience to investigate SQL performance issues with supporting evidence.

Proactive SQL performance monitoring

Database Agents in Microsoft Fabric support a shift from reactive troubleshooting to proactive, evidence-driven database administration. Instead of waiting for an application team to report slowdowns, DBAs can use automatic issue detection to identify problems earlier.

The episode covers detection of:

Database Hub and administration workflows

Patrick walks through the Database Hub experience, the configuration requirements for Database Agents, and how detected issues are surfaced. The demonstration also covers integration with SQL Server Management Studio (SSMS), connecting the experience to SQL administration workflows.

Longer-term direction

The discussion outlines a longer-term vision for intelligent agents that learn from DBA interactions over time. This is presented as a future direction, distinct from the demonstrated monitoring and issue-detection capabilities.