Azure Diagnostic Settings Logs not returning data.

chrisrdba 471 Reputation points
2023-07-14T21:53:47.07+00:00

Greetings. Saving Diag Settings to Log Analytics. Using the 4 DB native queries, only wait stats is returning data. Attached are my settings. Any ideas? Thanks!

diagSettings.JPG

Azure SQL Database
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2023-07-14T22:14:27.3733333+00:00

    Have you configured Diagnostics to send the data to Log Analytics? Have you used Kusto to query the data collected? Could you please try to go through the steps outlined on this article to make sure Diagnostics has been configured completely and you are querying the data collected on Log Analytics.


  2. chrisrdba 471 Reputation points
    2023-08-11T16:24:06.16+00:00

    OK I finally got a chance to circle back to this. The issue wasn't the collection, the issue was that I was using the portal example queries to return the data. They don't (with the exception of DB wait stats), no matter what I set the time range to. Once I stepped away from this for a while and came back to it I realized I should try some other queries. I do have some follow up questions but will start a new thread for that.

    0 comments No comments

  3. chrisrdba 471 Reputation points
    2023-08-11T16:24:32.8766667+00:00

    Removed double post.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.