Let’s take five minutes and get our entire enterprise in order.
Extract the MinionEnterprise2.2Setup.exe and run it on your repository server. Give the installation “localhost” for the instance name.
2. Configure email for alerts
Connect to the repo server and insert your alert email:
USE Minion; GO INSERT INTO dbo.EmailNotification ( EmailAddress, Comment ) SELECT 'Your@Email.com' AS EmailAddress, 'DBA' AS Comment;
3. Configure servers
Insert (or bulk insert) server to the repo:
INSERT INTO dbo.Servers ( ServerName, ServiceLevel, Port, IsSQL, IsActive ) VALUES ( 'Prod01', 'Gold', 1433, 1, 1), ( 'Prod02', 'Gold', 1433, 1, 1), ( 'Prod03', 'Silver', 1433, 1, 1), ( 'QA01', 'Silver', 1433, 1, 1), ( 'Dev01', 'Bronze', 1433, 1, 1), ( 'Dev02', 'Bronze', 1433, 1, 1);
4. You’re done!
Jobs will begin kicking off to collect data within the next hour. Some jobs run hourly, some run daily or weekly or monthly. You’ll start getting tables full of useful data, and email alerts that actually mean something.
If you’re impatient to start getting some of the good stuff right away, kick off the CollectorServerInfo% jobs manually. These populate data in the dbo.Servers table, which other jobs need to run. You’ll start noticing data in the Collector.DBProperties, Collector.ServiceProperties, and Collector.DriveSpace tables first, as these jobs run most frequently.
While ME is taking care of your shop for you, you can get to know it better with the online documentation!
Download our FREE maintenance modules below: