March 15, 2002 at 12:00 pm
Has anyone ever used MultiServer Administration?
Are there any problems to watch out for when setting up and using MultiServer Administration for the first time?
How much additional load does this put on the network? I know this depends on the frequency of polling between the master and target servers, but a general idea will be helpful.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
March 15, 2002 at 12:42 pm
Another question comes to mind about this. Can you have a SQL Server 2000 master and SQL Server 7.0 targets?
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
March 15, 2002 at 1:40 pm
Used it as a test, but it didn't seem to add much for me. Also, it's not too often that I have the same jobs on a server, so distributing them isn't a big deal.
However I have a small environment. Be interested to see how people with more than 10 servers use it.
Steve Jones
March 15, 2002 at 2:06 pm
If you search on alerts, automatic administration and in BOL you'll see that this seems to indicate that it is not limited to jobs but can also be applied to alerts and operators.
We have 9 SQL Servers of which 7 are nearly identical. 2 in our development environment, 2 in our staging environment, and 3 in our production environment. Backup jobs and other maintenance type jobs will be identical on all these servers.
Any one who wants to can step in and give voice if they don't think its a good idea to set up all 6 of these servers as target servers and a separate one as the master.
For us it would mean we could go look at 1 server instead of 7 to see how all our jobs are running.
We will implement this in our development environment soon. I am mainly searching for what to watch out for if any one has had a bad experience with using MultiServer Administration.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
March 15, 2002 at 9:36 pm
I only have two so I've had no need so far. Havent used it enough to know what issues might be involved if you have a problem with msdb on either one?
Andy
March 16, 2002 at 12:12 pm
We have a fairly large server farm and we'd considered using it, but there isn't a lot of material out on it and there were other more pressing issues. We were concerned about the polling and additional network load as you mentioned. What you might be able to do is set up a test environment and have someone from your network group sniff the traffic to see how much overhead is incurred.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply