topic Re: DB Locks, Blocking etc in Open Q&A

DB Locks, Blocking etc

mrc15816 — Sun, 14 Oct 2018 01:12:18 GMT

Hello,

We have a shared MS SQL Server 2012 with over 20 databases running. We have the OneAgent running as Infrastructure monitoring mode. We get helpful information from the Host level - I would like to get much deeper understanding of the Locks page is - How would I know the locks shown represents which DB.

Thank you

MRC

Re: DB Locks, Blocking etc

ChadTurner — Mon, 20 Jul 2020 15:16:27 GMT

you can do this via the Multidimensional Analysis chart - let me know if you need any assistance setting this up:

Re: DB Locks, Blocking etc

mrc15816 — Mon, 20 Jul 2020 15:52:51 GMT

@Chad T. Thank you for looking into my post and responding. I would love to see if you can provide more details. Thank you once again!

Re: DB Locks, Blocking etc

ChadTurner — Mon, 20 Jul 2020 15:57:34 GMT

so you might need to go full stack for full monitoring, but go to Diagnostic tools, and select "Create Analysis View"

From there select the metric you are interested in, the aggregation and the dimension if need and you can also filter the results if you are not using management zones.

Re: DB Locks, Blocking etc

mrc15816 — Wed, 22 Jul 2020 13:51:30 GMT

Thank you for sharing the details. We would like to be on the Infrastructure as these servers could exceed 64GB RAM which doesn't meet the ROI for the licenses. We are looking at building a custom plugin that will pull the details. Thank you for your help though

Re: DB Locks, Blocking etc

ChadTurner — Wed, 22 Jul 2020 15:49:46 GMT

understandable - you might still be able to do this at an infrastructure only level but im not 100% sure. WE all have been there trying to get the host out of our host units

Re: DB Locks, Blocking etc

dave_mauney — Mon, 27 Jul 2020 11:58:52 GMT

Are you aware of the 1 Host Unit cap on Infrastructure only agents? You should verify with your sales contact to see if this can help.

Re: DB Locks, Blocking etc

mrc15816 — Mon, 27 Jul 2020 14:22:50 GMT

Thank you - yes we are aware of 1 host unit cap on the Infrastructure mode regardless of the amount of memory allocated.

Re: DB Locks, Blocking etc

AntonioSousa — Mon, 27 Jul 2020 17:07:25 GMT

When you are talking about SQL Server DB locks, I believe you are talking about this screen:

The locks in this screen are not related to the locks that are available in Dynatrace, namely through Method Hotspots. It would be great though to have more details in which DB invocations are involved in these locks.

Re: DB Locks, Blocking etc

mrc15816 — Tue, 28 Jul 2020 01:30:53 GMT

@Antonio S. Yes I am referring to this page. We have multiple COTS products where we can’t instrument via OneAgent. We need to monitor the DB systems and we need different monitoring software.

Re: DB Locks, Blocking etc

Prithvi_Mandal — Tue, 08 Oct 2024 07:18:24 GMT

Hii ChadTurner,

I want blocked query metrics for database , can you please tell me the path to get blocked queries .

Regards,

Prithvi

Re: DB Locks, Blocking etc

adam_gardner — Mon, 21 Oct 2024 06:13:56 GMT

You may wish to look into the sqlserverreceiver of the OpenTelemetry collector.