Minion Enterprise (15)

This is a very specific alert, for a specific situation: - You have Minion Enterprise up and running - ME is monitoring, among other things, an AlwaysOn Availability Group - That AG has read-intent configured for a secondary node - You REALLY need to know when read-intent isn't working for a particular database. If this describes your situation, welcome to this alert! 1. Fill out everything in the CONFIG section just below, 2. save this script to the repo server, 3. make sure you've got mail set up on your repo server, and 4. schedule a job to run your newly edited script! Written by Jen McCown, Jen@MidnightDBA.com, 8/31/2018. For use with Minion Enterprise. http://MinionWare.net   Read More

This procedure works with Minion Enterprise. This procedure reports on service accounts for active servers. Note that we can only report on those servers that are marked IsActive in dbo.Servers.   Read More

Purpose: This procedure works with Minion Enterprise. This procedure looks for instances of operating system power plans that are not "High Performance"; if any are found, it emails the list to the DBA team (or returns the list to the screen). CustomAlert.PowerPlan is meant to be run from one or more scheduled jobs, or run for ad hoc use using @EmailAlert = 0. Error log searches are custom; for more information see the "Collector.ServersOSDetail" table, and the articles: OS Details module - https://minionware.desk.com/customer/portal/articles/2376680 How to configure alerting - https://minionware.desk.com/customer/en/portal/articles/2853611-how-to-configure-alerting?b_id=8420   Read More

This procedure works with Minion Enterprise. It looks for instances of found error log searches; if any are found, it emails the list to the DBA team (as defined in dbo.EmailNotification). CustomAlert.ErrorLogSearch is meant to be run from one or more scheduled jobs. Error log searches are custom; for more information see the "dbo.ErrorLogSearch" table, and the articles: Error log search module - https://minionware.desk.com/customer/en/portal/articles/2378789-error-log-search-module?b_id=8420 How to configure alerting - https://minionware.desk.com/customer/en/portal/articles/2853611-how-to-configure-alerting?b_id=8420   Read More

Many databases rely on login account credentials (Username, Password & SID) being identical between servers (ie. Availability Groups and databases involved in Dev-Test-Prod migrations).  This alert will check that all logins associated with Availability Group databases are identical between the AG servers. Additional logins can be added to allow for monitoring non-AG logins that need to be identical between servers (ie. logins associated with Dev/Test/QA servers).   Read More

Generates an email alert when an Availability Group database replica's Sync State is not Synchronized, the Sync Health is not Healthy, or the Database Replication is Suspended.   Read More

Generates an email alert when database files are within a specified number of growth events (Available Growth Events Threshold) of the Max File Size or Disk Volume Size Limit. The number of Available Growth Events is determined using: [Disk Free Space] / [Autogrowth Increment Size] = [Available Growth Events] or ([Max File Size] - [Current File Size]) / [Autogrowth Increment Size] = [Available Growth Events]   Read More

Sends an email notification/alert 30 days before a sql certificate (ie Backup Encryption Certificate) expires.  Individual certificate alerts can be deferred by adding an entry to the CustomAlert.CertDefer table.  Default job runs daily at 9am, sending an email summary of the certificates set to expire within the next month.   Read More

This is a simple INSERT procedure for the dbo.Servers table. DBAs can use it to insert server information; I made sure to require just the 4 parameters you'd need to successfully make an instance part of Minion Enterprise. The rest of the parameters are optional. All of the columns in dbo.Servers that AREN'T represented by parameters, are collected by the system. AND I put in a bonus check on the dbo.EmailNotification table, because that's kind of important (for alerting), and can be overlooked.   Read More

Query to tell which DBs (as a percentage) do the most reads and writes on each server.

Query to tell which DBs take up the most space on each server. Gives a percentage of their size based off of all the DBs on the box. This is not the size of the data, but the size of the files as this comes from the DB Properties table. So this is the size of the DBs on disk.   Read More

This code is for creating enterprise-level dynamic tuning settings based off of the resources each server has.  It reads the Servers table and based off of the amount of RAM and CPU available it will insert the appropriate tuning settings for backups.  This is only an example so you should change the settings for your needs, and you can use any criteria available in the system.  This code only looks at RAM and CPU, but you can look at OS, or VM vs physical, or server location, etc.  Use anything at your disposal within the system. The point is that you will be able to set this up for hundreds of servers in just a few queries and get your entire shop in order.  You can even set this up as a job to re-evaluate the resources on each server in case they've changed, and have it automatically set the tuning settings based off of the new resources.  This is an excellent way to keep your backups running like a top without having to babysit it yourself.   Read More

This code shows you how often a SQL acct password has been rotated on each server it's on. This is an exciting query because now you can see across your entire environment whether a SQL acct is having its password changed and you can easily setup different thresholds for each server and acct if you like. Of course you have to have the data to support this.  It requires that ME be collecting data for at least one password change cycle.  After that, you'll have the history of how often it's been changed. You can even use this to setup an alert to tell you when it's not happening, or when 2 boxes are out of sync, or even send an email to your helpdesk system to open up a case.   Read More

See how often an AD acct's password has been changed.  This is useful when you have an audit situation and you need to rotate your password every few weeks.  You could use this to audit which accts haven't had their passwords rotated on schedule, or even to remind you that it's time.   Read More

This is adhoc code that you can run to get a list of all sa users in your entire shop.  It expands the AD groups and sub-groups to give you a final list of users who have sa and it then adds in the SQL and Windows users. Finally, it has 2 queries: 1.  Shows a count of sa users per box in your shop. 2.  Show you a list of everyone who has sa on each server and whether they're getting it via SQL, Windows, or AD Group. Depending on how big your environment is it may take this code a few minutes to run.  And you can do anything else you want with this data.  You're free to turn it into an alert or a report if you like, though you may want to stage the data for a report. Also, remember that the AD data by default is only collected once/week so if you've got a fast-changing environment, you may want to run the AD collection and the login collection right before running this so you have the latest data.  Most of the time that shouldn't be necessary though.   Read More