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.
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.
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.