The Heart of Enterprise Management
Minion Core Enterprise is the basis for solid SQL Server management. It includes collections for Windows OS data, SQL Server information, SQL object scripts (tables, procedures, functions, views, and so forth), job scripts, indexes, replication latency, and more!
One Component of Minion Enterprise
Minion Enterprise (ME)Â bundles together all of the Minion modules:
- Minion Core
- Minion Security
- Minion Space Tracker
- Minion Backup
- Minion Reindex
- Minion CheckDB
You can purchase one or more of the Minion modules as you need them, or get the whole group as a homogenous install in Minion Enterprise.
Email us atÂ Support@MidnightDBA.comÂ to get a 90 day trial of Minion Enterprise today!
How much does Minion Core cost?
- Minion Core (also known as Minion Core Enterprise) is $750 per managed server. MC Enterprise allows you to centrally configure, manage, and report on all managed servers across your enterprise.Â Email MinionWare for a quote!
I heard xp_cmdshell is unsafe, but MC requires it. What now?
Short answer: xp_cmdshell is not unsafe. Once turned on, itâ€™s limited to system administrators by default. And we give you information on locking it down here in Seanâ€™s article:Â Security Theater.
Medium answer: Chances are, if you have a free backup and maintenance system in place thatÂ isnâ€™tÂ Minion, itâ€™s using sqlcmd steps in the SQL Agent jobs. (Weâ€™re talking about the Ola Hallengren maintenance solution, now.) This is actually not at all secure; itâ€™s turned on by default, and anyone who has rights to alter jobs can make changes to the step. See theÂ Security TheaterÂ article for more information.
Long answer: You guessed itâ€¦the long answer is theÂ Security TheaterÂ article!
Is there any training for Minion Core?
We have extensive documentation that includes full explanations, examples, and more. You can download it from our website, and it also comes embedded in the products themselves (see the Minion.HELP stored procedure). If youâ€™re a better visual learner, check out ourÂ Training pageÂ for videos that teach the concepts, and also discuss nuances and advice for configuring MR features. If you still need help after all that, feel free toÂ reach out to us.
What if I have problems? Is there support?
Absolutely. Just enter a ticket on ourÂ support site, and weâ€™ll help you out.
Whatâ€™s involved in setting up Minion Core?
System requirementsÂ for the repository are:
A default instance of SQL Server 2012 or above. (Managed instances can be SQL Server 2005 or above.)
The SQL Agent service account requires sysadmin rights on all managed SQL Server instances, and access to run system-level WMI queries on all managed servers (which can be accomplished by granting the SQL Agent service account local administrator rights on each managed server). Note: Check your companyâ€™s security policies for compliance.
The sp_configure setting xp_cmdshell may need toÂ be enabledÂ for some features.
PowerShell 2.0 or above; execution policy set to RemoteSigned.
Note: Minion CoreÂ doesnâ€™t install any objects on managed servers.
Setup:Â Run the installer on your repository server, install the license, and insertÂ the names of your managed servers to the dbo.Servers table. Thatâ€™s about it!