Re: system speed

Matt Devlin wrote: > > I am a junior DBA and have been assigned the task of analyzing our informix > engine and making recomendations on how to improve performance. Obviously > there are far too many variables to post in one posting. Would anyone out > there care to offer some assistance in this matter. I am very new to to > informix and would appreciate any help. The instance is running on a SCO > box with four intel 200 p-pro's. 700 megs of ram, over 100 users on a busy > day. I think at this point there will not be any physical changes made > unless a dramatic improvement could be acheived for minimal expense. We > really want to tune the engine. Hmmmm....I'm inclined to not be real impressed with your leadership - this really isn't a job for a rookie - nothing personal, you understand. You need to understand your HW, OS, DBMS engine and probably most of all application architecture *very* well to do this job right. Nevertheless, seize the opportunity to learn something - read the Informix Performance and Tuning manual, being careful not to be too mindlessly trusting of it, play with onstat commands and use "set explain" SQL to analyze long running queries etc.... You're right - there are too many considerations for a single post - pick out a specific problem (surely there must be a visible one to prompt this assignment...) and search Deja News for similar symptoms, chances are somebody's has seen / done it before. If not, post symptoms here - lots of sharp people frequently make suggestions. And if you get good at it your market value will shoot up considerably - be happy. -- Greg Moye The above are my opinions only.