This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

.Net SqlClient Data Provider

Go to solution
henk_stobbe
DynaMight Champion
DynaMight Champion

‎01 Apr 2020 09:12 AM

Hello,

I have a user that uses: ".Net SqlClient Data Provider", and he has long running queries. I assume Dynatrace does not show these queries as no ODBC layer is used?


The .NET Framework Data Provider for SQL Server (SqlClient) uses its own protocol to communicate with SQL Server. It is lightweight and performs well because it is optimized to access a SQL Server directly without adding an OLE DB or Open Database Connectivity (ODBC) layer.

KR Henk

Labels:
0 Kudos
Reply
1 REPLY 1

Go to solution
Radu
Dynatrace Champion
Dynatrace Champion

‎01 Apr 2020 11:43 AM

Hi Henk,

From what I can see in the Microsoft documentation, the .NET Framework Data Provider for SQL Server implemented as System.Data.SqlClient (or the newer Microsoft.Data.SqlCient) still uses the ADO.NET driver for communicating with the SQL Server database.

Technically, as long as we can inject in the .NET processes that implements this Data.SqlClient framework we should still be able to instrument the ADO.NET driver and get the connection string and query.

Best regards,

Radu

0 Kudos
Reply
Ask a question

Featured Posts