Mirrored Databases Auditing

Hi PhillipsKL 

I assume you're interested in the following aspects for your mirrored database in Fabric:

- Database plane auditing (at the SQL level, including which queries or scripts were executed and on which objects)

- Platform plane auditing (such as who accessed or edited items, and any changes to permissions)

When you set up a mirrored database in Fabric, the platform automatically provides a SQL analytics endpoint. You can use the SQL audit logs available for these endpoints, as outlined in the following link:

SQL Audit Logs in Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn

For platform-level actions (such as viewing, sharing, or changing permissions), Fabric works with the Microsoft Purview audit log.

Track user activities in Microsoft Fabric - Microsoft Fabric | Microsoft Learn