question

DRMonroe-3873 avatar image
0 Votes"
DRMonroe-3873 asked Criszhan-msft edited

Adding Logs from SQL Hosted on VM to a Log Analytics Workspace

Hello.

I'm looking for guidance regarding how to gather SQL logs generated by MSSQL instances hosted on Azure VMs using a Log Analytics workspace (if this is possible at all).

Searching hasn't yielded any helpful results yet so any ideas would be very much appreciated.

azure-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

kasunraj avatar image
0 Votes"
kasunraj answered DRMonroe-3873 commented

You can install Log analytics agent in Azure VM with MSSQL installed. You can follow below link for more information

https://www.red-gate.com/simple-talk/sql/database-administration/how-to-use-sql-audit-and-azure-log-analytics-to-comply-with-audit-rules/

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.