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 |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2007-06-15 : 11:09:28
|
| Hi,Having read up on the following, I was wondering if anyone could share any working experience with them. Have you used either of:1. SQL Server Agent MultiServer Management.2. SQL Server Event Forwarding.Are there any cons and pros for each? Does the former just forward failed jobs to the master server? How often are the events updated? How does it effect traffic?Many thanksDrewDrew---------------------"It's Saturday night; I've got no date, a two litre bottle of Shasta, and my all-Rush mix tape... LET'S ROCK." |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-15 : 15:22:08
|
| Traffic depends on how many servers you have, number of jobs and schedules on each server. For MultiServer Management, you schedule and run jobs from master server. |
 |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2007-06-18 : 03:28:56
|
| Have you actually used both of these?Drew---------------------"It's Saturday night; I've got no date, a two litre bottle of Shasta, and my all-Rush mix tape... LET'S ROCK." |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-18 : 16:10:34
|
| Not in prod environment. |
|
|
|
|
|
|
Centralised Monitoring