Hi good morning Thwack,
I have a request from one of our DBA's for alerting to be setup for deadlocks / blocking and SQL Server error log whose severity is greater than 16. I can't seem to figure out how best to set this up.
Has anyone out there setup alerting for deadlocks and SQL Server error log that could help out?
On a side note why aren't there more alerting for the AppInsight for SQL components?
Thank you
When you edit the application by clicking the "Edit Application Monitor" link in the top right of the SQL server application you are viewing, you can define the threshold for "Deadlocks/sec". When that threshold is exceeded, the default out-of-the-box "Alert me when a component goes into warning or critical state" alert.
Changing it where I described above will change the threshold only for this particular instance. Modifying this value from within the template itself will change this value for all instances of SQL. You can modify the template by going to [Settings -> SAM Settings -> Manage Templates] as seen below.
that would be nice. AppInsight is appreciated for the detailed information however we feel it is to strict for the configuration and the alerting.
Displaying the Error log is good, be able to alert on some error is better 
