After instalation PerformanceMonitorInstaller-1.3.0 with success can´t find table config.retention_settings

[josejulioduarte]

Which component is your question about?

Full Dashboard

Performance Monitor Version

1.3.0

Is your question about how it works, or the results?

Setup / installation

What's your question?

Hello Erik
After instalation PerformanceMonitorInstaller-1.3.0 with success i can´t find table config.retention_settings in database PerformanceMonitor.

in readme.md
Data Retention

Default: 30 days (configurable per table in config.retention_settings

USE [PerformanceMonitor]
GO
DECLARE @SchemaName SYSNAME = 'config';
DECLARE @objectname SYSNAME = 'retention_setting';

IF EXISTS
(
SELECT 1
FROM sys.objects o
JOIN sys.schemas s ON o.schema_id = s.schema_id
WHERE s.name = @SchemaName
AND o.name = @objectname
)
BEGIN
PRINT 'Object exists';
END
ELSE
BEGIN
PRINT 'Object does not exist';
END
GO

Result:
Object does not exist

Additional Context

No response

[erikdarlingdata]

Thanks for reporting this! There's no bug in the installer — the table config.retention_settings doesn't exist and never has. That was an error in the README.

Retention is configured via the retention_days column in config.collection_schedule. Each collector row has its own retention value (default 30 days). You can view and adjust it like:

SELECT
    collector_name,
    retention_days
FROM config.collection_schedule
ORDER BY
    collector_name;

I've fixed the README to reference the correct table/column. Closing this one out — let me know if you have any other questions!