SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Using Server Side Traces for Dynamic Performance Evaluation


Using Server Side Traces for Dynamic Performance Evaluation

Author
Message
Tommy Bollhofer
Tommy Bollhofer
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1802 Visits: 3359
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
G33kKahuna
G33kKahuna
SSC-Enthusiastic
SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)

Group: General Forum Members
Points: 154 Visits: 313
Your arrogance is unbecoming. Perhaps we should take this offline


Jacek's article was debate worthy. I believe he and I don't see eye to eye on the evaluation approach .... he did clarify his position as well.

You jumped in the middle from nowhere with a pitbull attitude. You lacked skills to support your own argument or counter mine, not to mention lack of comprehension. Like I said before you offered, I would be more than happy to debate you offline but after your response from yesterday; it would be a waste of time .... cheers
Tommy Bollhofer
Tommy Bollhofer
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1802 Visits: 3359
G33kKahuna (12/3/2009)
Your arrogance is unbecoming. Perhaps we should take this offline


Jacek's article was debate worthy. I believe he and I don't see eye to eye on the evaluation approach .... he did clarify his position as well.

You jumped in the middle from nowhere with a pitbull attitude. You lacked skills to support your own argument or counter mine, not to mention lack of comprehension. Like I said before you offered, I would be more than happy to debate you offline but after your response from yesterday; it would be a waste of time .... cheers


That was not my intention and if I insulted you in anyway, please accept my apologies. I found the article insightful and was merely trying to support the author for his contribution. Feel free to PM me offline.

Updated this post to include an example; using the information below we were able to hone in on Procedure_C; closer inspection of the execution plan in the server side trace revealed a missing index; i.e.

Object Name # of Executions Avg_Reads Avg_Writes Avg_CPU Avg_Duration Max_Duration
Procedure_A 3002 6830 0 234 1 3
Procedure_B 2925 882 0 26 0 3
Procedure_C 1835 10201 0 246 2 51

Object Name < 1 1 - 2 Seconds 3 - 5 Seconds 5 + Seconds
Procedure_B 2234 512 134 0
Procedure_A 2285 510 118 0
Procedure_C 1032 418 235 150

Tommy

Follow @sqlscribe
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search