OraFAQ Forum: Server Administration » Here is How to Identify Performance Bottleneck

Home » RDBMS Server » Server Administration » Here is How to Identify Performance Bottleneck

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Here is How to Identify Performance Bottleneck [message #246716]

Thu, 21 June 2007 12:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Start by reading the following URL:
http://www.perfvision.com/papers/Sampling.pdf
You get get a copy of the Active Session History (ASH) code here:
http://www.perfvision.com/ash.php

Moderators,
Can/should this information be added to 1 or more of the STICKY posts?

HTH & YMMV!

Report message to a moderator

Re: Here is How to Identify Performance Bottleneck [message #246781 is a reply to message #246716]

Thu, 21 June 2007 23:19

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Added to the previous sticky.
Have a look if you agree.

Regards
Michel

Report message to a moderator

Re: Here is How to Identify Performance Bottleneck [message #246782 is a reply to message #246716]

Thu, 21 June 2007 23:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Thanks Michel.

Report message to a moderator

Re: Here is How to Identify Performance Bottleneck [message #246927 is a reply to message #246781]

Fri, 22 June 2007 08:39

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

It may get lost in there as the title is Server Administration Posting Guidelines.
Then again, with some of the titles we normally see here, you never know what the content might be Wink

Report message to a moderator

Re: Here is How to Identify Performance Bottleneck [message #246931 is a reply to message #246927]

Fri, 22 June 2007 09:17

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You're right.
Maybe a new sticky is better.

Waiting for other's opinion.

Regards
Michel

Report message to a moderator

Re: Here is How to Identify Performance Bottleneck [message #246961 is a reply to message #246716]

Fri, 22 June 2007 11:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Given the fact that most folks totally ignore the STICKY posts, I could argue that it does not matter where it resides.

My initial goal was to keep this information easily found so new posters could be directed to it when they report general performance problems.

However, relatively speaking this information would have "better" visibility as a stand alone topic; so I vote for a seperate STICKY.

Report message to a moderator

Re: Here is How to Identify Performance Bottleneck [message #246966 is a reply to message #246961]

Fri, 22 June 2007 11:21

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Done.

If you have any comment...

Regards
Michel

Report message to a moderator

Re: Here is How to Identify Performance Bottleneck [message #247020 is a reply to message #246716]

Fri, 22 June 2007 19:31

ebrian
Messages: 2794
Registered: April 2006

Senior Member

NICE...thanks for sharing anacedent !!

Report message to a moderator

Re: Here is How to Identify Performance Bottleneck [message #247090 is a reply to message #246927]

Sat, 23 June 2007 15:32

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

joy_division wrote on Fri, 22 June 2007 15:39

It may get lost in there as the title is Server Administration Posting Guidelines.
Then again, with some of the titles we normally see here, you never know what the content might be Wink

Well, perhaps renaming the topic to "PLZ URGNT HLP!!!!!!!!!!!!!!!" would attract more attention.

Report message to a moderator

Previous Topic:	NO LISTENER
Next Topic:	How can I set HR account unlimited?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 17:37:51 CST 2025