How do we calculate the percentage improvement from tuning? Even though not always true, LIO (Logical IO/Buffer Gets) is an approximate measure of the work needed for a SQL. For example, if the LIO before tuning was 1 million, and after tuning it came down to 150K, the percentage gain can be calculated as given below:
% Improvement = (Work Eliminated/ Original Work) * 100
Original work – 1,000,000 block reads
Work after tuning – 150,000 block reads
Work eliminated = 1,000,000 – 150,000 = 850, 000
% improvement =(850, 000/1,000,000) * 100 = 85
LIO may not be the correct metric in all situations–especially for DMLs. But the formula can be applied for the metric(elapsed time, CPU etc.) you wanted to use.
k28nv9
qCmrwUHEj
Hello! I’m at work browsing your blog from my new iphone 4! Just wanted to say I love reading through your blog and look forward to all your posts! Keep up the outstanding work!
It’s really a cool and useful piece of information. I’m glad that you shared this helpful information with us. Please keep us informed like this. Thanks for sharing.
Hello! I just would like to give a huge thumbs up for the great info you have here on this post. I will be coming back to your blog for more soon.
I have not checked in here for a while since I thought it was getting boring, but the last few posts are good quality so I guess I will add you back to my everyday bloglist. You deserve it my friend 🙂
I have been exploring for a bit for any high quality articles or blog posts on this sort of area . Exploring in Yahoo I at last stumbled upon this site. Reading this info So i am happy to convey that I’ve a very good uncanny feeling I discovered exactly what I needed. I most certainly will make sure to do not forget this website and give it a look on a constant basis.
Have you ever considered creating an e-book or guest authoring on other blogs? I have a blog based on the same ideas you discuss and would love to have you share some stories/information. I know my visitors would enjoy your work. If you are even remotely interested, feel free to send me an e-mail.
Excellent weblog here! Additionally your site loads up fast! What web host are you using? Can I am getting your affiliate link on your host? I desire my site loaded up as quickly as yours lol
hello!,I really like your writing so so much! percentage we be in contact extra approximately your post on AOL? I require an expert on this space to solve my problem. Maybe that is you! Taking a look ahead to see you.
Hello! This is kind of off topic but I need some help from an established blog. Is it very hard to set up your own blog? I’m not very techincal but I can figure things out pretty fast. I’m thinking about making my own but I’m not sure where to begin. Do you have any points or suggestions? Cheers
The other day, while I was at work, my sister stole my iphone and tested to see if it can survive a thirty foot drop, just so she can be a youtube sensation. My apple ipad is now destroyed and she has 83 views. I know this is totally off topic but I had to share it with someone!
Helpful information. Lucky me I discovered your web site unintentionally, and I am stunned why this twist of fate didn’t came about in advance! I bookmarked it.
I discovered your blog site on google and check a few of your early posts. Continue to keep up the very good operate. I just additional up your RSS feed to my MSN News Reader. Seeking forward to reading more from you later on!…
I am impressed with this website , rattling I am a fan.
What Is LeanBiome?LeanBiome is a natural weight loss supplement that reverses bacterial imbalance in your gut microbiome with the help of nine science-backed lean bacteria species with Greenselect Phytosome, a caffeine-free green tea extract crafted with patented
Admiring the persistence you put into your site and in depth information you offer. It’s nice to come across a blog every once in a while that isn’t the same outdated rehashed information. Wonderful read! I’ve bookmarked your site and I’m adding your RSS feeds to my Google account.
The subsequent time I read a weblog, I hope that it doesnt disappoint me as a lot as this one. I mean, I know it was my option to learn, but I actually thought youd have one thing fascinating to say. All I hear is a bunch of whining about something that you possibly can fix in case you werent too busy looking for attention.
Greetings from Idaho! I’m bored at work so I decided to check out your site on my iphone during lunch break. I enjoy the information you provide here and can’t wait to take a look when I get home. I’m surprised at how quick your blog loaded on my mobile .. I’m not even using WIFI, just 3G .. Anyhow, very good site!
Howdy this is kinda of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding skills so I wanted to get advice from someone with experience. Any help would be enormously appreciated!
Thanks for the blog post, how can I make is so that I receive an email every time you publish a new article?
Spot on with this write-up, I actually assume this web site needs rather more consideration. I’ll most likely be once more to read rather more, thanks for that info.
Enjoyed looking through this, very good stuff, regards. “Be not careless in deeds, nor confused in words, nor rambling in thought.” by Marcus Aurelius Antoninus.
Hi my family member! I wish to say that this post is amazing, nice written and include almost all significant infos. I would like to peer extra posts like this.
Hi there! This is my first comment here so I just wanted to give a quick shout out and say I really enjoy reading through your blog posts. Can you recommend any other blogs/websites/forums that deal with the same topics? Thanks a ton!
You could certainly see your enthusiasm in the work you write. The world hopes for even more passionate writers like you who are not afraid to say how they believe. Always go after your heart.
I too believe thence, perfectly pent post! .
Hey very nice web site!! Man .. Beautiful .. Amazing .. I’ll bookmark your website and take the feeds also…I’m happy to find a lot of useful info here in the post, we need develop more techniques in this regard, thanks for sharing. . . . . .
I genuinely enjoy examining on this website, it has got great content. “A short saying oft contains much wisdom.” by Sophocles.
I like what you guys are up too. Such smart work and reporting! Carry on the superb works guys I?¦ve incorporated you guys to my blogroll. I think it’ll improve the value of my web site 🙂
You have brought up a very excellent points, thanks for the post.
Hey this is kinda of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding expertise so I wanted to get guidance from someone with experience. Any help would be enormously appreciated!
Simply desire to say your article is as astounding. The clarity in your post is just great and i could assume you’re an expert on this subject. Fine with your permission let me to grab your feed to keep up to date with forthcoming post. Thanks a million and please carry on the gratifying work.
It’s in point of fact a great and useful piece of info. I’m satisfied that you simply shared this useful info with us. Please stay us informed like this. Thanks for sharing.
Thanks , I’ve just been looking for info approximately this topic for ages and yours is the best I have discovered till now. However, what concerning the bottom line? Are you certain about the source?
I consider something genuinely special in this site.
I believe this is one of the so much significant info for me. And i’m satisfied reading your article. However want to commentary on some normal things, The web site taste is ideal, the articles is really nice : D. Excellent task, cheers
Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You definitely know what youre talking about, why throw away your intelligence on just posting videos to your blog when you could be giving us something enlightening to read?
I have read several just right stuff here. Definitely worth bookmarking for revisiting. I surprise how so much effort you set to create such a wonderful informative web site.
I appreciate, cause I found just what I was looking for. You’ve ended my four day long hunt! God Bless you man. Have a great day. Bye
There are some attention-grabbing closing dates in this article but I don’t know if I see all of them middle to heart. There may be some validity but I’ll take hold opinion until I look into it further. Good article , thanks and we wish more! Added to FeedBurner as properly
Aw, this was a very nice post. In thought I want to put in writing like this additionally – taking time and precise effort to make a very good article… however what can I say… I procrastinate alot and in no way seem to get something done.