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 Category | Schedule | Data Retention | Alerts | Health Checks |
|---|---|---|---|---|
| Discover Instances | Daily | N/A | No | No |
| Discover Topology (databases, data files, servers, drives) | Sub job - runs at beginning of capacity and configuration jobs | N/A | No | No |
| Availability & Responsiveness at instance level | Every 30 seconds | Kept for 24 hours | Yes | Yes |
| Availability & Responsiveness at database level | Every 5 minutes | Kept every 5 minutes for 24 hours | Yes | Yes |
| Configuration data | Daily | Current Values | No | Yes |
| Capacity Data: Disk total space, disk free space, database data size, database log size, data file size, log file size | Hourly | Current Values | Yes | Yes |
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.