Re: How to tune database with lots of very light queries

From: Ian MacGregor <>
Date: Tue, 29 Apr 2008 10:05:31 -0700
Message-ID: <>

How much time is spent parsing. What is your execute to parse ratio? Is there any difference in the resource usage of your queries. Are you using ³shared servers²? Is it one query per session? Just some things to think about.

On 4/29/08 9:30 AM, "Frits Hoogland" <> wrote:

> Starting point should still be looking at where your database is waiting at,
> and how the waits relate to CPU usage.
> Then pick the biggest component (either CPU or a wait), and see how that can
> be decreased.
> frits
> On Tue, Apr 29, 2008 at 4:58 PM, Zhu,Chao <> wrote:

>> We have  some databases with load profile like lots of light query (mostly pk
>> based),  each execution cost only 3-6 buffer_gets and no complex join etc.
>> But due to excessive executions (10K+ query per second), load is also driving
>> pretty high.
>> Anyone has experience tune such kind of application/database?  From single
>> SQL point of view, they are already perfect.

Received on Tue Apr 29 2008 - 12:05:31 CDT

Original text of this message