Foglight Cartridge for SQL Server has generated a Warning alarm for instance on host SERVERA.EXAMPLE.COM
How is the SQL cartidge is pulling this information?
DBSS - SQL Packets Error Rate (alarm group: Network)
The SQL Server instance is experiencing 1.00 packet errors per second.
The metric is a SQL Server Global Variable and can be captured from the database instance by running the following command against SQL Server:
The value returned is cumulative since SQL Server last restarted, therefore Foglight performs a delta to indicate packet errors since the previous collection. Here is a MSDN article that explains the variable.
The data is collected by the SQL Server Global Variables collection that is built into the SQL Server Cartridge.
Leave a Comment