Central Management Server Daily Script

Question

Post reply

Central Management Server Daily Script

Hawkeye_DBA

SSCarpal Tunnel

Points: 4365
More actions
June 2, 2012 at 11:49 am

#258963

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

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

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

G Peterson SSC Enthusiast Points: 116 More actions · Answer 1

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: 116 More actions · Answer 2

...and I guess it's

SELECT * FROM #waitstats

and not

SELECT * FROM ..sysprocesses

right?

Hawkeye_DBA SSCarpal Tunnel Points: 4365 More actions · Answer 3

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: 4365 More actions · Answer 4

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 More actions · Answer 5

akljfhnlaflkj

SSC Guru

Points: 76202

May 10, 2016 at 9:27 am

#1877857

Thanks for the script and thanks for the updates.

Central Management Server Daily Script

Cookies on SQLServerCentral