FNSTs QAD Monitoring One part of the monitoringmanagement

Agenda • • • Intro – About FNST Background/History QAD Implementation Present State Benefits

Freudenberg-NOK Sealing Technologies Established 1989 Headquartered in Plymouth, Mich. , USA (Privately Held) 25%

Diverse and Established Partners Headquarters Plymouth, Michigan Weinheim, Germany Tokyo, Japan Established 1989 1849

Freudenberg Global locations Production Sales Production and Sales © Freudenberg-NOK General Partnership 5

Production Locations in the Americas New Hampshire Facilities: Ashland – Aerospace Radial Shaft Seals

Freudenberg-NOK Sealing Technologies Today Responsible for sealing technology business in the Americas Total sales

Agenda • • Background/History QAD Implementation Present State Benefits Realized Future Directions Quick Review

Background/History HP Open. View implemented in 1994 Dedicated a great deal of effort to

QAD Implementation Contracted QAD Services. “Canned” product, virtual Linux server (recover image and change

Our Environment Centralized 2010 SE Host (co-lo in NC) Supporting 30 sites from Canada

Our Monitoring Environment Each host has a system “control” file containing all databases and

Database Control File ########### /prod/prddbhe 10 DEFAULT hlpea PRODEA 10 QAD_add-on /prod/prddbqxo 17 DEFAULT

Site Monitoring Ping a host in each supported site Good method of determining how

Scripts for Automation of Monitoring Services. /build_server_cfg. sh [remote host] [DLC] Builds a file

Script to Build Configuration File copy the template to [servername]-server. cfg cp fnst-server. cfg.

Present State All Linux hosts monitored (ping, OS) All sites monitored (ping to a

Benefits Realized Network issues identified “stair step” graph noticed, turns out cable disconnect at

Future Direction Regular internal review. Regular review with ERP Team. Review what else would

Quick Review Alerts Graphs © Freudenberg Sealing Technologies Gmb. H & Co. KG 25

Alerts Graphical, Emails © Freudenberg Sealing Technologies Gmb. H & Co. KG 26

Status/Alerts by Location/Service © Freudenberg Sealing Technologies Gmb. H & Co. KG 27

Alerts by Service © Freudenberg Sealing Technologies Gmb. H & Co. KG 28

Alerts by Host © Freudenberg Sealing Technologies Gmb. H & Co. KG 29

Email Alerts © Freudenberg Sealing Technologies Gmb. H & Co. KG 30

Graphs Hourly (min avg), Daily (5 min avg), Weekly (30 min avg), Monthly (2

Site Overview We included (at least) one host in each of the sites accessing

Site Overview © Freudenberg Sealing Technologies Gmb. H & Co. KG 33

Ping Response Time © Freudenberg Sealing Technologies Gmb. H & Co. KG 34

Statistics Specific to QAD Hosts Processor statistics QAD users Database statistics Net. UI performance

Host Performance Statistics © Freudenberg Sealing Technologies Gmb. H & Co. KG 36

QAD Users © Freudenberg Sealing Technologies Gmb. H & Co. KG 37

QAD DB Reads © Freudenberg Sealing Technologies Gmb. H & Co. KG 38

Sidecar DB Reads © Freudenberg Sealing Technologies Gmb. H & Co. KG 39

Admin DB Reads © Freudenberg Sealing Technologies Gmb. H & Co. KG 40

Time to Read 10, 000 Records © Freudenberg Sealing Technologies Gmb. H & Co.

tr_hist Records Added (good indicator of activity) © Freudenberg Sealing Technologies Gmb. H &

Net. UI Response © Freudenberg Sealing Technologies Gmb. H & Co. KG 43

Live Point browser to http: //ra 2 sqadmon © Freudenberg Sealing Technologies Gmb. H

Questions? Questions, Suggestions, Comments, © Freudenberg Sealing Technologies Gmb. H & Co. KG 45

Slides: 45

Download presentation

FNST’s QAD Monitoring One part of the monitoring/management initiative for FNST/FST © Freudenberg-NOK General Partnership 1

Agenda • • • Intro – About FNST Background/History QAD Implementation Present State Benefits Realized Future Directions Quick Review (screenshots) Lessons Learned Q&A © Freudenberg-NOK General Partnership 2

Freudenberg-NOK Sealing Technologies Established 1989 Headquartered in Plymouth, Mich. , USA (Privately Held) 25% 75% ~23% Established 1849 Headquartered in Weinheim, Germany (Privately Held) © Freudenberg-NOK General Partnership Established 1939 Headquartered in Tokyo, Japan (Publically Traded on the NSS) 3

Diverse and Established Partners Headquarters Plymouth, Michigan Weinheim, Germany Tokyo, Japan Established 1989 1849 1939 2008 Sales $1 Billion $6. 5 Billion $4. 5 Billion Ownership Privately Held Publicly Held Products Radial Shaft Seals O-Rings Gaskets Fluid Power Products Oil and Gas Products Diaphragms Specialty Sealing Products Vibration Control Devices Medical Products © Freudenberg-NOK General Partnership 4

Freudenberg Global locations Production Sales Production and Sales © Freudenberg-NOK General Partnership 5

Production Locations in the Americas New Hampshire Facilities: Ashland – Aerospace Radial Shaft Seals Elgin, IL Industrial Radial Shaft Seals Simrit Sales Office Bristol Bonded Piston Seals Plymouth, MI Tillsonburg, ON Technology Center Silicone and Fluoro-silicone Products Necedah, WI Gaskets Cleveland, GA Santa Ana, CA Valve Stem Seals and Powertrain Seals O-rings Morristown, IN Custom Molded Rubber Products Shelbyville, IN Boots & Bellows – Mechanical Face Seals, La. Grange, GA Querétaro, Mexico O-rings Northfield – Axle Seals Manchester – Gaskets Manchester – Microcellular Polyurethane Milan, OH Heavy Industry Lead Center, Imported Products Findlay, OH Cuautla, Mexico PTFE Products Radial Shaft Seals and Custom Molded Rubber Products and Vibration Control Devices Troy, OH PTFE Products Sao Paulo, Brazil Radial Shaft Seals © Freudenberg-NOK General Partnership 6

Freudenberg-NOK Sealing Technologies Today Responsible for sealing technology business in the Americas Total sales in 2010: US$ 798. 7 million Workforce in 2010: 4, 224 Locations in: U. S. , Canada, Mexico, Brazil, Malaysia, China Sales exceeded market recovery in 13 of 15 principal market segments Sites: 35 production, sales and technical facilities © Freudenberg-NOK General Partnership 7

Agenda • • Background/History QAD Implementation Present State Benefits Realized Future Directions Quick Review (screenshots) Live © Freudenberg Sealing Technologies Gmb. H & Co. KG 8

Background/History HP Open. View implemented in 1994 Dedicated a great deal of effort to include Progress and QAD in our monitoring/management Versions not kept current (budget constraints) to support our Linux environment © Freudenberg Sealing Technologies Gmb. H & Co. KG 9

Agenda • • Background/History QAD Implementation Present State Benefits Realized Future Directions Quick Review (screenshots) Live © Freudenberg Sealing Technologies Gmb. H & Co. KG 10

QAD Implementation Contracted QAD Services. “Canned” product, virtual Linux server (recover image and change IP), Icinga and Cacti for alerting and graphing. “Base” configuration file created. Deployment simplified, copy base and change host info. Scripts built for deploying: - Database monitors based on our “/node/info/databases” file (list of databases per host with environment, used for many purposes including start-up). - Disk statistics. - Graphs too. © Freudenberg Sealing Technologies Gmb. H & Co. KG 11

Our Environment Centralized 2010 SE Host (co-lo in NC) Supporting 30 sites from Canada to Mexico Distribution Site Linux e. B 2 (our facility in OH) Brazil Site Linux 2007 © Freudenberg Sealing Technologies Gmb. H & Co. KG 12

Our Monitoring Environment Each host has a system “control” file containing all databases and environments This allows easy scripting of status checks, up/down, and query from other applications and scripts to invoke This file allowed us to automate our monitoring implementation © Freudenberg Sealing Technologies Gmb. H & Co. KG 13

Database Control File ########### /prod/prddbhe 10 DEFAULT hlpea PRODEA 10 QAD_add-on /prod/prddbqxo 17 DEFAULT qxodb PRODEA 10 QAD_add-on ############ /prod/prdcmbme 10 DEFAULT mfgdb PRODEA 10 Prod_QAD /prod/prdcmbae 10 DEFAULT admea PRODEA 10 /prod/prdcmbfe 10 DEFAULT fngpea PRODEA 10 FNGP_QAD_add-on /prod/prdcmbte 10 DEFAULT tpea PRODEA 10 Tailor. Pro /prod/prdcmbev 17 DEFAULT qxevents PRODEA 10 Qxtend_events ############ ## Corteco Mexico ############ /prod/prd 73 me 10 DEFAULT mfg 73 PRODEA 10 Prod_QAD mexico /prod/prd 73 ae 10 DEFAULT admea PRODEA 10 /prod/prd 73 fe 10 DEFAULT fngpea PRODEA 10 FNGP_QAD_add-on /prod/prd 73 te 10 DEFAULT tpea PRODEA 10 Tailor. Pro /prod/prd 73 ev 17 DEFAULT qxevents PRODEA 10 Qxtend_events ############################ © Freudenberg Sealing Technologies Gmb. H & Co. KG 14

Site Monitoring Ping a host in each supported site Good method of determining how a site sees performance © Freudenberg Sealing Technologies Gmb. H & Co. KG 15

Scripts for Automation of Monitoring Services. /build_server_cfg. sh [remote host] [DLC] Builds a file with the Icinga components for Progress database monitors based on the control file. This generated file gets inserted into the host’s configuration file in Icinga. Creates Icinga monitors for DB check, extents, log entries, last backup, buffer hits, read rates, and locks. /build_server_graph. sh [remote host] [DLC] Queries for host ID, then creates Cacti graphs for each database in the control file. /build_server_disk. sh [remote host] Ran a “df” on the remote host, builds Icinga space monitor for each local disk, insert into host’s configuration file. © Freudenberg Sealing Technologies Gmb. H & Co. KG 16

Script to Build Configuration File copy the template to [servername]-server. cfg cp fnst-server. cfg. template [servername]-server. cfg find and replace ral 2 lnxqad with the server name edit the host IP correct the webspeed entries correct DLC if needed build the databases section: . /build_server_cfg. sh [remote host] [DLC] © Freudenberg Sealing Technologies Gmb. H & Co. KG 17

Present State All Linux hosts monitored (ping, OS) All sites monitored (ping to a host in all sites) All Linux QAD hosts monitored (Progress databases, Net. UI performance) © Freudenberg Sealing Technologies Gmb. H & Co. KG 19

Benefits Realized Network issues identified “stair step” graph noticed, turns out cable disconnect at site Qxtend performance issue Alert on CPU utilization, worked w/ EA Team Cache Hit Rate Alert, increased “Big B” DB Writes/Min Worked w/ ERP Team, identified code that was not “domainized” © Freudenberg Sealing Technologies Gmb. H & Co. KG 21

Future Direction Regular internal review. Regular review with ERP Team. Review what else would benefit us. Remote point(s) for monitoring. Net. UI testing for one. With the implementation of Vmware in remote sites we may just deploy VM Include HPUX (retire Open. View). Visibility to others outside the Server Team. Migrate additional legacy performance and monitoring scripts Review how to play with SCOM © Freudenberg Sealing Technologies Gmb. H & Co. KG 23

Graphs Hourly (min avg), Daily (5 min avg), Weekly (30 min avg), Monthly (2 hr avg), Yearly (1 day avg) Data points include: Ping Response Host Statistics QAD Users DB Reads Time to Read 10 K Records Database Performance Statistics Net. UI View © Freudenberg Sealing Technologies Gmb. H & Co. KG 31

Site Overview We included (at least) one host in each of the sites accessing our central QAD servers This gives us up/down and response times by site, assisting in troubleshooting issues © Freudenberg Sealing Technologies Gmb. H & Co. KG 32

Statistics Specific to QAD Hosts Processor statistics QAD users Database statistics Net. UI performance © Freudenberg Sealing Technologies Gmb. H & Co. KG 35