Re: Query for Top 10 Most "Expensive" Queries

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 27 Aug 2003 00:29:46 -0700
Message-ID: <1a75df45.0308262329.23bd95c3@posting.google.com>

alvathinstruct_at_hotmail.com (Allan Vath) wrote

> I once had the sql which read a sys view which listed the top 10 worst
> queries (as judged by high I/O).

High i/o is not indicative of bad SQL. Just as high CPU usage is not bad.

Computer resources are there to be used. CPU, memory, i/o channels, network channels, etc.

Computer resources sitting idle is wasting your money. Computer resources being used is putting your money to use.

Thus high resource usage is only expensive when the process has its head up its backside - thus you need to be careful not to judge all all high resource usage queries as expensive. It is more expensive having under utilised resources.

--
Billy

Received on Wed Aug 27 2003 - 02:29:46 CDT