[BUG] Lite - Formatted grid columns sort by text instead of value

[dphugo]

Component

Lite

Performance Monitor Version

2.1.0

SQL Server Version

SQL Server 2022 (RTM-CU16)

Windows Version

Windows 11 23H2

Describe the Bug

A few of the grid columns are formatted with ms or s, which makes sense. For instance "1.2 s" or "924 ms", etc.
However when clicking on the column name to sort these columns, it sorts it by text interpretation instead of the value, which is an incorrect sort order.

The columns I've picked up where is is an issue:
Server Tab-> Collection Health -> Health Summary

• Avg Duration

Server Tab -> Collection Health -> Healthy Summary -> Collection History (Double Click on Row)

• Duration
• SQL Duration
• DuckDB Duration

Server Tab -> Collection Health -> Collection Log

• Duration
• SQL (ms)
• DuckDB (ms)

Steps to Reproduce

1. Open Server tab
2. Click on "Collection Health" tab.
3. Click on "Health Summary" tab.
4. Click on "Avg Duration" column to sort.
5. Sort is incorrect, as it sorts by the formatted text.

Expected Behavior

It should sort all formatted columns correctly based on actual numeric value.

Actual Behavior

It sorts all formatted columns based on the formatted text value.

Error Messages / Log Output

No errors are generated.

Screenshots

Additional Context

I've only used the Lite edition. The same issue might be within the Full edition.

I'm happy to implement a fix for this if that's OK?