Database Queries Not Segregated (DB Tuning)

Question

Question by Rajesh S. · Feb 17, 2015 at 05:27 PM ·

Database Queries Not Segregated (DB Tuning)

Hi all,
I was going through database dashboard of a mobile application.
Following are the snapshots:

You can see too many similar queries are being executed but DT is showing them as distinct rather than segregating them as one.
I would like to why is this happening? Is there something going wrong (with DB)? Please suggest.

[Also, here is an APM blog about DB tuning:

http://apmblog.dynatrace.com/2011/07/05/beyond-persistence-how-to-exploit-your-database-for-better-performance/

I hope this is not n+1 query problem though.]

Thanks in advance.

R.S.

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Answer 1 · 2015-02-17T19:33:16Z

Answer by Wolfgang G. · Feb 17, 2015 at 07:33 PM

Hi Rajesh,

I guess this is because those are in fact distinct queries as the LIKE clause is different. You can see in the executions column that some are executed multiple times and then the count is increased. I would suggest to rewrite the query to use a parameter also for LIKE

Hope that helps,

Wolfgang

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Answer 2 · 2015-02-17T20:53:29Z

Answer by Rajesh S. · Feb 17, 2015 at 08:53 PM

Thanks Wolfgang for helping out.

I am sending this info to my team members for review.

Regards,

Rajesh.

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Database Queries Not Segregated (DB Tuning)

2 Replies

Join the conversation!

LIVE WEBINAR

Live webinar: Ensuring Digital Business Availability with Dynatrace

Live webinar: Ensuring Digital Business Availability with Dynatrace

Live webinar: Ensuring Digital Business Availability with Dynatrace

Follow this Question

Forum Tags