- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: perfomance monitoring database?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2003 05:06 AM
тАО04-23-2003 05:06 AM
I am planning on building a tool to collect performance stats from all our unix servers 80+ and send this data to a RDBMS database.
Does anyone know of a freeware verion I could use to get started, or any ideas of how to get started would be welcome.
Thanks
Donny
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2003 05:21 AM
тАО04-23-2003 05:21 AM
Re: perfomance monitoring database?
Thanks
Zafar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2003 05:40 AM
тАО04-23-2003 05:40 AM
Re: perfomance monitoring database?
I would suggest sar - pushing its outputs to files which you then ftp to the collection server.
Search the forum for use and setup of sar.
HTH
Paula
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2003 06:03 AM
тАО04-23-2003 06:03 AM
Re: perfomance monitoring database?
You can write your own scripts to process this and write SQL scripts to push into the DB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2003 06:08 AM
тАО04-23-2003 06:08 AM
Re: perfomance monitoring database?
We do it here, but we use Measureware to get the performance stats. The Measureware product costs money, but it is worth it many times over for the amount of information it will give you.
If you are looking to do it for free, you'll just have to use sar, dump it to a file and write a script to send it to your database. Not too hard, but the stats won't be nearly as good.
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2003 06:53 AM
тАО04-23-2003 06:53 AM
Re: perfomance monitoring database?
The ability to monitor the system tables has been very valuable to me in preventing downtime.
HTH
Marty
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2003 07:02 AM
тАО04-23-2003 07:02 AM
Re: perfomance monitoring database?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2003 07:58 AM
тАО04-23-2003 07:58 AM
SolutionExample
UNIX File:
tdate=`date +%m-%d-%Y.%H:%M:%S`
iostat | ssp | rmnl | sed '1d' | awk -v td=$tdate '{print td "|" $1 "|" $2 "|"$3 " |" $4 "|"}' > /tmp/ios.out
If you have informix database then
dbaccess database_name
create table iostats
(
dtime char(50),
devices char(50),
bps integer,
sps decimal(10,2),
msps decimal(10,2)
);
LOAD FROM "/tmp/ios.out" DELIMITER "|"
INSERT INTO iostats;
Now, just select from informix database:
SELECT * FROM iostats
You can do the same like this with Oracle also, but the loading syntax will be different.
Thanks
Zafar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2003 09:19 AM
тАО04-23-2003 09:19 AM
Re: perfomance monitoring database?
Yes is exactly, what I am trying to develop.
I have an oracle database, have not built the database yet.
I am sure measureware can already do this type of work. but I plan to build a web front for the data with perl cgi scripts. and be able to do trending afterwards, and forcasting.
Thus I will start with cpu stats 1st, then add each component to monitor one at a time.
thanks
Donny
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2003 09:43 AM
тАО04-23-2003 09:43 AM
Re: perfomance monitoring database?
MeasureWare interfaces with special metric points inside HP-UX and gathers them through a specialized shared memory daemon called midaemon. This interface is quite non-invasive yet provides 100x more in measurements than the legacy Unix apps. The important feature for MWA is the extract command that will pull exactly what you need from the logs. HP also offers PerfView which will create graphs but for your application (web based reports), just MWA and extract will work very well.
b
Buy a copy of MWA and look for the presentation software in the freeware community--you'll save an enormous amount of time and labor plus get useful reports.
There are also two alternatives to MeasureWare: SarCheck and MetaView from Lund Performance Solutions. The Lund package is complete with web (and also PDA) reports along with alarms and drill-down capability. If you need to manage 80+ servers, you'll be way ahead using the Lund package which comes out of the box ready to serve up the reports.
Bill Hassell, sysadmin