Community Zone (24)

Layout:
Showing 1-20 of 24
  • Thumb CheckDB Corruption Alert
    To email an alert if any allocation errors or consistency errors were found in the last (@LastNDays) days. For use    Read More
    Jennifer McCown
    • 9uploads
    • 0questions
    • 0answers
    33 downloads Details
  • Thumb Alert - AlwaysOn AG Read-Intent Not Working
    This is a very specific alert, for a specific situation: - You have Minion Enterprise up and running - ME is    Read More
    Jennifer McCown
    • 9uploads
    • 0questions
    • 0answers
    27 downloads Details
  • Thumb Service Accounts Report
    This procedure works with Minion Enterprise. This procedure reports on service accounts for active servers. Note that we can only    Read More
    Jennifer McCown
    • 9uploads
    • 0questions
    • 0answers
    16 downloads Details
  • Thumb Which server is my DB on?
    Find out "What server is/servers are this db on?" For use with Minion Enterprise, http://MinionWare.net/Enterprise    Read More
    Jennifer McCown
    • 9uploads
    • 0questions
    • 0answers
    9 downloads Details
  • Thumb Power Plan Alert SP
    Purpose: This procedure works with Minion Enterprise. This procedure looks for instances of operating system power plans that are    Read More
    Jennifer McCown
    • 9uploads
    • 0questions
    • 0answers
    7 downloads Details
  • Thumb Alert on found Error Log Search terms
    This procedure works with Minion Enterprise. It looks for instances of found error log searches; if any are found, it    Read More
    Jennifer McCown
    • 9uploads
    • 0questions
    • 0answers
    10 downloads Details
  • Thumb Login Comparison
    Many databases rely on login account credentials (Username, Password & SID) being identical between servers (ie. Availability Groups and databases    Read More
    Jamie Wick
    • 6uploads
    • 0questions
    • 0answers
    31 downloads Details
  • Thumb Backup ResourceDB
    ResourceDB doesn't backup like the other DBs.  Currently, in MB 1.2, you have to backup resourcedb with a postcode.  This    Read More
    Sean McCown
    • 8uploads
    • 0questions
    • 0answers
    27 downloads Details
  • Thumb View Latest Backup
    Another take on the "last backup set" view. This pulls all databases on the  server, so every database will show up    Read More
    Jennifer McCown
    • 9uploads
    • 0questions
    • 0answers
    28 downloads Details
  • Thumb Availability Group Database Sync Status Alert
    Generates an email alert when an Availability Group database replica's Sync State is not Synchronized, the Sync Health is not Healthy,    Read More
    Jamie Wick
    • 6uploads
    • 0questions
    • 0answers
    45 downloads Details
  • Thumb Available File Growth Events Alert
    Generates an email alert when database files are within a specified number of growth events (Available Growth Events Threshold) of the Max    Read More
    Jamie Wick
    • 6uploads
    • 0questions
    • 0answers
    21 downloads Details
  • Thumb Report/Alert on missing backups in last N days/hours
    The function returns a list of databases that do not have an (undeleted) backup of type @BackupType within the last @BackupThresholdDays    Read More
    Jennifer McCown
    • 9uploads
    • 0questions
    • 0answers
    48 downloads Details
  • Thumb Certificate Expiration Alert
    Sends an email notification/alert 30 days before a sql certificate (ie Backup Encryption Certificate) expires.  Individual certificate alerts can be    Read More
    Jamie Wick
    • 6uploads
    • 0questions
    • 0answers
    22 downloads Details
  • Thumb dbo.ServersInsert procedure
    This is a simple INSERT procedure for the dbo.Servers table. DBAs can use it to insert server information; I made sure    Read More
    Jennifer McCown
    • 9uploads
    • 0questions
    • 0answers
    18 downloads Details
  • Thumb Restore Multiple DBs
    This is for all v.1 versions of Minion Backup. It creates restore statements for multiple DBs. To use this just populate the    Read More
    Sean McCown
    • 8uploads
    • 0questions
    • 0answers
    26 downloads Details
  • Thumb Find Percent of Reads and Writes per DB on each Server
    Query to tell which DBs (as a percentage) do the most reads and writes on each server.
    Sean McCown
    • 8uploads
    • 0questions
    • 0answers
    17 downloads Details
  • Thumb Find Biggest DBs on Each Server
    Query to tell which DBs take up the most space on each server. Gives a percentage of their size based off    Read More
    Sean McCown
    • 8uploads
    • 0questions
    • 0answers
    16 downloads Details
  • Thumb Setup Dynamic Tuning for Backups for the Enterprise
    This code is for creating enterprise-level dynamic tuning settings based off of the resources each server has.  It reads the    Read More
    Sean McCown
    • 8uploads
    • 0questions
    • 0answers
    35 downloads Details
  • Thumb SQL Acct Password Rotation
    This code shows you how often a SQL acct password has been rotated on each server it's on. This is an    Read More
    Sean McCown
    • 8uploads
    • 0questions
    • 0answers
    7 downloads Details
  • Thumb AD Acct Password Rotation
    See how often an AD acct's password has been changed.  This is useful when you have an audit situation and    Read More
    Sean McCown
    • 8uploads
    • 0questions
    • 0answers
    9 downloads Details