To monitor your SQL Server instances, SQL Inventory Manager collects data on availability, responsiveness, configuration, performance, and capacity data on a specific schedule and maintains a history of the collected values for a certain amount of time. 

The following table shows you the frequency with which SQL Inventory Manager collects information and the amount of time that this information is retained. 

Data CategoryScheduleData RetentionAlertsHealth Checks
Discover InstancesDailyN/ANoNo
Discover Topology (databases, data files, servers, drives)Sub job - runs at beginning of capacity and configuration jobsN/ANoNo
Availability & Responsiveness at instance levelEvery 30 secondsKept for 24 hoursYesYes
Availability & Responsiveness at database levelEvery 5 minutesKept every 5 minutes for 24 hoursYesYes
Configuration dataDailyCurrent ValuesNoYes
Capacity Data: Disk total space, disk free space, database data size, database log size, data file size, log file sizeHourlyCurrent ValuesYesYes

Refresh collection

SQL Inventory Manager allows you to refresh these metrics at any time from the instance view. For more information about this option, please refer to Viewing instance information.

 

Need more help? Search the Idera Customer Support Portal.

  • No labels