Woodler’s SQL-D is Azure SQL Database auditing service providing detailed
Configuration based / Performance based metrics and analysis. The target for this
service is a single Azure SQL Database running on Azure SQL Server or as a part of an
Elastic Pool.
SQL-D audit is delivered as a Power BI report which consists of several reports divided
into multiple categories based on specific configuration and performance areas.
SQL-D audit does not collect and store any User data. What it stores is metadata from
Azure SQL Database object and the Azure SQL Server object where the database runs
from.
How does the SQL-D audit work?
- Azure SQL Database and Azure SQL Server configuration metadata
- Names of the table columns and respective table names which are included in
the database index definitions - T-SQL code of Ad-Hoc queries and code from Stored Procedures / Functions
and Triggers which was collected by the Database Engine at the time of audit for
identification of the queries for further performance analysis. T-SQL code is
shortened to store only the first 512 characters.
What data does the SQL-D audit store?
SQL-D audit service is being executed as a Windows Executable file (.exe) which runs
from Management Server. The program connects to the target Azure SQL Database
and reads the configuration and performance metadata of the SQL instance and
respective user database.
Audited Azure SQL Database can participate in an Elastic Pool. No other Azure SQL
Database is audited, but the one the customer has chosen.
Configuration data and performance metrics are stored for further analysis. Data can be
stored locally on a Management Server or remotely in Azure Storage Account container.
Data collection of SQL-D audit runs continuously for 24 hours. When the collection is
completed, Woodler administrator copies the audit data from the Management Server or
Azure Storage Account container to Woodler’s internal infrastructure to provide the final
analysis and report.
Final Audit Power BI report is then delivered and presented to the client.
