question

Ralph M. avatar image
Ralph M. asked ·

Difference between SQL Modifications, Queries, Procedures, and Transactions

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?

Dynatrace Manageddatabase
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Ralph M. avatar image
Ralph M. answered ·

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

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Michael K. avatar image
Michael K. answered ·

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

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Ralph M. avatar image
Ralph M. answered ·

Process is .Net.
Database is Microsoft SQL Server.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Michael K. avatar image
Michael K. answered ·

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

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Space Topics

mobile monitoring dotnet synthetic monitoring reports iis chat kubernetes servicenow amazon web services mysql mainframe rest api errors cassandra dashboard oneagent sdk cmc application monitoring openkit smartscape request attributes monitoring developer community user tagging log monitoring services ufo syntheticadvisory activegate ip addresses auto-detection high five award oracle hyperion webserver uem usql iib test automation license web performance monitoring ios news migration management zones index ibm mq web services custom event alerts notifications sso host monitoring knowledge sharing reports browser monitors java hybris sap vmware maintenance window user action naming javascript appmon ai synthetic classic availability tipstricks automation extensions session replay diagnostic tools permissions davis assistant faq documentation problem detection http monitors server easytravel apdex aws-quickstart network docker tags and metadata cloud foundry google cloud platform synthetic monitoring process groups account usability dynatrace saas gui paas openshift key user actions administration user actions postgresql synthetic locations oneagent security Dynatrace Managed user management custom python technologies mongodb openstack user session monitoring continuous delivery citrix configuration alerting NGINX action naming linux nam installation masking error reporting database mission control jmeter recorder apache mobileapp RUM php threshold azure purepath davis scripting agent aix nodejs android