how to check SQL database logs for particular tables

Question

how to check SQL database logs for particular tables

Deshmukh, Vijit 516

Hi Team,

We are using azure SQL database for our web application.

We want to see the logs for the few particular tables from the database.

I tried logs under the Monitoring > Logs.

But didn't found the results

Kindly guide on this.

1 answer

Your answer

Answer 1

Oury Ba-MSFT 20,911 Microsoft Employee Moderator

@Deshmukh, Vijit Thank you for reaching out.

My understanding is that you are trying to see logs for a few particular tables in your Azure SQL Database.

To view logs for specific tables in an Azure SQL Database, you can use the Azure SQL Database auditing feature. The auditing feature allows you to track database events and write them to an audit log in Azure Storage or Event Hubs.

Please let me know if the answer helped you. If not, please comment below if any additional questions or further clarification.

Regards,

Oury

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-07-25T17:20:49.9433333+00:00

@Deshmukh, Vijit Checking if the above answer was helpful. If yes, please mark as accept answer. Otherwise comment below and do let us know if you need additional clarification.

Regards,

Oury
Deshmukh, Vijit 516 Reputation points

2023-08-01T16:21:46.2233333+00:00

Hi @Oury Ba-MSFT Auditing enabled under security tab of SQL database server.

What will be the next step on this.
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-08-01T23:40:20.9466667+00:00

Deshmukh, Vijit

You can analyze logs using. log analytics. You can follow the below doc for instructions.

https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-analyze-audit-logs?view=azuresql-db

Regards,

Oury
Deshmukh, Vijit 516 Reputation points

2023-08-02T10:11:10.0433333+00:00

Hi @Oury Ba-MSFT

we have enabled auditing on SQL server.

Do we need to enable auditing at SQL database as well?
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-08-03T16:01:54.1233333+00:00

Deshmukh, Vijit

Yes, but I would to know what logs are you referring? I think I am missing some information.

Regards,

Oury
Deshmukh, Vijit 516 Reputation points

2023-08-08T05:28:22.82+00:00

Hi @Oury Ba-MSFT I want to see logs of a particular table.

Example: what type of operations performed on that table, like this operations logs wants to capture.
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-08-09T22:44:29.5966667+00:00

Deshmukh, Vijit

Yes, this is possible using auditing as I have mentioned above with links.

Auditing tracks database events and writes them to an audit log in your Azure storage account, Log Analytics workspace, or Event Hubs. (If you have enabled auditing, you can view the audit logs)

Regards,

Oury
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-08-14T19:02:47.1033333+00:00

Deshmukh, Vijit

In addition to the above link. These also will be helpful for your scenario.

https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-analytics-tutorial

https://learn.microsoft.com/en-us/azure/azure-monitor/logs/get-started-queries

Regards,

Oury
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-08-14T19:05:05.77+00:00

Deshmukh, Vijit

In addition to the above.

Please find these helpful links

https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-analytics-tutorial

https://learn.microsoft.com/en-us/azure/azure-monitor/logs/get-started-queries

Please let me know if you get stuck so I can unblock you.

Regards,

Oury
Deshmukh, Vijit 516 Reputation points

2023-08-22T11:42:12.11+00:00

Hi @Oury Ba-MSFT

I had enabled the auditing in SQL database as shown below.

Please let me know whether it is correctly configured.
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-08-23T03:09:23.02+00:00

Deshmukh, Vijit

Thank you for reaching out.

I saw on the screen that you have selected storage enables you to archive vast amounts of diagnostic telemetry for a fraction of the cost of the previous two streaming options.

Data streamed to a Log Analytics workspace can be consumed by SQL Analytics. SQL Analytics is a cloud only monitoring solution that provides intelligent monitoring of your databases that includes performance reports, alerts, and mitigation recommendations. Data streamed to a Log Analytics workspace can be analyzed with other.

You can select Log analytics.

In the Azure portal create a log analytics workspace.

you'll use Log Analytics features to build one query and use another example query. When you're ready to learn the syntax of queries and start directly editing the query itself, read the Kusto Query Language tutorial.

https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-analytics-tutorial

Please let me know if you need more info.

https://learn.microsoft.com/en-us/answers/questions/1344518/questions-on-azure-sql-db-diagnostic-settings-log

Regards,

Oury

Share via

how to check SQL database logs for particular tables

1 answer

Your answer