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 |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2005-08-04 : 01:24:38
|
| Hi all, Just wondering have any of u guys used SQL multi server admin for sql agents? Am looking into it, and wondering have anyone used it, and is there any issue or ideas or best prac to use it...:)Thanks |
|
|
schuhtl
Posting Yak Master
102 Posts |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-08-09 : 03:36:24
|
| I know setup is easy, but what I really after is when you are using it, not just for standard stuff like backup and maintenance routines that u can set for all databases, if say u got different database requirement and setting, or even jobs, will u think using that is better then going to each server and set it? I can see the point where it keeps a copy on a central spot, but its pulling the instruction every mins (can u change that by the way?) and it will just increase the network traffic?am just planning to see should I use it for other tasks, or just for backup and things like index rebuild....what others thinks? |
 |
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2005-08-11 : 08:06:00
|
| Multi server administration was not designed for managing database settings... it was designed to manage agent jobs from a central location. The jobs and steps within the jobs you choose to use is entirely up to you, you can be as creative as you want! You can change the polling interval to something other than the default (60 seconds). The best way is via Enterprise Manager on your "master" server. Below is a good link that steps you through the process and I personally have not seen any negative network impact by using the default and I have between 15-20 target servers.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_automaem_26ib.asp |
|
|
|
|
|
|
Multi Server Admin