Re: How to tune database with lots of very light queries
Date: Tue, 29 Apr 2008 10:05:31 -0700
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" <frits.hoogland_at_gmail.com> 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.
> On Tue, Apr 29, 2008 at 4:58 PM, Zhu,Chao <zhuchao_at_gmail.com> 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