Post reply

Database monitoring

  • June 17, 2004 at 6:31 am

    #162773

    I need to be able to monitor acitivity on a Sql Server 2000 DB that is on a different network than I am on. Any suggestions?

    Thanks, Scott

  • June 17, 2004 at 7:05 am

    #510818

    Are you able to access those databases?

  • June 17, 2004 at 7:18 am

    #510823

    And what kind of monitoring do you need? Have you looked at Profiler?

  • June 17, 2004 at 8:43 am

    #510861

    I cannot access those databases from the network I'm on.

    I just want to do general performance monitoring. But I want to do it real-time. I don't think Profiler will help me real-time.

  • June 17, 2004 at 9:40 am

    #510881

    When you said, general performance monitoring, do you want to watch, any dead lock, number of active transactions, cpu, ram useage, etc?

    Also since it is on a  different network and assume you can not open a port for IIS and watching the server remotely?

    If that is the case, it is really hard for real-time monitoring. I once made prototype sql monitoring system via email by using exchange server. Basically, you can send query to run DTS packages/job/proc/dynamic query and give the result back through email. Due to security reason, I had to create a ticket to run the query and get the Unique ticket id and by using that ticket, I can send a specific sql tasks and theorically, you can do anything you want but not really recommandable.

    Let me know what specific things that you want to monitor and I or any other folks have some idea and give it to you.

  • June 18, 2004 at 9:42 am

    #511071

    We had 1 SQL had same thing. What I do is write up some sql to monitor deadlock, blocking, ... and run as a SQL job on the remote server. It send out Email when pre-set condiftion met.

Viewing 6 posts - 1 through 5 (of 5 total)

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