Last modified on 11th September 2018

Retention periods

Since version 1.0.6827.x it is possible to set retention period per snapshot type in [dbo].[sql_perf_mon_config_snapshot_type] :

SELECT [snapshot_type_id]
      ,[snapshot_type_desc]
      ,[snapshot_retention_days]
  FROM [SQLWATCH].[dbo].[sql_perf_mon_config_snapshot_type]
snapshot_type_id snapshot_type_desc snapshot_retention_days
1 Performance 7
2 Disk Utilisation 365

You can set retention days to your liking.