Database Agents: A New Way to Manage Databases in Fabric

Patrick LeBlanc demonstrates how the database agent in Microsoft Fabric Database Hub can help teams focus on the database issues that matter by observing SQL Server databases, surfacing meaningful performance signals, and providing evidence to guide investigation.

Overview

What the Fabric database agent does

• Observes SQL Server databases from within Fabric Database Hub.
• Surfaces performance signals intended to reduce time spent watching dashboards and increase time spent investigating actionable issues.
• Provides evidence and context to guide next troubleshooting steps.

Walkthrough: investigating a blocking issue

• The demo follows a blocking issue from initial detection in Fabric Database Hub into deeper investigation.
• Patrick transitions into SQL Server Management Studio (SSMS) to continue troubleshooting the blocking scenario.

Using GitHub Copilot to support deeper investigation

• The video shows how GitHub Copilot can assist with deeper investigation during the troubleshooting process.

Preview: prototype skills and roadmap

• Patrick previews prototype skills aimed at estate-wide analysis in VS Code.
• Roadmap themes discussed:
  • Outcome verification
  • Memory
  • Greater autonomy
  • Human approval and auditable controls as central design requirements