Minion Enterprise gathers data from all managed servers into tables in the Collector schema. The moment you configure an instance in the dbo.Servers table, Minion Enterprise begins pulling in a stunning array of data: service status, disk space, backups, database properties, logins and users, table sizes, and on and on. All of this data from across your enterprise is now updated and available in one central repository, ready for alerts, and reporting, and planning for the future.
Collections
Like we said in the Quick Tour of the Modules, Minion Enterprise gathers data from all managed servers into tables in the Collector schema. It does this via a set of jobs that come pre-configured when you install ME.
Note that each collector is divided into one or more jobs based on SLA. GOLD level servers receive all of the collctions; and, collections run the most frequently for GOLD level servers. Collectors run less frequently for SILVER servers, and less frequently (or not at all) for BRONZE.
Module | JobName | Occurs | Frequency |
Database | CollectorDBFilePropertiesGet-GOLD | Every 1 day | Every 2 Hours between 00:00:00 and 23:59:59 |
Database | CollectorDBFilePropertiesGet-SILVER | Every 1 day | Every 12 Hours between 00:00:00 and 23:59:59 |
Database | CollectorDBFilePropertiesGet-BRONZE | Every 1 day | Once at 00:00:00 |
Database | CollectorDBPropertiesGet-GOLD | Every 1 day | Every 30 minutes between 12:00:00 AM and 11:59:59 PM. |
Database | CollectorDBPropertiesGet-SILVER | Every 1 day | Every 3 Hours between 12:15:00 AM and 11:55:00 PM. |
Database | CollectorDBPropertiesGet-BRONZE | Every 1 day | Every 12 Hours between 12:00:00 AM and 11:59:59 PM. |
Database | CollectorDBScript-GOLD | Every 1 day | Once at 01:00:00 |
Database | CollectorDBScript-SILVER | Every 3 days | Once at 09:00:00 |
Database | CollectorDBScript-BRONZE | Every 4 weeks on Sunday | Once at 07:00:00 |
Database | CollectorDBUsersGet-GOLD | Every 1 day | Once at 01:00:00 |
Database | CollectorDBUsersGet-SILVER | Every 1 week on Monday, Wednesday, Friday | Once at 03:00:00 |
Database | CollectorDBUsersGet-BRONZE | Every 1 week on Sunday | Once at 03:00:00 |
Database | CollectorIndexStats-GOLD | Every 1 week on Saturday | Once at 07:00:00 |
Database | CollectorIndexStats-SILVER | Every 2 weeks on Sunday | Once at 07:00:00 |
Database | CollectorIndexStats-BRONZE | Every 4 weeks on Sunday | Once at 07:00:00 |
Database | CollectorSysObjectsGet-GOLD | Every 1 day | Once at 00:00:00 |
Database | CollectorSysObjectsGet-SILVER | Every 1 week on Sunday | Once at 03:00:00 |
Database | CollectorSysObjectsGet-BRONZE | Every 2 weeks on Sunday | Once at 00:00:00 |
Database | CollectorTableColumns-GOLD | Every 1 day | Every 6 Hours between 00:00:00 and 23:59:59 |
Database | CollectorTableColumns-SILVER | Every 1 day | Once at 21:00:00 |
Database | CollectorTableColumns-BRONZE | Every 1 week on Saturday | Once at 21:00:00 |
Database | CollectorTableProperties-GOLD | Every 1 day | Once at 03:00:00 |
Database | CollectorTableProperties-SILVER | Every 1 week on Sunday | Once at 03:00:00 |
Database | CollectorTableProperties-BRONZE | Day 1 of every 1 months | Once at 00:00:00 |
Drive | CollectorDriveSpace-GOLD | Every 1 day | Every 15 Minutes between 00:00:00 and 23:59:59 |
Drive | CollectorDriveSpace-SILVER | Every 1 day | Every 4 Hours between 00:00:00 and 23:59:59 |
Drive | CollectorDriveSpace-BRONZE | Every 1 day | Every 12 Hours between 00:00:00 and 23:59:59 |
Security | CollectorADGroupsGet | Every 1 week on Sunday | Once at 03:00:00 |
Security | CollectorLoginsGet-GOLD | Every 1 day | Every 6 Hours between 00:00:00 and 23:59:59 |
Security | CollectorLoginsGet-SILVER | Every 1 day | Once at 05:00:00 |
Security | CollectorLoginsGet-BRONZE | Every 1 week on Sunday | Once at 03:00:00 |
Server | CollectorOSDetailsGet-GOLD | Every 1 day | Every 30 Minutes between 00:00:00 and 23:59:59 |
Server | CollectorOSDetailsGet-SILVER | Every 1 day | Every 4 Hours between 07:00:00 and 16:00:59 |
Server | CollectorOSDetailsGet-BRONZE | Every 1 day | Once at 11:00:00 |
Server | CollectorServerInfoGet-GOLD | Every 1 day | Once at 00:00:00 |
Server | CollectorServerInfoGet-SILVER | Every 3 days | Once at 04:00:00 |
Server | CollectorServerInfoGet-BRONZE | Every 1 week on Sunday | Once at 03:00:00 |
Server | CollectorServicePropertiesGet-GOLD | Every 1 day | Every 15 Minutes between 00:00:00 and 23:59:59 |
Server | CollectorServicePropertiesGet-SILVER | Every 1 day | Every 6 Hours between 00:00:00 and 23:59:59 |
Server | CollectorServicePropertiesGet-BRONZE | Every 1 day | Every 12 Hours between 00:00:00 and 23:59:59 |
Server | CollectorSMBShare-GOLD | Every 1 day | Once at 01:00:00 |
Server | CollectorSMBShare-SILVER | Every 1 week on Saturday | Once at 02:00:00 |
Server | CollectorSMBShare-BRONZE | Day 1 of every 1 months | Once at 00:00:00 |
SQL Server | CollectorErrorLog-GOLD | Every 1 day | Every 12 Hours between 00:00:00 and 23:59:59 |
SQL Server | CollectorErrorLog-SILVER | Every 1 day | Once at 23:00:00 |
SQL Server | CollectorErrorLog-BRONZE | Every 1 week on Sunday | Every 48 Hours between 00:00:00 and 23:59:59 |
SQL Server | CollectorInstanceConfigGet-GOLD | Every 1 day | Every 15 Minutes between 00:00:00 and 23:59:59 |
SQL Server | CollectorInstanceConfigGet-SILVER | Every 1 day | Every 1 Hours between 00:00:00 and 23:59:59 |
SQL Server | CollectorInstanceConfigGet-BRONZE | Every 1 day | Every 12 Hours between 00:00:00 and 23:59:59 |
SQL Server | CollectorSQLJobScript-GOLD | Every 1 day | Once at 01:00:00 |
SQL Server | CollectorSQLJobScript-SILVER | Every 3 days | Once at 09:00:00 |
SQL Server | CollectorSQLJobScript-BRONZE | Every 4 weeks on Sunday | Once at 07:00:00 |
SQL Server | CollectorWaitStatsGet-GOLD | Every 1 day | Every 30 Minutes between 00:00:00 and 23:59:59 |
SQL Server | CollectorWaitStatsGet-SILVER | Every 1 day | Every 4 Hours between 00:00:00 and 23:59:59 |
SQL Server | CollectorWaitStatsGet-BRONZE | Every 1 day | Every 12 Hours between 00:00:00 and 23:59:59 |
Alerts
As you become familiar with Minion Enterprise, we recommend you adjust existing alerts, and create new alerts, to suit your particular enterprise. ME is meant to be highly customizable, which is why all of the collected data is stored accessibly in SQL Server tables.
For more information, see How To: Configure Alerting.
Here are the alerts that ship automatically with Minion Enterprise, and their schedules:
Module | JobName | Occurs | Frequency |
Backup | AlertBackupsMissingDiff-GOLD | Every 1 day | Every 1 Hours between 08:00:00 and 17:00:00 |
Backup | AlertBackupsMissingDiff-SILVER | Every 1 day | Every 6 Hours between 08:00:00 and 17:00:00 |
Backup | AlertBackupsMissingDiff-BRONZE | Every 1 day | Once at 11:00:00 |
Backup | AlertBackupsMissingFull-GOLD | Every 1 day | Every 1 Hours between 08:00:00 and 17:00:00 |
Backup | AlertBackupsMissingFull-SILVER | Every 1 day | Every 6 Hours between 08:00:00 and 17:00:00 |
Backup | AlertBackupsMissingFull-BRONZE | Every 1 day | Once at 11:00:00 |
Backup | AlertBackupsMissingLog-GOLD | Every 1 day | Every 15 Minutes between 00:00:00 and 23:59:59 |
Backup | AlertBackupsMissingLog-SILVER | Every 1 day | Every 4 Hours between 00:00:00 and 23:59:59 |
Backup | AlertBackupsMissingLog-BRONZE | Every 1 day | Every 12 Hours between 00:00:00 and 23:59:59 |
Database | AlertDBsNewRetired-GOLD | Every 1 day | Once at 09:00:00 |
Database | AlertDBsNewRetired-SILVER | Every 3 days | Once at 09:00:00 |
Database | AlertDBsNewRetired-BRONZE | Every 1 week on Monday | Once at 09:00:00 |
Drive | AlertDriveSpace-GOLD | Every 1 day | Every 30 Minutes between 00:00:00 and 23:59:59 |
Drive | AlertDriveSpace-SILVER | Every 1 day | Every 4 Hours between 07:00:00 and 16:00:59 |
Drive | AlertDriveSpace-BRONZE | Every 1 day | Once at 07:00:00 |
Replication | AlertReplLatency | Every 1 day | Every 10 Minutes between 00:00:00 and 23:59:59 |
Server | AlertInstanceConfig-GOLD | Every 1 day | Every 10 Minutes between 00:00:00 and 23:59:59 |
Server | AlertInstanceConfig-SILVER | Every 1 day | Every 1 Hours between 00:00:00 and 23:59:59 |
Server | AlertInstanceConfig-BRONZE | Every 1 day | Once at 08:00:00 |
Server | AlertServiceStatus-GOLD | Every 1 day | Every 15 Minutes between 00:00:00 and 23:59:59 |
Server | AlertServiceStatus-SILVER | Every 1 day | Every 4 Hours between 00:00:00 and 23:59:59 |
Server | AlertServiceStatus-BRONZE | Every 1 day | Every 12 Hours between 00:00:00 and 23:59:59 |
Security | AlertAdminRoleLoginNewRetired-GOLD | Every 1 day | Every 2 Hours between 00:00:00 and 23:59:59 |
Security | AlertAdminRoleLoginNewRetired-SILVER | Every 1 day | Every 6 Hours between 00:00:00 and 23:59:59 |
Security | AlertAdminRoleLoginNewRetired-BRONZE | Every 1 day | Once at 9:00:00 |
Security | AlertWeakSQLPasswords | Every 1 week on Monday | Once at 10:00:00 |