Dynamics Ax - Identifying Blocks/Locks

(0) Share

Report

Posted on by Jaffar S

120

I am looking forward to implement an automatic email notification process, when such a large BLOCK(S)>>LOCK(S) happens in our Dynamics AX production system.

Also I understand that we should get notified only when the block(s) lasts for long period, not for the REGULAR blocks.

I believe following are the options we have,

· Stored procedure : SP_WHO2 - stored procedure

· SQL Stamtent : SELECT * FROM master..sysprocesses WHERE blocked <> 0

· DynamicsPERF Database (MS Tool) Jobs :

§ DYNPERF_Log_Blocks_Option1_Tracing_Start
§ DYNPERF_Log_Blocks_Option1_Tracing_Stop
§ DYNPERF_Log_Blocks_Option2_Polling
§ DYNPERF_Purge_Blocks

My questions are
1) Is there any way we can use DynamicsPERF database tool to alert us proactively if any locks/blocks occurs?
2) Should I need to write my own stored procedure / job by using the above mentioned SQL query

Either way Could someone please assist us in this regard?

Thanks

Jaffar

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Dynamics Ax - Identifying Blocks/Locks

This is a great question, apparently left unanswered by MS.