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.

ModuleJobNameOccursFrequency
DatabaseCollectorDBFilePropertiesGet-GOLDEvery 1 dayEvery 2 Hours between 00:00:00 and 23:59:59
DatabaseCollectorDBFilePropertiesGet-SILVEREvery 1 dayEvery 12 Hours between 00:00:00 and 23:59:59
DatabaseCollectorDBFilePropertiesGet-BRONZEEvery 1 dayOnce 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.
DatabaseCollectorDBScript-GOLDEvery 1 dayOnce at 01:00:00
DatabaseCollectorDBScript-SILVEREvery 3 daysOnce at 09:00:00
DatabaseCollectorDBScript-BRONZEEvery 4 weeks on SundayOnce at 07:00:00
DatabaseCollectorDBUsersGet-GOLDEvery 1 dayOnce at 01:00:00
DatabaseCollectorDBUsersGet-SILVEREvery 1 week on Monday, Wednesday, FridayOnce at 03:00:00
DatabaseCollectorDBUsersGet-BRONZEEvery 1 week on SundayOnce at 03:00:00
DatabaseCollectorIndexStats-GOLDEvery 1 week on SaturdayOnce at 07:00:00
DatabaseCollectorIndexStats-SILVEREvery 2 weeks on SundayOnce at 07:00:00
DatabaseCollectorIndexStats-BRONZEEvery 4 weeks on SundayOnce at 07:00:00
DatabaseCollectorSysObjectsGet-GOLDEvery 1 dayOnce at 00:00:00
DatabaseCollectorSysObjectsGet-SILVEREvery 1 week on SundayOnce at 03:00:00
DatabaseCollectorSysObjectsGet-BRONZEEvery 2 weeks on SundayOnce at 00:00:00
DatabaseCollectorTableColumns-GOLDEvery 1 dayEvery 6 Hours between 00:00:00 and 23:59:59
DatabaseCollectorTableColumns-SILVEREvery 1 dayOnce at 21:00:00
DatabaseCollectorTableColumns-BRONZEEvery 1 week on SaturdayOnce at 21:00:00
DatabaseCollectorTableProperties-GOLDEvery 1 dayOnce at 03:00:00
DatabaseCollectorTableProperties-SILVEREvery 1 week on SundayOnce at 03:00:00
DatabaseCollectorTableProperties-BRONZEDay 1 of every 1 monthsOnce at 00:00:00
DriveCollectorDriveSpace-GOLDEvery 1 dayEvery 15 Minutes between 00:00:00 and 23:59:59
DriveCollectorDriveSpace-SILVEREvery 1 dayEvery 4 Hours between 00:00:00 and 23:59:59
DriveCollectorDriveSpace-BRONZEEvery 1 dayEvery 12 Hours between 00:00:00 and 23:59:59
SecurityCollectorADGroupsGetEvery 1 week on SundayOnce at 03:00:00
SecurityCollectorLoginsGet-GOLDEvery 1 dayEvery 6 Hours between 00:00:00 and 23:59:59
SecurityCollectorLoginsGet-SILVEREvery 1 dayOnce at 05:00:00
SecurityCollectorLoginsGet-BRONZEEvery 1 week on SundayOnce at 03:00:00
ServerCollectorOSDetailsGet-GOLDEvery 1 dayEvery 30 Minutes between 00:00:00 and 23:59:59
ServerCollectorOSDetailsGet-SILVEREvery 1 dayEvery 4 Hours between 07:00:00 and 16:00:59
ServerCollectorOSDetailsGet-BRONZEEvery 1 dayOnce at 11:00:00
ServerCollectorServerInfoGet-GOLDEvery 1 dayOnce at 00:00:00
ServerCollectorServerInfoGet-SILVEREvery 3 daysOnce at 04:00:00
ServerCollectorServerInfoGet-BRONZEEvery 1 week on SundayOnce at 03:00:00
ServerCollectorServicePropertiesGet-GOLDEvery 1 dayEvery 15 Minutes between 00:00:00 and 23:59:59
ServerCollectorServicePropertiesGet-SILVEREvery 1 dayEvery 6 Hours between 00:00:00 and 23:59:59
ServerCollectorServicePropertiesGet-BRONZEEvery 1 dayEvery 12 Hours between 00:00:00 and 23:59:59
ServerCollectorSMBShare-GOLDEvery 1 dayOnce at 01:00:00
ServerCollectorSMBShare-SILVEREvery 1 week on SaturdayOnce at 02:00:00
ServerCollectorSMBShare-BRONZEDay 1 of every 1 monthsOnce at 00:00:00
SQL ServerCollectorErrorLog-GOLDEvery 1 dayEvery 12 Hours between 00:00:00 and 23:59:59
SQL ServerCollectorErrorLog-SILVEREvery 1 dayOnce at 23:00:00
SQL ServerCollectorErrorLog-BRONZEEvery 1 week on SundayEvery 48 Hours between 00:00:00 and 23:59:59
SQL ServerCollectorInstanceConfigGet-GOLDEvery 1 dayEvery 15 Minutes between 00:00:00 and 23:59:59
SQL ServerCollectorInstanceConfigGet-SILVEREvery 1 dayEvery 1 Hours between 00:00:00 and 23:59:59
SQL ServerCollectorInstanceConfigGet-BRONZEEvery 1 dayEvery 12 Hours between 00:00:00 and 23:59:59
SQL ServerCollectorSQLJobScript-GOLDEvery 1 dayOnce at 01:00:00
SQL ServerCollectorSQLJobScript-SILVEREvery 3 daysOnce at 09:00:00
SQL ServerCollectorSQLJobScript-BRONZEEvery 4 weeks on SundayOnce at 07:00:00
SQL ServerCollectorWaitStatsGet-GOLDEvery 1 dayEvery 30 Minutes between 00:00:00 and 23:59:59
SQL ServerCollectorWaitStatsGet-SILVEREvery 1 dayEvery 4 Hours between 00:00:00 and 23:59:59
SQL ServerCollectorWaitStatsGet-BRONZEEvery 1 dayEvery 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: 

 

ModuleJobNameOccursFrequency
BackupAlertBackupsMissingDiff-GOLDEvery 1 dayEvery 1 Hours between 08:00:00 and 17:00:00
BackupAlertBackupsMissingDiff-SILVEREvery 1 dayEvery 6 Hours between 08:00:00 and 17:00:00
BackupAlertBackupsMissingDiff-BRONZEEvery 1 dayOnce at 11:00:00
BackupAlertBackupsMissingFull-GOLDEvery 1 dayEvery 1 Hours between 08:00:00 and 17:00:00
BackupAlertBackupsMissingFull-SILVEREvery 1 dayEvery 6 Hours between 08:00:00 and 17:00:00
BackupAlertBackupsMissingFull-BRONZEEvery 1 dayOnce at 11:00:00
BackupAlertBackupsMissingLog-GOLDEvery 1 dayEvery 15 Minutes between 00:00:00 and 23:59:59
BackupAlertBackupsMissingLog-SILVEREvery 1 dayEvery 4 Hours between 00:00:00 and 23:59:59
BackupAlertBackupsMissingLog-BRONZEEvery 1 dayEvery 12 Hours between 00:00:00 and 23:59:59
DatabaseAlertDBsNewRetired-GOLDEvery 1 dayOnce at 09:00:00
DatabaseAlertDBsNewRetired-SILVEREvery 3 daysOnce at 09:00:00
DatabaseAlertDBsNewRetired-BRONZEEvery 1 week on MondayOnce at 09:00:00
DriveAlertDriveSpace-GOLDEvery 1 dayEvery 30 Minutes between 00:00:00 and 23:59:59
DriveAlertDriveSpace-SILVEREvery 1 dayEvery 4 Hours between 07:00:00 and 16:00:59
DriveAlertDriveSpace-BRONZEEvery 1 dayOnce at 07:00:00
ReplicationAlertReplLatencyEvery 1 dayEvery 10 Minutes between 00:00:00 and 23:59:59
ServerAlertInstanceConfig-GOLDEvery 1 dayEvery 10 Minutes between 00:00:00 and 23:59:59
ServerAlertInstanceConfig-SILVEREvery 1 dayEvery 1 Hours between 00:00:00 and 23:59:59
ServerAlertInstanceConfig-BRONZEEvery 1 dayOnce at 08:00:00
ServerAlertServiceStatus-GOLDEvery 1 dayEvery 15 Minutes between 00:00:00 and 23:59:59
ServerAlertServiceStatus-SILVEREvery 1 dayEvery 4 Hours between 00:00:00 and 23:59:59
ServerAlertServiceStatus-BRONZEEvery 1 dayEvery 12 Hours between 00:00:00 and 23:59:59
SecurityAlertAdminRoleLoginNewRetired-GOLDEvery 1 dayEvery 2 Hours between 00:00:00 and 23:59:59
SecurityAlertAdminRoleLoginNewRetired-SILVEREvery 1 dayEvery 6 Hours between 00:00:00 and 23:59:59
SecurityAlertAdminRoleLoginNewRetired-BRONZEEvery 1 dayOnce at 9:00:00
SecurityAlertWeakSQLPasswordsEvery 1 week on MondayOnce at 10:00:00

Next article: Retrieving Server Information