Can Foglight Database monitoring be used to trace or audit a SQL DDL Operation?
I want to trace activity performed on a monitored SQL database by a user or administrator/DBA. Can Foglight Database monitoring be used to trace or audit a SQL DDL Operation?
Tracing a database configuration or design change from Foglight.
DDL statements (ex: ALTER, CREATE, DROP) will be captured only if it is in the top activity(Top SQL Statements, SQL Batch etc). Foglight is not an Auditing tool, it is a Performance Monitoring tool. There may be some functionality overlap, but it is not designed to perform complete Auditing on DB systems at this time.
Schema changes like “alter table”, “drop index”,”create trigger” etc. should be reported under CHANGE TRACKING in SQL Performance, if SQL PI Extension is enabled starting and Change Tracking is available and can be enabled on the SQL instance.
Some functions/statements such as Truncate table, for example, will never be reported as it very quick and would likely not be captured and is not a schema change.
Use of SQL Server Audit log tool or Windows Event and SQL Server Error Logs can sometimes be used to trace additional changes on instances.