• ksr39 (8/7/2012)


    Thank you all for your replies …

    Actually I have no idea about a DB or Server Health Check mean, I was expecting a script which can give me a message about the Databases status and the data status like the indexing and stats, and about the server any jobs failed if so why and if it is on a cluster on which node it’s working.

    Thank you in Advance.

    You now present a specific list of desired outputs. There are a bunch of scripts online that can do parts of what you want, but I doubt very much you will find one to cover everything. Also, you still need to know how to interpret and what you want to do with the information you get. Various third party products likely can fill the bill partially or completely. Or you can hire someone to build scripts for exactly what you want. Or get one of the books on DMVs (I think there may be a free ebook on that, maybe 2) and learn about them so you can roll your own.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service