Central Management Server Daily Script

  • Hawkeye_DBA

    SSCarpal Tunnel

    Points: 4271

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

  • G Peterson

    SSC Enthusiast

    Points: 102

    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!

  • G Peterson

    SSC Enthusiast

    Points: 102

    ...and I guess it's

    SELECT * FROM #waitstats

    and not

    SELECT * FROM ..sysprocesses

    right? 🙂

  • Hawkeye_DBA

    SSCarpal Tunnel

    Points: 4271

    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

  • Hawkeye_DBA

    SSCarpal Tunnel

    Points: 4271

    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

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script and thanks for the updates.

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

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