DataHammer
Starting Member
USA
3 Posts |
Posted - 11/16/2012 : 14:53:55
|
I work for a SaaS company located near Albany NY. We have an environment that tends to pose lots of management challenges: Multi-node Win/Sql2008r2 EE clusters, 20+ instances each, and thousands of databases.
The challenge we are currently facing is rolling out SQL 2008r2 SP2 and CU1 to our production data centers. We've found the installer has a serious scalability flaw; it runs a Remote Discovery process (RunDiscoveryAction) once for enumeration before installation starts, then again for every sql instance. Each Remote Discovery takes 2.5 minutes, which may not sound too bad until you do the math:
((DiscoveryTime * number of Hosts) * (number of intance +1) ) * Number of Patches = Discovery Time
for us: ((2.5*5)*(22+1))*2 = 575 minutes of discovery time.
We've tested this in our lab (Win/SQL 2008r2 EE 4-node cluster with 20 instances) and found the math is correct. I've tried everything I can think of to avoid Discovery events with no luck.
Has anyone found a workaround for this?
|
|