In the SQL Server PI repository, the pass_instance_dim table shows deleted PI agents still being monitored. The monitored column value for the host and instance name is set to 1.
The monitored column in the pass_instance_key table is set ON (1) and OFF (0) using the Administration panel in the database agent when the SQL PI extension is enabled or disabled for a database agent.
monitored=0)monitored=1By design rows are not removed from the pass_instance_dim table because SQL PI maintains history for up to two years. The pass_instance_dim table contains a key field which links server hostnames and instance names to SQL PI data stored in the PI repository Database agents can be recreated and have historical data available to view until it is purged from the repository.
Note: The value of monitored being on or off should only have an impact when for sizing issues when calculating SQL PI limits and typically only affects systems when they reach 300 registered SQL Server agents monitored concurrently in the same PI repository database or when dealing with JVM memory sizing calculations.
WORKAROUND
Run an update query in the PI repository to turn off the SQL PI monitored value for each deleted SQL Server agents.
update pass_instance_dim set monitored = 0 where instance_key in (...);
Fill in the "in" clause parenthesis the keys of the deleted agents.
STATUS
This defect has been logged as ISMTS-408 and will be fixed by Product Management in a future release of the SQL Server cartridge.