Hi
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