Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQLServerCentral.com » Editorials » The Next Frontier of Performance...
Add to briefcase
11 posts, Page 1 of 2
12»»

The Next Frontier of Performance Troubleshooting Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Tony Davis
Posted Saturday, May 02, 2009 1:14 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: Administrators
Last Login: Wednesday, May 08, 2013 10:31 AM
Points: 511, Visits: 945
Comments posted to this topic are about the item The Next Frontier of Performance Troubleshooting
Post #708961
Indianrock
Posted Sunday, May 03, 2009 7:52 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 5:25 AM
Points: 564, Visits: 1,457
Is this only for sql 2008?

This tool demonstrates Response time analysis at the session or statement level including waitstats using the new Extended Events infrastructure in SQL Server 2008


Post #709051
Jeff Moden
Posted Sunday, May 03, 2009 9:24 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 32,906, Visits: 26,792
I think it very ironic that people continue to find better ways to find performance problems caused by poorly written code that should never have made it to the database to begin with. Nearly as ironic, I make my living by fixing that which I hate the most. Long live spaghetti code!

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #709059
GSquared
Posted Monday, May 04, 2009 7:58 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 15,442, Visits: 9,571
I've usually found two things are more than adequate to tell me exactly what's slowing things down. The Activity Monitor in Management Studio, and a server-side trace on all scripts/procs/etc.

One tells me what's going on right this moment, well enough to debug, and the other tells me what's been going on for the last week or so.

And Jeff is totally correct, that it's MUCH easier to make sure the code is well-written in the first place. He's also right that whole careers can be made off of fixing junk code that's already in use and never should have been.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #709388
Indianrock
Posted Monday, May 04, 2009 8:48 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 5:25 AM
Points: 564, Visits: 1,457
Still waiting to hear if this is only for sql 2008. Some of us are dealing with sql generated by objects, not stored procedures. Glenn Berry has a nice list of diagnostic queries at http:\\glenberrysqlperformance.spaces.live.com ( those for sql 2005 are down the page a bit ).

But again, the ones that report on stored procedures do almost nothing in our environment since procs are hardly used.


Post #709423
Steve Jones - SSC Editor
Posted Monday, May 04, 2009 9:05 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:26 PM
Points: 31,425, Visits: 13,738
Tony is off today, but he should respond tomorrow.

I agree we want to write code correctly the first time, but there will always be bad code. Always new people, always people learning and making mistakes.

Making it easy for them spot things is always handy.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #709440
Steve Jones - SSC Editor
Posted Monday, May 04, 2009 9:07 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:26 PM
Points: 31,425, Visits: 13,738
The tool is from the SQLCAT team at Microsoft, and if you follow the link (http://sqlcat.codeplex.com/Wiki/View.aspx?title=ExtendedEventsWaitstats), it says for 2008.

If you have more questions, I'd contact the SQLCAT team.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #709442
Jeff Moden
Posted Monday, May 04, 2009 11:18 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 32,906, Visits: 26,792
Indianrock (5/4/2009)
But again, the ones that report on stored procedures do almost nothing in our environment since procs are hardly used.


That's why I start performance monitoring at the "Batch Completion" level.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #709543
GilaMonster
Posted Monday, May 04, 2009 11:20 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722, Visits: 29,977
Indianrock (5/4/2009)
Still waiting to hear if this is only for sql 2008.


Extended events are new in SQL 2008.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #709545
Indianrock
Posted Monday, May 04, 2009 12:14 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 5:25 AM
Points: 564, Visits: 1,457
GilaMonster (5/4/2009)
Indianrock (5/4/2009)
Still waiting to hear if this is only for sql 2008.


Extended events are new in SQL 2008.


Thanks. This makes me wonder what the percentages are as far as world-wide users of sql 2005 versus sql 2008. On the other hand, it's at least one good reason to upgrade. I don't expect our company to even consider upgrading until next year some time, due to the economy.


Post #709602
« Prev Topic | Next Topic »

Add to briefcase
11 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.