Are there any warnings/errors in the 'Show Log' page linked from the Monitored Servers page for each server?
As SQL Monitor gets its deadlock information from the SQL error logs, and deadlocks are definitely appearing there, it suggests that the software might be having problems accessing the logs. Maybe due to a permission issue as we use remote file access to read the SQL Logs. If errors do exist we have a troubleshooting page that includes details on testing remote file access:
Another possibility - is the 1204 trace flag enabled for the servers in question?
I can't find any good information about this error online but I'd be surprised if it was related to SQL Monitor not creating deadlock alerts."Log viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null Values.. Content:"
I can't find any good information about this error online but I'd be surprised if it was related to SQL Monitor not creating deadlock alerts.
Are deadlock alerts are definitely enabled for this specific server in the Alert Settings page?
Also could we have a few details of the server in question so that I can run some tests? For example, sql server version, clustered or standalone etc.
ScottHerbert wrote:Hi Chris,
I've emailed you the logs.
Users browsing this forum: Google [Bot] and 0 guests