Environment

• SQL Server Version: SQL Server 2017 (RTM-CU31-GDR) (KB5068402) - 14.0.3515.1 (X64)
• Windows Version: Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor)
• Component: Lite
• Performance Monitor Version: 1.2.0

Describe the Bug

PerfMonLite reports long-running CDC sessions as being a problem, even though they are a normal edge case of a long-running thing that's actually OK.

Steps to Reproduce

1. Set up CDC on 1 table
2. Create the required CDC Agent Jobs
3. run them and leave them running for hours/days (as you should)

Expected Behavior

PerfMon ignores CDC sessions.

Actual Behavior

Got loads (1 per 5 mins) of tray warnings about the same CDC session running for a long time.

Error Messages

none, just the tray warning message about long-running sessions

Screenshots

Additional Context

• Did this work before? If so, what changed? No idea, first time I saw this warning, even though I was running 1.1.0 for hours.
• Are there any relevant SQL Server configuration settings? CDC + Agent jobs + CDC WAIT FOR command (see screenshot above)
• Is SQL Server Agent running? (Full Edition only) Yup, but Lite.
• Are you monitoring Azure SQL DB, Azure MI, or AWS RDS? no

IMPORTANT: If you're going to contribute code, please read the contributing guide first.