Results 1 to 11 of 11
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Heartbeat report

    I have searched high and low but can find no answer and I imagine it is because I am looking in the wrong place.

    I have a Windows Server 2003 running SQL Server 2000 with a SAN drive for data storage and backup. The server is running 3 x 33Gb drives, a mirrored pair and a spare and is fast running out of space. Back up has to be done a remote server with spare capacity and transaction logs kept locally. This is not an ideal situation but a remedial/interim solution prior to upgrade.

    I am for ever logging in via Remote Desktop Connection during the day and in the evening just to check the status of the drive containing the Transaction Log back up to ensure it does not fill to capacity. If it reached that point I am doing a shrink but this is happening during work hours.

    At last the question. Is there a function/method that I can use to monitor the Drive space that emails/ reports to an HTML /Sounds a Klaxon when ever it gets to being dangerously close to full that saves me having to log in all the time? I have Solarwinds network monitor but the guy who is the guru is on long term sick[gggrrr]
    Jerry

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Heartbeat report

    Apparently our outside consultants have some kind of monitoring software on our systems, but it doesn't talk to us, just them. And they never seem to raise the red flag when someone decides of upload 2GB of stuff to the document server...

    I know that a web server with ASP can generate email. I wonder whether a VBScript that runs on a schedule (e.g., AT job) could sniff the disk space (using FileSystemObject) and depending on the results automate the same COM object to send you an email?

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Heartbeat report

    Funny you should mention scripts. I was playing with a DTS package that uses the WMI core library on a virtual server I have on my removable disk but I am loathed to use it on live until such time I have spoken to the network/server guys later this morning.

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>I got chased out of the server "bunker" earlier because they had heard I had been tweaking things <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    Jerry

  4. #4
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,573
    Thanks
    5
    Thanked 1,057 Times in 926 Posts
    Joe

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Heartbeat report

    Wow, thanks for all the links, I shall spend a little while trawling through <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Heartbeat report

    >The server is running 3 x 33Gb drives, a mirrored pair and a spare

    You are enforcing redundancy by running RAID 1. Stupid question, but have you thought of switching to RAID 5 - on the basis that it takes up less space? (You already have sufficient disks.) Or does "I" refer to a corporate incarnation (where changes in hardware policy transpire glacially) - with the RAID 5 switch being regarded as a policy issue?

    HTH
    Gre

  7. #7
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Heartbeat report

    How about Servers Alive! http://www.freedownloadscenter.com/Network...vers_Alive.html

    It's made to monitor just this sort of thing.

  8. #8
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Heartbeat report

    Howdy

    Sorry "I" was part of the collective..I am not part of the corporate server team just the apps guy acting as thorn in their side...so changes are thin and have to be justified with change requests in triplicate...there tends to be a "Paah, memory is so cheap these days just chuck in another 100Gigs" <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Jerry

  9. #9
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Heartbeat report

    Jim

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Jerry

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newark, New Jersey, USA
    Posts
    999
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Heartbeat report

    I monitor 10 windows and 2 linux servers here with Nagios. Its an open source application (free) that runs on linux. Its monitors cpu, memory, drive space, ping, http, ftp, mail, etc.
    Mike Wolfman
    Jack of all, Master of none
    Bow before me, for I am root.
    <IMG SRC=http://www.wopr.com/w3tfiles/112673-wolfsig.jpg>

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Cairns, Queensland, Australia
    Posts
    885
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Heartbeat report

    Hi Jerry,

    As of yesterday I started "playing" with Spiceworks. I don't have an opinion to express as yet but it has already picked up that one of my PCs is running with less than 25% free space. <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>I already knew that and have good reasons for it.

    It is also <img src=/S/free.gif border=0 alt=free width=30 height=15>
    Granville

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •