August 16, 2004 at 1:58 pm
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
have a look at replication alerts to warn you when the distribution agent fails.
--
Hilary Cotter
Looking for a book on SQL Server replication?
August 18, 2004 at 12:39 am
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