Post reply

Automating SQL Server Patching for 10000+ Instances.

  • November 4, 2014 at 10:48 am

    #312233

    Team,

    Is there any Best Practice, 3rd Party Tool for Automating SQL Server Patching for around 10000+ SQL instances.

    It is very difficult to do the same manually because each server will consume atleast 1-2 hours and if this is completely done manually then n number of people might be required for accomplishing this task which doesn't looks feasible at all.

    Any help would be highly appreciated.

    With Thanks,

    Satnam

  • November 4, 2014 at 12:54 pm

    #1756605

    WSUS?

    http://sequelqb.blogspot.com/2010/11/implementing-wsus-for-sql-server-patch.html

  • November 5, 2014 at 6:39 am

    #1756740

    Ok.... you've got my curiosity up. 10,000+ instances? Why so many?

    And considering that the max number of instances you can have per machine is 50, that would mean a minimum of 200 machines and the Windows and SQL Server licensing that goes with all that. How much are you paying for licensing? I could be wrong but it sounds like at least 4 Million in USD.

    Or was this just an interview question?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • November 5, 2014 at 6:46 am

    #1756743

    Could they be the free Express Edition?

  • November 5, 2014 at 8:15 am

    #1756762

    Jeff Moden (11/5/2014)

    Ok.... you've got my curiosity up. 10,000+ instances? Why so many?

    And considering that the max number of instances you can have per machine is 50, that would mean a minimum of 200 machines and the Windows and SQL Server licensing that goes with all that. How much are you paying for licensing? I could be wrong but it sounds like at least 4 Million in USD.

    Or was this just an interview question?

    Maybe a volume licence deal of somekind, either way, it sounds like there would benefits to be gained from a consolidation exercise

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • November 5, 2014 at 9:18 am

    #1756769

    The customer is a fortune 5 company in the US, IT budget itself is a 100 million + USD per year and therefore the number of instances is pretty high.

    With Thanks,

    Satnam

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply