How to monitor user`s queries in Azure SQL DB?

Question

How to monitor user`s queries in Azure SQL DB?

Vitalii Liashuk 160

Hi,

I want to monitor user`s queries in Azure SQL DB. When user make some manual changes it is a risk and I want to know when somebody connects to sql db and execute some query.

Does Microsoft has solution for my request?

Thank you!

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-10-19T13:57:09.9466667+00:00

Hi,@Vitalii Liashuk Thanks for posting your question in the Microsoft Q&A forum.

You can check the steps provided from this document here https://learn.microsoft.com/en-us/azure/azure-monitor/logs/query-audit#configure-query-auditing

Regards

Geetha
Vitalii Liashuk 160 Reputation points

2023-10-19T14:02:46.7566667+00:00

Hi,

I want to track queries in Azure SQL DB, not in Azure Monitor.
Vitalii Liashuk 160 Reputation points

2023-10-19T16:58:39.4366667+00:00

Hi Geetha,

Does this feature give me ability to view which query runs particular user? Or could I view the history of queries?
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-10-19T22:34:05.8866667+00:00

@Vitalii Liashuk Query Store does not include information about the source of the query (e.g. who executed it, the machine/host from which it was run, the application from which it was run)

Regards

Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-10-24T20:43:35.4533333+00:00

@Vitalii Liashuk Please inform me if you have any remaining questions so I can address them accordingly.

Regards

Geetha

1 answer

Your answer

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-10-19T13:57:09.9466667+00:00

Hi,@Vitalii Liashuk Thanks for posting your question in the Microsoft Q&A forum.

You can check the steps provided from this document here https://learn.microsoft.com/en-us/azure/azure-monitor/logs/query-audit#configure-query-auditing

Regards

Geetha
Vitalii Liashuk 160 Reputation points

2023-10-19T14:02:46.7566667+00:00

Hi,

I want to track queries in Azure SQL DB, not in Azure Monitor.
Vitalii Liashuk 160 Reputation points

2023-10-19T16:58:39.4366667+00:00

Hi Geetha,

Does this feature give me ability to view which query runs particular user? Or could I view the history of queries?
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-10-19T22:34:05.8866667+00:00

@Vitalii Liashuk Query Store does not include information about the source of the query (e.g. who executed it, the machine/host from which it was run, the application from which it was run)

Regards

Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-10-24T20:43:35.4533333+00:00

@Vitalii Liashuk Please inform me if you have any remaining questions so I can address them accordingly.

Regards

Geetha

Answer 1

@Vitalii Liashuk Thanks for clarifying your question.

There are multiple options, what works best really depends on the knowledge of SQL, tools, and troubleshooting. For example, you can use Query Store reports that exist in SSMS. Query Store is a feature in SQL Server that captures a history of queries, query plans, and runtime statistics.

you can follow this document https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15

Let me know if this helps

Regards

Geetha

Share via

How to monitor user`s queries in Azure SQL DB?

1 answer

Your answer