Dalleon Systems : Server Performance Management

This is a collection of short documents we have made available. They are intended to give some helpful advice and guidelines for doing performance management - not as strict instructions to be followed to the letter. We change the papers from time to time, adding new ones and retiring others - announcements on what has changed are made on the website's front page.

	Diagnosing Data Warehouse Performance Problems Background, guidelines and tips for investgating performance problems with Data Warehouse applications click on the image for more ...
	Application Upgrade A call-centre/sales operation used an Oracle*Forms application for it’s agents. They had a business need to upgrade from Forms 4.5 to Forms 6.0, to increase the functionality of the application. They ran a thick client-server architecture, with database and application servers in the datacentre and PCs in the call centre. click on the image for more ...
	CPU Usage When you look at processor utilisation data you will see that it is usually expressed as a percentage. Intuitively, 0% utilised means that no work is being done. Most systems report 100% as indicating that it is working flat out, occupying all it’s time with running software. There are a couple of notable exceptions: click on the image for more ...
	What makes a disk access? This is a brief description of the mechanics that go on behind the scenes whenever you read or write to a disk. It will also give you an insight into why bigger disks are not always better. Disks are essentially slow devices. This is due to their mechanical nature. The time it takes for a CPU to access a disk is somewhere between 1mSec and 100mSec click on the image for more ...
	Configuring Enterprise Storage The first area, the hardware that is available, sets the limits of the absolute best performance available from a given storage solution. The next two areas need to be defined once the key design decisions from the implementation (areas 4 and 5, plus the project dependant attributes) have been made.click on the image for more ...
	How Much Free Space is there? This is one of the questions that is most frequently asked of capacity management people. While it is easy to give a simple answer, the information provided is often misleading. Here we’ll see that there are at least three ways of approaching the question – the answer you want will depend on what your interests are..click on the image for more ...
	Performance Monitoring Guidelines These guidelines are not absolute necessities for doing performance management. However our experience shows that if they are not followed the process is slow, fails frequently, is expensive in terms of the number of staff needed and prone to error, inconsistencies and omissions.click on the image for more ...