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.
Azure Diagnostic Settings Logs not returning data.
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!
Azure SQL Database
3 answers
Sort by: Most helpful
-
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
2023-07-14T22:14:27.3733333+00:00 -
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.
-
chrisrdba 471 Reputation points
2023-08-11T16:24:32.8766667+00:00 Removed double post.