Replication Tracking replication latency, and alert when it passes your custom threshold. – Alert on Database Changes Query and alert on any database property change. – Retain history of database creation and deletion. Database Create/Drop History – Routine Database Object Scripting Script out all database objects regularly in to retrieve schema – changes. For example, if someone makes a change to a stored procedure on the wrong server, you have a record of the script before the change. Centralized SID Server Keep a central list of SQL Server logins, and their assigned ID number (“SID”). – Standardizing login SIDs across your enterprise prevents the common users” issue. “orphaned Database User Reporting Centralized user account reporting. – Windows Group Expansion See exactly who has what permissions via all Windows groups, even with – nested groups. Disk Tracking and Alerting Report on the disk space usage across your enterprise, and define alert – thresholds for specific disks. Integrates with free modules Minion Enterprise integrates very easily with the free modules, Minion – Backup and Minion Reindex. For more information on these, additional features and settings, and How To topics, see the sections “How To” Topics, and Moving Parts. Quick Start System Requirements and Installation Minion Enterprise has a few system requirements (note that these do not all apply to the managed servers). We do recommend that you install on a dedicated instance of SQL Server: a modest virtual machine is the ideal scenario. System requirements: SQL Server 2012 or above. (Managed instances can be SQL Server 2005 or above.) The sp_configure setting xp_cmdshell must be enabled*. PowerShell 2.0 or execution policy set to RemoteSigned. * xp_cmdshell can be turned on and off with the database PreCode / PostCode options, to help comply with security policies. System recommendations: Install on a dedicated server, or dedicated virtual machine 6-8GB memory 4 CPU 200-300 GB of disk Windows 2012 R2 To install Minion Enterprise:
Replication Tracking – replication latency, and alert when it passes your custom threshold. Alert on Database Changes – Query and alert on any database property change. Database Create/Drop History – Retain history of database creation and deletion. Routine Database Object Scripting – Script out all database objects regularly in to retrieve schema changes. For example, if someone makes a change to a stored procedure on the wrong server, you have a record of the script before the change. Centralized SID Server – Keep a central list of SQL Server logins, and their assigned ID number (“SID”). Standardizing login SIDs across your enterprise prevents the common “orphaned users” issue. Database User Reporting – Centralized user account reporting. Windows Group Expansion – See exactly who has what permissions via all Windows groups, even with nested groups. Disk Tracking and Alerting – Report on the disk space usage across your enterprise, and define alert thresholds for specific disks. Integrates with free modules – Minion Enterprise integrates very easily with the free modules, Minion Backup and Minion Reindex. For more information on these, additional features and settings, and How To topics, see the sections “How To” Topics, and Moving Parts. Quick Start System Requirements and Installation Minion Enterprise has a few system requirements (note that these do not all apply to the managed servers). We do recommend that you install on a dedicated instance of SQL Server: a modest virtual machine is the ideal scenario. System requirements: SQL Server 2012 or above. (Managed instances can be SQL Server 2005 or above.) The sp_configure setting xp_cmdshell must be enabled*. PowerShell 2.0 or execution policy set to RemoteSigned. * xp_cmdshell can be turned on and off with the database PreCode / PostCode options, to help comply with security policies. System recommendations: Install on a dedicated server, or dedicated virtual machine 6-8GB memory 4 CPU 200-300 GB of disk Windows 2012 R2 To install Minion Enterprise: