info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance



Alerting on Deadlocks with SQL Server Management Pack in Microsoft Systems Center Operations Manager
by BF (Principal Consultant; Architecture; Engineering)
2015-08-03







Problem:

Checking MSSQL: Select * from sys.messages where message_id = 1205
--shows field is_event_logged equals 0


Solution:

In MSSQL: Exec sp_altermessage 1205, 'WITH_LOG', 'true'

*If a message is written to the Windows Application log, it is also written to the Database Engine Error Log file.


Image 1: (Systems Center...configuration is ok here)






Image 2: (Systems Center...configuration is ok here)






Image 3: (Systems Center...configuration is ok here)






Image 4: (MSSQL...configuration needed to be modified here)






Resources:

sys.messages