Is it anyway possible to create a SQL Job for monitoring blocking on SQL Instance, if the blocking are still happening after some interval of time?
We are using SCOM Monitoring tool to monitor events from the event viewer and generated alert on the basis of this that. Kindly guide as to what can I do generate an event in case of blocking persists for more than a minute.
I tried enabling the blocking process threshold and created blocking, but I see no event either in event viewer or in SQL Error Logs. We are using Sql Server 2008 R2 Enterprise.
Thanks in advance.