Home Forums SQLServerCentral.com Editorials Lowering the Noise RE: Lowering the Noise

  • January 30, 2018 at 4:53 pm

    #1977983

    Steve Jones - SSC Editor - Tuesday, January 30, 2018 9:00 AM

    jmlakar 69347 - Tuesday, January 30, 2018 8:45 AM

    What I would give to see all client environments have just disk monitoring to prevent them from filling up and stopping the show...

    There are fairly simple scripts that can help here. Scan for xx space, send an email / page / net send. The other thing to do is create placeholders that give you time to respond: https://voiceofthedba.com/2014/12/01/creating-placeholder-files/

    I love this.  I use this tactic frequently in Linux environments to reserve space.  Also wrote custom login scripts such that if there was low disk space, restarting the server would clear out a file or two to get some space back to work on the system.  Not a frequent issue any longer though.