Community Zone (24)

To email an alert if any allocation errors or consistency errors were found in the last (@LastNDays) days. For use with Minion CheckDB. I recommend you save this file to your Minion CheckDB installation folder (e.g., CheckDB1.2) and add the file name to the end of InstallOrder.txt.   Read More

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

Find out "What server is/servers are this db on?" For use with Minion Enterprise, http://MinionWare.net/Enterprise    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

ResourceDB doesn't backup like the other DBs.  Currently, in MB 1.2, you have to backup resourcedb with a postcode.  This is an update statement that adds a BatchPostCode to your system backup schedule.   Read More

Another take on the "last backup set" view. This pulls all databases on the  server, so every database will show up in the list (even if it has no backup). Gives you the latest full, diff, and log backup (if any) per database.   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

The function returns a list of databases that do not have an (undeleted) backup of type @BackupType within the last @BackupThresholdDays days (or alternately, within the last @BackupThresholdHours hours). See the code for limits and more documentation   The job uses the function to send alerts as needed.  By default, it sends an alert if: Any database does not have a full backup < 7 days old Any FULL database does not have a log backup < 1 hour old See the code for limits and more documentation.   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

This is for all v.1 versions of Minion Backup. It creates restore statements for multiple DBs. To use this just populate the #table with whatever DB names you want to restore and it looks in the Minion.BackupFiles table and build the stmts based off of the latest files in there. It takes the last full backup, the last diff and the last log. Currently though, in this version of the restore SP you have to script each backup type out separately. This isn't meant to be a complete restore solution in its current state.  It's meant to show you how to use the restore SP to build multiple restore stmts. To see an explanation of the input params of the restore SP itself, see the documentation.   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