Post reply

Multi-Server Scripting

  • September 22, 2009 at 6:45 pm

    #210032

    My team is managing just under 190 SQL instances of three flavors, 2000, 2005, and 2008.

    Each morning we like to poll each instance to obtain DB size information, backup info, job failures, etc. The only way I've been able to accomplish this is by using a foreach container in SSIS, then I have three branches, 1 each if @@version equates to 2000, 2005, and 2008, and then i pull the data into our centralized admin server.

    Has anyone come across a solution to do this via t-sql? I know we can run multi-server queries through SSMS, but i'd rather not have that manual intervention.

    Just looking for any other suggestions from people.

    We'd prefer not to get another third party tool.

    Thanks,

    Steve

  • September 22, 2009 at 7:37 pm

    #1057239

    You could so it with linked servers, but I have to ask what the issue with SSIS is, that is by far the best method..

    CEWII

  • September 23, 2009 at 2:06 am

    #1057330

    Yeah I'm with Elliot on that.

    The only other way I can think of that you could do it is by writing a .NET app to poll them. You could even do it multi-threaded so it polls many at once.

    But, if it ain't broke, don't fix it. So what's broke? 😀

    Atlantis Interactive - SQL Server Tools
    My blog[/url]
    Why I wrote a sql query analyzer clone

  • September 23, 2009 at 8:41 am

    #1057560

    Without bringing in other langauges such as PowerShell or C#, you're probably doing the best you can, especially when you consider that gathering information on 2008 is really different from gathering it on 2000.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • September 23, 2009 at 2:47 pm

    #1057764

    Thanks everyone for the responses. Nothing is broke, I was merely looking to see if anyone polls their servers any differently. Always looking for new, and potentially better, ways to manager our systems...

    Regards,

    Steve

  • September 23, 2009 at 2:59 pm

    #1057774

    S.K. (9/23/2009)

    Thanks everyone for the responses. Nothing is broke, I was merely looking to see if anyone polls their servers any differently. Always looking for new, and potentially better, ways to manager our systems...

    Regards,

    Steve

    I've seen it done with PERL, but I didn't much like it. It is a preference thing. I really like the ways you can do it in SSIS..

    CEWII

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

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