[تنبيه - عنوان غير مناسب : ]الى المشرفين مشكله فى الداتا بيز

عندى مشكله فى الداتا بيز وهو

Alert: SQL 2012 DB Average Wait Time is too high

Average Wait Time monitor for SQL 2012 DB

The average amount of wait time (milliseconds) for each lock request that resulted in a wait. Based on the DB engine counter, has identical values for all databases on a SQL instance

Causes

Lock requests occurred

.

Resolutions

Use system DMVs such as sys.dm_exec_requests or SQL Server Management Studio Activity Monitor to identify processes which are blocking other processes.

وكل شويه الرساله دى تيجى ومحتاج حل ضرورى أرجو المساعده