topic Re: .NET Framework Windows Service and SQL Statements in Open Q&A

.NET Framework Windows Service and SQL Statements

bruno_camara — Tue, 25 Mar 2025 20:37:26 GMT

I have a .NET Framework windows service with Deep Monitoring. Basically this windows service retrieve messages from a MSMQ queue and saves a record in a SQL Server database.

I can find traces originated from this process group while consuming messages from queue, but i can't find the SQL statements that are being sent to the target the database, like I would see if it was an application hosted in IIS, for example.

Any idea why the SQL statements are not being collected inside a windows service that has Deep monitoring?

Thanks in advance

Re: .NET Framework Windows Service and SQL Statements

AntonPineiro — Wed, 26 Mar 2025 14:10:06 GMT

Hi,

I would say:

Deep monitoring enabled + process restarted.
Database framework supported.

Best regards

Re: .NET Framework Windows Service and SQL Statements

bruno_camara — Wed, 26 Mar 2025 10:22:16 GMT

Thank you @AntonPineiro

Regarding 1, checked.

Regarding 2, could you please provide the link where you get that table?

The windows service that is beinf deep monitored was build tartgeting .NET Framework v4.8, and is using vanilla ADO.NET to communicate with the database.

When hosting a service in IIS, targeting the same .NET framework, and using ADO.NET, we can see the statements being collected. In case of the windows service, we cannot. So, there's something here that I might be missing.

Re: .NET Framework Windows Service and SQL Statements

AntonPineiro — Wed, 26 Mar 2025 14:11:49 GMT

Hi,

I have just edited my before comment because table was not correct. ADO.NET is supported, you can see it here

Best regards

Re: .NET Framework Windows Service and SQL Statements

Mizső — Wed, 26 Mar 2025 15:26:01 GMT

Hi @bruno_camara ,

Sometimes the automatic instrumentation does not work. In this case I always try to use custom service detection to see missing requests and database calls.

But in your case maybe there is another issue if you can see the call details in the trace expect the database calls.

Best regards,

János

Re: .NET Framework Windows Service and SQL Statements

bruno_camara — Wed, 26 Mar 2025 19:17:03 GMT

Thank you.

I didn't know about Custom Service Identification. It seems exactly what I need, since I want to see instances of windows service as "Services" in Dynatrace lingo. I'm gonna try to define the custom service (entry point and methods)

Re: .NET Framework Windows Service and SQL Statements

bruno_camara — Fri, 28 Mar 2025 08:42:41 GMT

I just want to confirm that I managed to monitor the database calls inside the windows service, by using a custom servide definition as suggested by @Mizső

Thanks for all your help.