How to tune database with lots of very light queries

From: Zhu,Chao <>
Date: Tue, 29 Apr 2008 22:58:01 +0800
Message-ID: <>

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.


Zhu Chao

-- Received on Tue Apr 29 2008 - 09:58:01 CDT

Original text of this message