G33kKahuna (12/2/2009)
G33kKahuna - Is it your position that server side trace information offers no value in troubleshooting performance issues? What “fantasy world” are you living in?
Tommy,
Which part of my response said server side trace is bad? infact the wait types I mentioned can be captured only on the server side ...
Sounds like you are suggesting that avg read, write and cpu are the only server side performance indicators .... looks like you got a lot to catchup on SQL Server performance tuning bud ... :hehe:
Look up Andew Kelly, Paul Randel, Jimmy May and Linchi Shea articles
JacekO, I would have calibrated SQL Wait & Waiting stats for autogrows but you seem to prefer your approach ... fair enough and peace.
G33kKahuna - We are talking in circles...I merely supported the analysis of server side trace data as a tool to troubleshoot performance issues; not the end all be all. Your arrogance is unbecoming. Perhaps we should take this offline.
Tommy
Follow @sqlscribe