June 2, 2012 at 11:49 am
Comments posted to this topic are about the item Central Management Server Daily Script
June 4, 2012 at 2:54 pm
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
...and I guess it's
SELECT * FROM #waitstats
SELECT * FROM ..sysprocesses
June 4, 2012 at 3:59 pm
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!
June 5, 2012 at 9:37 am
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 😎
May 10, 2016 at 9:27 am
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