Questions on Azure SQL DB Diagnostic Settings/ Log Analytics.

Question

Questions on Azure SQL DB Diagnostic Settings/ Log Analytics.

chrisrdba 471

Greetings. After beating my head I finally understood these features how to properly use these features. However, I'm not seeing the value. Once Ive collected some data I run the query below in the portal. I get plenty of data back, but none of it shows me what query was running when the entry was generated. That said, how is it any value? Am I missing something?

Thanks!


AzureDiagnostics
|where Category  == "Blocks"
or Category  == "DatabaseWaitStatistics"

Oury Ba-MSFT 21,121 Reputation points Microsoft Employee Moderator

2023-08-11T23:05:22.8033333+00:00

@chrisrdba Thank you for reaching out.

Is this the first time you are running this query. Was the query running fine before? did the query output any records?

Regards,

Oury
chrisrdba 471 Reputation points

2023-08-15T14:51:46.2766667+00:00

Thanks, first time.
chrisrdba 471 Reputation points

2023-08-16T21:23:04.66+00:00

Does anyone have any ideas on this? The only Category that appears to show anything of value is Errors. The rest return a lot of info, none of which appears to be useful.
Oury Ba-MSFT 21,121 Reputation points Microsoft Employee Moderator

2023-08-18T12:09:32.9666667+00:00

@chrisrdba

Please let us know if that was helpful.

Regards,

Oury

Answer accepted by question author

0 additional answers

Your answer

Oury Ba-MSFT 21,121 Reputation points Microsoft Employee Moderator

2023-08-11T23:05:22.8033333+00:00

@chrisrdba Thank you for reaching out.

Is this the first time you are running this query. Was the query running fine before? did the query output any records?

Regards,

Oury
chrisrdba 471 Reputation points

2023-08-15T14:51:46.2766667+00:00

Thanks, first time.
chrisrdba 471 Reputation points

2023-08-16T21:23:04.66+00:00

Does anyone have any ideas on this? The only Category that appears to show anything of value is Errors. The rest return a lot of info, none of which appears to be useful.
Oury Ba-MSFT 21,121 Reputation points Microsoft Employee Moderator

2023-08-18T12:09:32.9666667+00:00

@chrisrdba

Please let us know if that was helpful.

Regards,

Oury

Answer 1

Oury Ba-MSFT 21,121 Microsoft Employee Moderator

@chrisrdba

In the "Blocks" dataset, query-level data for the blocker and blocked queries may be obtained from the blocked_process_filtered_s column.

The "DatabaseWaitStatistics" dataset does not provide data at the query level. It provides wait stats for the entire database engine instance.

Regards,

Oury

chrisrdba 471 Reputation points

2023-08-22T21:01:55.7466667+00:00

That column for Blocks returns a bunch of chatter, not the actual query being ran.

Overall I think my hopes were a bit too high for what these tools could accomplish, thanks.

Share via

Questions on Azure SQL DB Diagnostic Settings/ Log Analytics.

0 additional answers

Your answer