wait statistics in Early watch

[Former Member]

Hi,

In EarlyWatch reports of my production system, I am getting Wait Statistics for LCK_M_X, LCK_M_S, or LCK_M_U in Warning (Yellow Color).

Please let me know how should I dig into it and resolve it?

Regards

[ACE-SAP]

Hi

These are SQL server DB waits... thus you should post your message in the appropriate area =>

You can dig into google here are some of the results I get with a simple search...

sql server 2008 - How to solve lck_m_x Lock in sql - Stack Overflow

Check this note

1152848 - FAQ: SQL Server Wait Events

Regards