Thursday, June 25, 2009

Performance Tuning – Overview

The first and foremost question which comes in mind is what is the need for tuning? This is the world of fast food, fast bikes, fast music, fast cars, in short fast everything, then why not fast database as well? Today everyone is in some kind of a race, and to achieve his/her goal one needs to win that race. To win a race one needs to either run fastest of all or make the horse (or car) run fastest of all. Performance tuning helps applications to run faster.

Is tuning all about running the application faster? No. Time is of course one of the major things we achieve during (and after) tuning, but tuning also means achieving the output in best possible way in least possible time while utilizing optimal resources.

Tuning has many aspects which include (but not restricted to)

1. Database design: This is the first and most important but most ignored part of tuning. Poor database design often results in poor database performance as well.
2. Application tuning: It is a well known fact that the application performance can be improved by 80% just by writing efficient SQLs.
3. Memory tuning: database buffers should be properly sized. As far as possible, use of automated parameters is advised. Pinning large or frequently used objects may also help.
4. Disk I/O tuning: Data files should be properly sized and stored to provide optimum disk throughput. Also, disk sorts, FTS, row chaining, etc need to be checked.
5. Eliminating database contention: Database locks, latches and wait events should be watched carefully.
6. Operating System tuning: OS CPU, I/O and memory usage should also be monitored.

If one takes care of all the above aspects, the good performance of the application will be guaranteed.

In next segment we will check the tools available for tuning purpose.

14 comments:

Anonymous said...

Howdy! Someone in my Myspace group shared this website with us so I came
to take a look. I'm definitely loving the information. I'm bookmarking and will be tweeting this to my
followers! Terrific blog and fantastic design and style.


Here is my blog post ... search engine optimisation melbourne

Anonymous said...

I think that is among the such a lot important information for
me. And i'm happy reading your article. However should statement on some basic things, The web site taste is ideal, the articles is actually nice : D. Excellent activity, cheers

my webpage online damenschuhe

Anonymous said...

Quality articles or reviews is the important
to interest the users to pay a quick visit the website, that's what this website is providing.

My site ... super alpha reseller hosting

Anonymous said...

WOW just what I was looking for. Came here by searching for leistungen der gesetzlichen krankenversicherung

Here is my site; private krankenkasse basistarif

Anonymous said...

If some one wants to be updated with hottest technologies then he must be
visit this web page and be up to date every day.

Feel free to surf to my blog ... hawaii big island vacations

Anonymous said...

Very energetic article, I liked that a lot. Will there be a part 2?


My web site; student loans private

Anonymous said...

Somebody essentially help to make significantly articles I might state.
This is the first time I frequented your web page and to this point?
I surprised with the research you made to make this particular publish
amazing. Fantastic process!

Here is my web blog: how to earn money with clickbank

Anonymous said...

It's the best time to make a few plans for the longer term and it is time to be happy. I've read
this submit and if I could I desire to recommend you few attention-grabbing issues or advice.
Perhaps you can write subsequent articles regarding
this article. I want to read more issues approximately it!


Feel free to visit my site: The Kenya Alliance Of Resident Associations

Anonymous said...

I all the time used to study post in news papers but now as I am a user of web therefore from
now I am using net for articles or reviews, thanks to web.


My weblog ... website search optimization

Anonymous said...

After I originally commented I appear to have
clicked on the -Notify me when new comments are added- checkbox and
from now on each time a comment is added I recieve four emails with the same comment.
Is there a means you can remove me from that service? Thanks a lot!



Also visit my page - kredite ohne schufa und einkommensnachweis

Anonymous said...

There is certainly apparently a great deal of knowledge within this regard.
I think some excellent ideas for services.

My site: best all inclusive family resorts ()

Anonymous said...

Does your site have a contact page? I'm having a tough time locating
it but, I'd like to send you an email. I've got some creative ideas for your blog
you might be interested in hearing. Either way, great
blog and I look forward to seeing it expand over time.


My web-site Alpha Fuel reviews (http://btd5.org/)

Anonymous said...

This will definitely help a newbie or beginner criminal case cheat game developers.

The process of the classic elements. This wrestling game initiates new struggle submission scheme where
in the cell phone from your PC. It would perk my head what is happening in just few
preset songs.

my site: criminal case cheats

Anonymous said...

e cig, e cig reviews, electronic cigarette reviews, ecigarette, electronic cigarettes, e cigarette