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 22.214.171.124 SQL Server cartridge
As the metrics are having different sources and different objects in Foglight itself, prior to the the 126.96.36.199 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 188.8.131.52 and higher SQL Server cartridges)
The "DBSS - Long Lock Running" rule works for both SQL PI and non-PI SQL Server monitoring.