The rule "DBSS - Long Lock Running" is not firing since SQL PI has been configured.
If SQL PI is integrated, the long running locks metric will be collected via SQL PI part. That means those metrics will be stored in the SQL PI repository and not in the Foglight repository.
Prior to the 5.7.5.10 SQL Server cartridge
As the metrics are having different sources and different objects in Foglight itself, prior to the the 5.7.5.10 SQL Server cartridge a new rule was used : "DBSS - SPI - Long Lock Running".
When SQL PI is activated, the rule "DBSS - SPI - Long Lock Running" would fire alarms for long running locks. If SQL PI was not activated the rule "DBSS - Long Lock Running" would fire the alarms.
Status (as of the 5.7.5.10 and higher SQL Server cartridges)
The "DBSS - Long Lock Running" rule works for both SQL PI and non-PI SQL Server monitoring.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center