Post reply

Monitor an application connection

  • June 8, 2006 at 12:35 pm

    #97088

    I have a couple of applications that connect to the database (2000) on frequent intervals (every 1 to 2 sec.). I want to monitor whether or not these applications are running by determining whether they are connecting to the database. I've got a profiler template that does the trick, but I don't want to have profiler up all the time. Does anyone have any suggestions on how I could monitor these applications?

    Thanks

  • June 8, 2006 at 12:41 pm

    #642645

    You could poll sysprocesses every so often, but the only way of getting a 'push' from those events is with a trace, I think. But for a snapshot, it would work fine.

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

Viewing 2 posts - 1 through 1 (of 1 total)

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