Document on Database Performance Tuning

[vinaysant]

Dear Friends,

Could anyone please provide me pdfs, docs, powerpoints, on DATABASE Performance Tuning and Query Performance Tuning

For Query Performance Tuning following could be the topics of points.

The following topics are covered in this course.

• <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1">Selection of data retrieval methods
  • <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level2 lfo1">Network Issues <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level2 lfo1">Joins <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level2 lfo1">Field lists
  • Record cache
  <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1">Transaction review
  • <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level2 lfo1">What is a transaction <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level2 lfo1">Setting scope
  • Locking
  <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1">Indexes
  • <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level2 lfo1">How indexes work <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level2 lfo1">Index Brackets <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level2 lfo1">Cross reference listings
  • Index reposition
  <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1">Identifying Issues
  • <LI class=MsoNormal style="COLOR: black; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level2 lfo1">Application Profiler
  • Promon
  • VST

Please help

Thanks and Regards
Prakash

 

[Lee Curzon]

If you format that (get rid of the CSS stuff), you may get a quicker response.

 

[Lee Curzon]

Selection of data retrieval methods
* Network Issues / Joins / Field lists
* Record cache

Transaction review
* What is a transaction / Setting scope
* Locking

Indexes
* How indexes work / Index Brackets / Cross reference listings
* Index reposition

Identifying Issues
* Application Profiler
* Promon
* VST

 

[Lee Curzon]

You can download the entire document set from here:

http://www.progress.com/products/documentation/index.ssp


Knowledge base is here:

http://progress.atgnow.com/esprogress/results.do


Search those for phrases and keywords you are interested in.


Here's an example of a relavent knowledgebase entry:

KB P19806
Title: "The Top 10 Performance Tuning Tips For The Progress Database"

http://tinyurl.com/c3wj7



Powerpoints here:

http://www.progress.com/exchange/2005/technical_sessions/index.ssp


Some other, older stuff here:

http://www.peg.com/techpapers/monographs/


I leave it to you to work out which ones are specifically of interest to you.

HTH

 

[Casper]

Lee:
you're too good for this world even formatting the posts.....

vinaysant:
Most of the stuff you write about is application performance. If you want to tell more about database tuning then you also have to consider topics like:

• Shared memory
• parameters like -B, -spin, -pinshm,....
• rpb, fragmentation, scattering
• tools like protop, promon
• Type II storage area's
• APW, BIW

Look here at progresstalk, but also at peg, lots of threads are on this topic.

HTH,

Casper.

 

[Lee Curzon]

Lee:
you're too good for this world

That's what I tell everybody, but noone believes me.