I'm having some problem with the Email Action for the default AppInsight For SQL alert. This alert will send email whenever the I/O latency breaches the threshold.
I didn't make any changes to the email action but when the email it send over, the email doesn't displayed properly.
Here's the email I receive.
The database file "J:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\model.mdf" disk I/O latency is high <font color="red">31.266</font color> ms.<BR>
<BR>
<Strong>Database Details:</Strong>
<table border="1">
<tr>
<td>Database name: </td>
<td>model</td>
</tr>
<tr>
<td>Server: </td>
<td>spngsql302</td>
</tr>
<tr>
<td>SQL Instance Name: </td>
<td>MSSQLSERVER</td>
</tr>
<tr>
Any idea what went wrong? In the Email action, I didn't alter the message.
The database file "${N=SwisEntity;M=SqlDatabaseFileAlert.PhysicalName}" disk I/O latency is high <font color="red">${N=SwisEntity;M=SqlDatabaseFileAlert.VolumeLatencyInMilliseconds}</font color> ms.<BR>
<BR>
<Strong>Database Details:</Strong>
<table border="1">
<tr>
<td>Database name: </td>
<td>${N=SwisEntity;M=Database.SqlDatabaseAlert.DatabaseName}</td>
</tr>
<tr>
<td>Server: </td>
<td>${N=SwisEntity;M=Database.SqlServer.Node.Caption}</td>
</tr>
<tr>
<td>SQL Instance Name: </td>
<td>${N=SwisEntity;M=Database.SqlApplicationAlert.InstanceName}</td>
</tr>
<tr>
<td>Database File name & path: </td>
<td>${N=SwisEntity;M=SqlDatabaseFileAlert.PhysicalName}</td>
</tr>
<tr>
<td>IO latency in milliseconds: </td>
<td>${N=SwisEntity;M=SqlDatabaseFileAlert.VolumeLatencyInMilliseconds}</td>
</tr>
</table>