Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jon3k
Starting Member
49 Posts |
 Posted - 2004-05-05 : 12:28:27
|
| Monitoring SQL ReplicationI'm having some problems with replication. Its being replicated from the published on the internal network to a publisher in the DMZ then offsite via a VPN tunnel to the subscriber. The replication has failed for a number of reasons, mainly vpn connectivity dropping but most recently because the SQL service on the publisher "hung up" and had to be restarted.Whats the best way to monitor replication and be alerted for a problem/failure?I'm setting up BigBrother (bb4.com) right now on the linux monitoring server (rrdtools via cacti) and I found a plugin on deadcat to monitor quite a few things on an MS SQL machine - but how is this normally done? how would microsoft recommend it done? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-05 : 13:00:14
|
| You can monitor replication from the replication system tables. But there is other information that goes into Event Logs, PerfMon counters and the like that you can’t get to from the tables.The above information was given to us from a MS contact. For now, we've setup notifications on all of the replication jobs to alert on failures.Tara |
 |
|
|
jon3k
Starting Member
49 Posts |
Posted - 2004-05-05 : 14:41:15
|
| How can I configure performance monitor to send emails? Are there any command line utilities available? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-05 : 14:45:44
|
| typeperf.exe is available in the Resource Kit. I prefer the typeperf in XP though. You can pull it from an XP machine and copy it to a Win2k machine. I'm not sure if that violates any licensing though. What would you want to e-mail? PerfMon allows alerts but not directly with e-mail. You'd probably write the alert to the AppLog, then have a custom job scan the AppLog for certain things and e-mail when it finds it.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-05 : 19:22:19
|
| If you go to perfmon on your server, you can set up alerts on any of the counters. You go to alerts, setup what counters you want to monitor, and what you want the limits to be. If you want an email to be sent, you could run an xp_sendmail alerting you that the counter has gone over it's limit. This would be setup in the command line argument. Just an idea. I don't know that I would do it. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jon3k
Starting Member
49 Posts |
Posted - 2004-05-06 : 17:01:12
|
| Well, I'm checking out ipmonitor (ipmonitor.com) but for now, I just want to use SQL Operators to monitor the replication and send me an email notification if there's a problem (Under Agent properties, notifications). Now, I've got a Publisher on the private network and the Publisher is in a DMZ. Can I setup notifications for failure of the distribution on the Publisher? I've already got the SQL Server Agent running under a domain account on the publisher, and Outlook 2003 is installed with a mail profile. I've got the Publisher registered w/ EM but when I try and test my operator using the account I setup, I get the message:"Error: 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent properties dialog."Now I'm guessing its because I don't have a mail profile setup for the account that SQL Server Agent runs as on the Publisher in the DMZ, since I'm trying to set this up on the Publisher on the private network. Should I just install outlook on the SQL server in the dmz and have it use an SMTP profile to relay mail off the email gateway in the DMZ back to the exchange server on the internal network? |
|
|
|
jon3k
Starting Member
49 Posts |
Posted - 2004-05-06 : 20:45:50
|
| Nevermind - got it all figured out, thanks for all your help! |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-06 : 22:39:24
|
| How did you resolve it?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
SQL Server Monitoring