Post reply

Central Management Server Daily Script

  • June 2, 2012 at 11:49 am

    #258963

    Comments posted to this topic are about the item Central Management Server Daily Script

  • June 4, 2012 at 2:54 pm

    #1496783

    Excellent script, just had to adjust the first row to:

    WITH Waits (servername, wait_type, wait_time_s, pct, rn) AS....

    to include the columns!

    Will use this in the daily reporting!

  • June 4, 2012 at 3:25 pm

    #1496800

    ...and I guess it's

    SELECT * FROM #waitstats

    and not

    SELECT * FROM ..sysprocesses

    right? 🙂

  • June 4, 2012 at 3:59 pm

    #1496809

    So glad you found it useful! Yes, sorry sometimes when you post the scripts it doesn' print out quite right. I am in a mixed environment so sometimes I get information from my 2000 servers... hence the ..sysprocesses.

    Thanks for your reply, enjoy!

    Sandy

  • June 5, 2012 at 9:37 am

    #1497141

    What section of the code are you asking about in regards to the select * from ..sysprocesses? Sorry just want to be sure I give you the right feedback 😎

    Thanks!

    Sandy

  • May 10, 2016 at 9:27 am

    #1877857

    Thanks for the script and thanks for the updates.

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

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