Azure
Investigate Monitoring viewer in Azure Portal
Certain logs/errors were not showing up in the Azure Portal "live" Monitoring viewer in the portal.
Investigate and Document how we can improve the experience.
Follow-up task from https://github.com/Azure/azure-functions-sql-extension/issues/816.
Filed an issue in the host repo: https://github.com/Azure/azure-functions-host/issues/9239.
If we can't get this figured out we should at least document what other methods they can use to see the logs.
I think it would be great to have more insight into the configuration of these functions. If it is connecting to the db correctly, if change tracking is not turned on, etc.
The logs should have any errors that occur - this includes change tracking not being enabled or any connection errors that occur. Are you not seeing these show up? The issue here is that they aren't showing up in the Monitoring tab for some reason (which isn't something we can really control unfortunately) - but you should still be able to see them in the log stream and/or App Insights
@Charles-Gagnon which logs? I keep going to the monitoring tab so that may also be part of the issue.
@jmarbutt If you go to your function app and click on Log Stream under Monitoring, are you able to see any logs?
Log streaming : https://learn.microsoft.com/en-us/azure/azure-functions/streaming-logs
Application Insights : https://learn.microsoft.com/en-us/azure/azure-functions/analyze-telemetry-data#view-telemetry-in-application-insights
I am able to see the logs but I am not seeing anything related to that function or anything that seems like an error.
Could you open a separate issue (so we aren't cluttering up this one, which is a separate problem) and we can help try to track down why you aren't seeing anything?
When you do, if you could include the logs you do see and what version of the extension you're using that'd be great.
Added note in docs about logging: https://github.com/Azure/azure-functions-sql-extension/pull/927#pullrequestreview-1640249690.
Moving this out of GA Milestone while I continue to follow up with the Functions team.