Re: Estimating table access?

From: Geoff Wilson <gmwils@eisa.net.au> > >Is it possible to figure out how much particular tables are being accessed >under Informix 7.3? The problem is that I have a disk performance problem >on a Yes. >server I have just started admining for. The database is pretty much all >stored in one partition on the machine and one database segement. The >database >is accessed through a client program to which there is no source. I would >like >to be able to work out which tables are taking the most hits in order to >split >them off from the rest of the data. Good idea. >It would also be useful to be able to estimate data access paths so as to >reallocate resources to indexes. Ideally I would like to be able to find >out >the most expensive SQL queries being run by the server (I remember being >able >to do this under Oracle, but can't figure it out under Informix, maybe due >to >lack of support?) Never due to a lack of knowledge, God forbid. >Any help or pointers to information about this would be greatly >appreciated. >The performance tuning manual just doesn't seem to cut it for this. Which one are you using? The one I'm looking at on page 2-7 talks about gathering historical information and mentions things like onstat -g sql and onstat -g ses. Jake Salomon also wrote a nice little script called table-iostats (with a partner beautify_unl) to package all this up for you. These and many other useful bits can be found at http://www.iiug.org The manuals can be found at http://www.informix.com/answers/ Perhaps you should read them all or consider a course? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com