Enterprise Systems Management Blog
Enterprise Systems Management – a blog site dedicated to Systems Management Tools & Technologies

Archive for the 'Database' Category

Oracle Tuning Tools

August 22, 2007

Ignite™ for Oracle Performance
Confio Software is revolutionizing the way enterprises monitor, analyze and optimize their databases and applications. Developed for Oracle DBA?s, managers and developers, Confio’s Ignite for Oracle performance solution enables organizations to optimize service levels for IT end-users and reduce total cost of operating infrastructure.
Actionable Data At An SQL Statement LevelConfio Ignite [...]

mtop/mkill – MySQL Monitoring Tools

July 14, 2007

mtop (MySQL top) monitors a MySQL server showing the queries which are taking the most amount of time to complete. Features include ‘zooming’ in on a process to show the complete query, ‘explaining’ the query optimizer information for a query and ‘killing’ queries. In addition, server performance statistics, configuration information, and tuning tips are provided.
mkill [...]

Oracle Enterprise Manager 10g R2

June 27, 2007

I found a very good presentation by Oracle DBA explaining OEM 10g Architecture, Features and monitoring.
http://www.nyoug.org/Presentations/2005/oem10gr2.pdf

Sybase MDA Tables

June 19, 2007

Monitoring tables (also known as MDA tables) are available in Adaptive Server version 12.5.x and later. So what does the MDA stand for “Monitoring Data Access” / “Monitoring and Diagnostics for ASE” / “Monitoring and Diagnostic Access” / “Monitoring and Diagnostic API. MDA tables are nothing but proxy tables in master database. There are approximately [...]