Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
Hardware health monitoring table is too big. You want to shrink the APM_HardwareItem_Detail table and reduce hardware health historical data, but want to keep your current settings for other statistics.
All SAM versions
The workaround is to modify the following stored functions in SQL Studio Manager:
1. Navigate to SQL studio manager and expand DB > Programmability > Functions > Scalar-Valued Functions
2. Replace the following line:
select @DataRetainDays = CurrentValue from Settings where SettingID = 'SWNetPerfMon-Settings-Retain Detail'
SET @DataRetainDays= <requested/>
Ensure the new value in apm_GetOrionRetainDetailDate < apm_GetOrionRetainHourlyDate < apm_GetOrionRetainDailyDate