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

  • January 30, 2018 at 4:51 pm

    #1977982

    jmlakar 69347 - Tuesday, January 30, 2018 9:54 AM

    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/

    Thanks Steve! I also love the SysInternals suite. Just wishing these same issues which have been solved for decades were not so common.

    I've typically held onto another volume that I can expand my primary into if needed.  I also had a script that I should have saved that would mount the other volume and symlink back to the original.  I can't tell you how many times that saved me to be able to just resize on the fly to whatever the admin would allow me to.  This of course was all because I was afforded a secondary volume that was the same size of my primary volume.