Home Forums SQL Server 2008 SQL Server 2008 Administration Doing healthcheck on 40+ SQL Servers centrally. RE: Doing healthcheck on 40+ SQL Servers centrally.

  • July 9, 2014 at 4:01 am

    #1727973

    Joy Smith San (7/8/2014)

    Thanks.

    Do you have any such sample powershell script by any chance ?

    Kindly share if you have any handy.

    If you do a simple google search Joy, I am sure you will find plenty of powershell/SQL Health check scripts however they are not a "one size fits all" and you will have to have at least some rudimentary knowledge of Powershell as no doubt you will have to tweak the scripts to run on your environments. I would also advise downloading the excellent SQLBlitz[/url] stored proc from BrentOzar.com

    Rgds,

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]