Difference between SQL Modifications, Queries, Procedures, and Transactions

[moffatrt]

In Dynatrace Managed, in the Service Details screen for a Database service, there are three sections; SQL Modifications, SQL Queries or Procedures, and SQL Transactions. When you click on "View database statements" under any of these categories, and look at the Database statements, they do not seem to match up with their respective query categories. For example, looking at the statements under "SQL Modifications" shows statements like "getlist" or "search", queries which are obviously not modifying anything.
What do these categories actually mean and why do the statements not match up with their respective categories?

[michael_kopp]

Can you specify what kind of db we are talking about and if this is java or .net?

[moffatrt]

Process is .Net.
Database is Microsoft SQL Server.

[michael_kopp · Accepted solution]

Hi,

I think this is a bug. It sounds like those are stored procedures and should be under the respective group. Modifications should really contain deletes/inserts/updates. It will not really impede anything, but should be fixed.

please report this as a support ticket. Include the fact that this is .net and sql server and if possible some screenshots of the respective purepaths that execute the statement in question.

Thanks

Michael

[moffatrt]

Yeah, definitely not a problem, but it's very confusing for the users. I'll open a ticket. Thanks!