We manage database server, system and also the storage. Our system is very critical because the fab run in here is 24/7 and we manage about 40 Oracle database instances, about 300 Sequel server instances, 4 DB2 database instances. We use MaxGauge to monitor our database and also look into different kind of performance issues to do troubleshooting.
We develop an ETL from the OLTP database and we also develop application interfacing it with our data warehouse typed database. We use a MaxGauge for few different reasons, we use it for some of the real-time monitoring to see what’s currently going on and see some of the details about current queries if they are running long.
I would recommend this MaxGauge to use to other in similar type of industry that has critical databases need to be looked at for issues, and tuning, and performance monitoring. Definitely this is very accommodate tool for this industry. Our database is very critical because if it stops it effects manufacturing and it costs lots of money.
When there is an issue, first of all we will look into the Maxgauge Real-time Monitor to see what’s going on. And then base on that, we could figure it out that something causes the problem in the database performance and it can also link to alert log to be able to figure it out what cause issue.
We instituted MaxGauge’s earlier version in 2004 and have used it since, and today, it has become a standard tool throughout all of our operation departments. As a financial institution through which our valued customers’ funds flow in and out, if any problems arise, it could lead to very critical issues. And hence, the role of a DBA is very important, and MaxGauge is a tool tailored to meet the needs of DBAs.
Our company, KEPCO KDN, as one who professionally develops and provides electric IT administration, one of the reasons why we adopted the MaxGauge was because we needed to enhance monitoring in the core of our system. We had first started with DBMax(MaxGauge’s Former Version) and it has been applied to the most critical systems in Korea Electric Power Corporation(KEPCO).
