Trying to Set Up Advanced SQL Tracking

%3CLINGO-SUB%20id%3D%22lingo-sub-1496368%22%20slang%3D%22en-US%22%3ETrying%20to%20Set%20Up%20Advanced%20SQL%20Tracking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1496368%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20for%20a%20corporation%2C%20and%20we%20are%20trying%20to%20set%20up%20Application%20Insights%20for%20one%20of%20our%20products.%26nbsp%3B%20We%20have%20the%20instrumentation%20key%20and%20everything%20integrated%20into%20the%20code%20where%20necessary%2C%20but%20we%20still%20can't%20see%20all%20the%20information%20we%20want...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20goal%20is%20for%20our%20screen%20to%20look%20like%20this%3A%26nbsp%3B%3CIMG%20src%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fapp%2Fmedia%2Fasp-net-dependencies%2F3-end-to-end.png%22%20border%3D%220%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fapp%2Fasp-net-dependencies%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fapp%2Fasp-net-dependencies%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe've%20been%20using%20the%20above%20link%20to%20guide%20us.%26nbsp%3B%20We%20have%20installed%20the%20Microsoft.Data.SQLClient%20NuGet%26nbsp%3B%20Package%2C%20and%20the%20XML%20line%2C%20but%20the%20advanced%20SQL%20data%20still%20does%20not%20show.%26nbsp%3B%20We%20are%20running%20things%20locally%20on%20IIS%20Express%2C%20and%20our%20project%20runs%2C%20and%20when%20we%20interact%20with%20the%20web%20app%20we%20see%20spikes%20in%20our%20performance%20graph%2C%20so%20we%20know%20it%20is%20collecting%20some%20metrics.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22sdk.png%22%20style%3D%22width%3A%20125px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201856i81824296341AFE20%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22sdk.png%22%20alt%3D%22sdk.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWe%20apparently%20need%20to%20be%20running%20SDK%20Version%20'rddp'.%26nbsp%3B%20We%20are%20using%20the%20version%20'rddf'%20and%20'rdddsd'%20which%26nbsp%3B%3CSPAN%3Eindicates%20dependencies%20are%20collected%20via%20DiagnosticSource%20or%20EventSource%20callbacks%2C%20and%20hence%20full%20SQL%20query%20aren't%20being%20captured.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20got%20the%20information%20about%20the%20SDK%20Version%20by%20running%20this%20command%20in%20Logs%20in%20App%20Insights%3A%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3Edependencies%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20timestamp%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3Ed)%20%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%20%3CSPAN%3Ecount%3C%2FSPAN%3E%3CSPAN%3E()%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20cloud_RoleInstance%2C%20sdkVersion%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1496368%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApplication%20Insights%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1496938%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20Set%20Up%20Advanced%20SQL%20Tracking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1496938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713369%22%20target%3D%22_blank%22%3E%40kc185188%3C%2FA%3E%26nbsp%3BAdding%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F217305%22%20target%3D%22_blank%22%3E%40Hong%20Gao%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I work for a corporation, and we are trying to set up Application Insights for one of our products.  We have the instrumentation key and everything integrated into the code where necessary, but we still can't see all the information we want...

 

The goal is for our screen to look like this: 

 

https://docs.microsoft.com/en-us/azure/azure-monitor/app/asp-net-dependencies

 

We've been using the above link to guide us.  We have installed the Microsoft.Data.SQLClient NuGet  Package, and the XML line, but the advanced SQL data still does not show.  We are running things locally on IIS Express, and our project runs, and when we interact with the web app we see spikes in our performance graph, so we know it is collecting some metrics.

 

sdk.png

We apparently need to be running SDK Version 'rddp'.  We are using the version 'rddf' and 'rdddsd' which indicates dependencies are collected via DiagnosticSource or EventSource callbacks, and hence full SQL query aren't being captured.

 

We got the information about the SDK Version by running this command in Logs in App Insights: 

dependencies | where timestamp > ago(1d) | summarize count() by cloud_RoleInstance, sdkVersion
1 Reply