Did you ever have a performance problem and not know where to start
looking? Well, who didn't? In such a situation, it is important to
perform a proper monitoring of the system and resist the immediate urge
to blame the processing power --the storage subsystem is often
overlooked. Now that I spoiled the suspense giving away the answer,
give me 5 minutes to illustrate this with a typical example. Why
typical? Because this is a case I meet quite often with startup
companies who rightly concentrate on their core business and not on
their IT infrastructure --that's what we are here for.
One of our partners, Squid Solutions, recently reported a performance problem with an Oracle database; they had engaged our team as part of the Sun Startup Essentials
support program. Squid Solutions makes a software called Nautilus that
performs intensive analytics on database systems, whatever their kind
or size. They call Nautilus an SQL Knowledge Engine because it
models data and business knowledge, and then automatically generates
SQL code to execute the data processing tasks. Nautilus is sold as a
service performed by Squid's engineers as Customer Intelligence projects.
So, Squid Solutions had purchased a brand-new Sun
Fire X2250
server --quad-core Intel Xeon with 4 GB of RAM, running Solaris 10--,
and was experiencing poor performance --much lower than their old
system of previous generation-- when executing a read-n-write intensive
workload on the database. When I first got on the server, something
jumped right to my eyes…
[
Read More]