SQL Server comes with a feature called Query Store, which provides some performance details, including wait information. For more deeper diagnostic information there are a handful of third-party ...

LCK_M* —This wait type happens when a query locks an object while another query is waiting to lock the same object. A common scenario is when a query is trying to modify a row while another query is ...

If you are on SQL Server 2016 or higher and you aren't using the query store feature, you are missing out on the single best database performance diagnostic tool I've used in 21 years of working ...