Post reply

Query and replication monitoring

  • August 16, 2004 at 1:58 pm

    #164705

    hello,

    I'd like to monitor queries on my SQL server i.e. if any query goes over 30 mins i;d like to be notified. Can this be done easily? Also, we're replicating a db between a two SQL 2000 servers and sometimes the transaction replication fails. Can SQL server notify the DBA automatically when any replication agents fail? Help is appreciated.

     

    thanks

     

  • August 17, 2004 at 5:49 am

    #519304

    have a look at replication alerts to warn you when the distribution agent fails.

    --

    Hilary Cotter

    Looking for a book on SQL Server replication?

    http://www.nwsu.com/0974973602.html

  • August 18, 2004 at 12:39 am

    #519493

    SQL Profiler has a template for long running queries. You could run profiler and have it log to a table on the server. Then have a SQL Agent that emails you rows whenever there are some. Not exactly neat, or easy, but a way. It stops of course as soon as Profiler is stopped.

    Julian Kuiters
    juliankuiters.id.au

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

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