Re: Performance Baseline

Posted in 2006

Art S. Kagel — Thu, 10 Aug 2006 14:00:27 -0400 — source: Usenet: comp.databases.informix

in4mixDBA wrote: > Good morning! > > I am a new Informix DBA. Only on the job a month now. > > We are running IDS 7.31.FD7 on Sun Solaris 8. > > I was given a new project to come up with performance monitoring to > create a performance baseline. As I get started with my research here, > I am wondering if you have any suggestions or recommendations as to > where to get started and any current methods of monitoring performance. > I presume the initial stage would be to collect the data with a later > stage of having the ability to display the performance data in graphs > or charts. > > Any pointers would be greatly appreciated. Performance of what Dave? Of the server? Of the OS during server load? Of your applications while they are running? What are you measuring? What are the measures you want to capture? If server performance what to measure? Performance of disks? How? Max or average queue length? Service time? Of which disks? All? Heavily loaded? Performance of VPs? How? %CPU busy? Number of system calls/sec? The issue is not simple. Art S. Kagel