Measuring fragmentation / performance
Posted in 1999
Hi!
Is there any other easy way to measure Informix db (7.22 or newer)
fragmentation than the following sql-statement:
SELECT DBSNAME, TABNAME, COUNT(*) EXTENTS,SUM(SIZE) PAGES FROM SYSEXTENTS
WHERE TABNAME NOT LIKE 'sys%'
AND DBSNAME NOT LIKE 'sys%'
AND TABNAME <> 'TBLSpace'
GROUP BY 1,2
ORDER BY 3,1,2; (If this gives more than 8 extents per table, then the db is
fragmented, this is what I have been told.)
Another thing: Is there any way to measure the times that application spends
fetching information from Informix db, or is there a possibility to make
some kind of reports about the throughoutput of the db?
The reason why I ask this, is that we are facing problems with response
times with our software which is using embedded sql to get information from
Informix 7.22 db and we should do something to be sure if the problem has to
do with our set-up of Informix or if it is a problem with wastefull
functions in the program itself. -We have run allready some tests with
quantify and they are showing that most of the time in our program is spent
in the functions that deal with db.
BR; Teemu