Wednesday, March 28, 2012

Multi Server Administration

Hi,
We are about to implement MSX across our servers, we have some 400 SQL
Servers. What is the recommended number of master servers in sites as big as
this? Is there a maximum (recommended) number of target servers you can have
per master server?
Thanks
Julian
There is no hard recommended number that I know of. But before you
implement that you may want to check out SQL Sentry at
http://www.sqlsentry.net/ first. It can save you a LOT of headaches with
trying to monitor that many servers.
Andrew J. Kelly SQL MVP
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian
|||The Quest tools for SQL Server also have multi-server execution capability.
It's similar to Query Analyzer, except that you can select as many servers
as you like to execute against. There's a freeware version too. Check out
http://www.quest.com/quest_central/s...ver/freeware/.
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian

No comments:

Post a Comment