cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Difference between SQL Modifications, Queries, Procedures, and Transactions

moffatrt
Contributor

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?

4 REPLIES 4

michael_kopp
Dynatrace Pro
Dynatrace Pro

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

moffatrt
Contributor

Process is .Net.
Database is Microsoft SQL Server.

michael_kopp
Dynatrace Pro
Dynatrace Pro

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
Contributor

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