Re: Determining system bottlenecks

From: Scott Richardson (CheetahFTL_at_attbi.com)
Date: 07/09/03


Date: Wed, 09 Jul 2003 20:18:40 GMT


"Vikas Agnihotri" <fornewsgroups@vikas.mailshell.com> wrote in message
news:oprrz42trc3k814u@news.fu-berlin.de...
> I have a Sun E450 that, over the years, has taken on increasing workload.
I
> suspect that the machine is sweating at night with the various batch jobs
> thrown at it (it houses a Oracle database), but I cant quantify it.
>
> Before recommending to upgrade or replace this machine, I would like to be
> able to pinpoint, for sure, that cpu/memory/io as the bottleneck.
>
> How do I go about doing this? I turned on the 'sys' crontab and now I have
> the /var/adm/sa/sarN reports but it is just a bunch of numbers. Is there
> something out there that analyses these numbers and provides meaningful
> recommendations?
>
> Thanks

Hello Vikas Agnihotri,

Sounds like you want something with nice colorful, dynamically scaling
graphs
that will clearly point out the numbers and what they mean, so that non
technical management types can clearly understand very quickly what exactly
is happening on Solaris, and Oracle as well for that matter, and when/why.

A great tool for exactly what you're looking for, DPMonitor, can be found at
www.deltekonline.com. They have a free trial evaluation license with the
product when you download it. It will profile Solaris, AIX, Windows and
Oracle,
but the free trial evaluation version will only profile one Agent OS. All
these OS
platforms measureable with one tool, "apples to apples" as they say.

It has an extremely low overhead Agent component that runs on Solaris.
Agent data is then sent back to a Windows PC that acts as "performance
monitor console component" that crunches numbers and displays graphical
results

It's available for short term lease as well - so you can profile before and
after
upgrade or replacement - analysis, and be able to show management exactly
what is going on when, and how much resources are being consumed. It's also
great for showing areas where performance improvements can be made which
may help save costs of an upgrade altogether. Either way, everything is 100%
justifiable and clear for even the most non-technical to understand..

There are many other products out there - some free, some not.
HTH.

--
Regards,
Scott
Senior Systems Engineer / Consultant
Web: http://home.comcast.net/~CheetahFTL/CC


Relevant Pages

  • Re: SqlExpress Merge Agent slow Profiles & one way Rep
    ... It works because the pull agent gets the profile information from the publisher, just like it gets ftp info. ... Note you can override these values on the client and if you create a profile based off one of the default profiles and select which subscriber should use it. ...
    (microsoft.public.sqlserver.replication)
  • Re: SqlExpress Merge Agent slow Profiles & one way Rep
    ... I have a publishing subscriber which publishes to SQLExpress. ... You are saying that if I set "slow profile" on the publisher SQLExpress will ... Surely the profiles exist where the Agent runs, which for a Merge agent is ...
    (microsoft.public.sqlserver.replication)
  • Re: SqlExpress Merge Agent slow Profiles & one way Rep
    ... The slow agent profile is ideal for low bandwitdth links between your publisher and tthe subscriber. ...
    (microsoft.public.sqlserver.replication)
  • Re: PollingInterval and HistoryVerboseLevel
    ... properties not present in the profile. ... COMMIT TRANSACTION ... HistoryVerboseLevel to 0 on both the Log Reader and Distribution Agent ...
    (microsoft.public.sqlserver.replication)
  • Re: Solaris 8 nss_ldap frustration
    ... ldap client), Solaris8 LDAP client should behave the same as Solaris9 ... But ldapclient *still* didn't take the same args as Solaris 9's. ... Plus, when you make a change to the profile, it ...
    (comp.unix.solaris)