Minion Enterprise (15)

Layout:
Showing 1-15 of 15
  • 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 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 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
    47 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 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 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
  • Thumb Get all users with sa
    This is adhoc code that you can run to get a list of all sa users in your entire shop.     Read More
    Sean McCown
    • 8uploads
    • 0questions
    • 0answers
    28 downloads Details