info@techdevops.com | 437-991-3573 | Data Tier Services
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server, Clusters, Always On, Migrations, ERP, Performance & Cloud



Alerting on Deadlocks with SQL Server Management Pack in Microsoft Systems Center Operations Manager
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
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