Post reply

looking for an application that will monitor and alert on lack of data received by querying SQL DB ?

  • December 10, 2010 at 7:23 am

    #229510

    For example i use a system that collects packets of information on socket 10001.

    09:00 - 17:00 i would see 1,000,000 packets on 10001 with parameter A or B

    17:00 - 09:00 i would see 100,000 packets on 10001 with parameter A or B

    Am looking an application that would allow me to monitor 09:00 - 17:00 and alert me if packet type A was not received.

    i.e so in theory the traffic flow looks ok but packet type A has dropped off.

    Had a look at PRTG products but i dont think this app will let me do what i need.

    I guess what i need is an app that can connect to SQL , run an SP , save the results in the apps store and then report / alert on X ?

    Taking an easier example, say i needed to alert on NO packet received on 10001 over a time span , how is this possible ?

    Note the tables used contain:

    ----------------------------------

    PARENT TABLE

    Parent_Unique_ID (PK)

    Last_Packet_Received_Date_Time

    Last_Packet_Socket

    ----------------------------------

    |

    |

    ^

    ----------------------------------

    PACKET_TABLE

    Packet_ID (PK)

    Packet_Object_ID (FK)

    Packet_Data

    ----------------------------------

    Maybe im going the wrong way about this , any advice ?

    These are just a couple of examples that would be helpful. The idea is to try and build more proactive alerting based on reduced data flow for example. We have developers but this would mean writing bespoke service on demand. Was looking for something that would allow a DBA to create a "watching" service , email alerts.

    Thank you.

    Scott

  • December 10, 2010 at 8:22 am

    #1261067

    easiest (and cheapest) approach might be to just put a sql agent job together to query the database, save the data and email yourself the results?

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

  • December 10, 2010 at 8:29 am

    #1261069

    Building on torpkev's comment, this is too specific for a third party application - this is something you have to do by yourself.

    By the way, no need to bother developers with this - monitoring the database is a DBA job so, just design/write/test/deploy the script and be happy. This is not rocket science. 🙂

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • December 13, 2010 at 4:52 am

    #1261617

    thanks for the reply guys, just the push in the correct direction i was looking for.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply