Missing SQL events
Previously I've had SQL queries listed in Timeline mode. But lately (haven't nailed down when this happened) I haven't had any. I've recently changed to .net 4.8 and latest dottrace but don't remember doing any other changes. I'm using the remote agent on win 2016 server and sqlserver 2016.
Is there a way to debug why I don't get events from SQL server?
Please sign in to leave a comment.
Hi,
Could you please create a support ticket ("Submit a request" button in the upper right corner) and attach all log files from %temp%/jetlogs and %windir%/temp/jetlogs folders to it (please clean the folders and reproduce the issue again before submitting the request)?
Also could you please check the presence of C:\Windows\Microsoft.NET\Framework64\v4.0.30319\AdoNetDiag.dll and
C:\Windows\Microsoft.NET\Framework\v4.0.30319\AdoNetDiag.dll files on your machine?
Sorry, I seem to have missed https://dotnettools-support.jetbrains.com/hc/en-us/articles/360000080419-There-may-be-no-SQL-events-in-a-Timeline-snapshot-if-it-was-taken-during-an-attach-session on initial search. Adding the first reg key solved the issue.
I see, thank you for letting me know.
Seems broken again with 2020.2.4. I've verified that ETW events of type Microsoft-AdoNet-SystemData are in fact collected using PerfView. But nothing shows up in dotTrace. I've added to two reg keys, restarted the process etc. Does dotTrace look for Microsoft-AdoNet-SystemData or Microsoft.Data.SqlClient.EventSource. The latter does not emit anything on my machine.
It is very strange, we didn't change anything related to SQL events. Are you still profiling a .NET Framework 4.8 application? What version of Windows are you using?
We use a system ADO.NET provider named "System.Data.1", its GUID is "914ABDE2-171E-C600-3348-C514171DE148".