eMagic Application Monitoring
eMagic

Few Clicks to Manage Enterprise Apps,
Databases on-the-fly

End User

Application Performance Monitoring

Application monitoring is a complete monitoring solution for most crucial aspects of your business - applications, databases and web servers across physical, virtual or cloud environments. It is an agentless monitoring tool that performs in-depth monitoring, even with heterogeneous app and database environments and comes with a real-time interactive dashboard, allowing the user to analyse health, availability and performance of applications at a glance and on the go.

Get alerts and notifications with its abilities to constantly monitor and analyse roadblocks. Set customized threshold limits for your type of business and enable custom notifications. Forecast inventory requirements and trouble shoot incidents instantly.

Get eNlight to Experience Real-time Cloud Computing

Contact
 

Run mission-critical apps, databases and web servers flawlessly, as application performance monitoring keeps users updated about the page load times, error rates, transaction speed, list of servers running the apps, and much more.

Database Monitoring

Database monitoring module monitors a heterogeneous database server environment that may consist of Oracle databases, MSSQL and MySQL databases.

Oracle Performance Monitoring is easy, with Database Performance Monitoring Tool

Run Oracle apps on agentless Database performance monitoring tool which provides multi-dimensional analysis, including

 
  1. Detailed Oracle Datafiles Monitoring
  2. Oracle ASM Disk Groups Monitoring With Proactive Notifications
  3. Oracle Database Job Scheduler
  1. In-depth Oracle Space Monitoring
  2. Continuous Oracle Sessions Monitoring

Get Overview of Oracle Database in One Click

Overview section under Oracle application monitoring helps the user to take a quick audit of Oracle database, as it displays overall database details, connection statistics and user activity. The overview window also represents the database health, availability, today’s availability, uptime, last start and much more.

 
overview
 

Overview of Application/ Database

  1. Oracle Health
  2. Oracle Availability
  3. Todays Availability
  1. Listener Uptime
  2. Listener Last Start
  3. Database Sever Details
  1. Connection Time
  2. Concurrent Users Activity

View/Configure Tablespace Instantly

Tablespaces in Oracle database are comprised of one or more logical storage units. It is important for users to check how much space is currently in use because when space is full, further transactions stop. Tablespace collectively stores all the database information through which user can view one or more datafiles, check the actual capacity of Tablespace, actively monitor growth in Tablespace, and configure alarms by setting threshold conditions for health, consumption. Tablespace guides database administrators to take provisioning decisions on-the-go and take corrective actions when threshold configurations are violated.

 
Table Space Details
 

Tablespace Details

  1. Total no. of table spaces created in Oracle
  2. Their respective names & allocated/ used sizing
  1. Health status
  2. Separate Tablespace wise alerts in configure alarm section of dashboard
  1. Alerts on basis of criticality of Tablespace

Data files Details

  1. Detailed Status of Data Files
  2. Health status
  1. Details of Data files on specific Tablespace
  2. Allocated/Used & free space in real-time

Tablespace Fragmentation

  1. Details of free chunks size, largest chunks size & fragmentation index of Tablespace

Perform In-depth Analysis of Oracle Sessions

Sessions enables the user to perform an in-depth analysis of total sessions running in Oracle DB with individual statuses, CPU usage details, modules running on each session, wait time and more. Through session’s section, administrator comes to know about the number of authorized/unauthorized users connected to the system and sessions being utilized by each of them. App Monitoring notifies unwanted sessions running in the database, based on which users can decide to kill these sessions and in turn improve system performance.

 
Session Details

Session Details

  1. Total running sessions in oracle DB
  2. Their respective status, machine & usernames
  1. Health status – Elapsed time , CPU used
  2. Physical & Logical reads, lockwait
  1. Module and Program running the session

Session Waits

  1. Detailed Status of Sessions in Wait
  2. Their wait type/classs
  1. Wait time in ms
  2. Seconds in wait from top to low
  1. Current state of session

Schedule Jobs & Back Ups effortlessly

Jobs & Back Ups allows you to do a status check of jobs scheduled in Oracle, as it presents noteworthy information like jobs and their run status with duration, failure/retry counts, elapsed time, etc. Basically, users get to know success ratio of scheduled workflows. Backups enables user to perform seamless backups as it notifies the user about session key, back up status and size, time taken to complete the backup, etc. Database administrators are alerted about system back up needs so that they can proactively plan for back up provisioning.

Job & Backup

Schedule Job Details

  1. Details of currently scheduled jobs in Oracle
  2. Their respective job names & current status
  1. Last run status with its duration
  2. Last start date of Job & next run date
  1. Comments from database on job

Schedule Jobs Stats

  1. Run count, Failure count, Retry count, Elapsed time in ms
  1. Active State of Status/Restart

Backup Jobs Details

  1. Crucial info about backup jobs with info such as session key, type, start time, autobackup count.
  1. Status/Size/Time Taken of Critical Back Ups

Take a Tour of SGA Performance

SGA enables the user to view SGA performance through graphs and charts. The SGA (System Global Area) is an area of memory (RAM) allocated when an Oracle Instance starts up. The SGA's size and function are controlled by initialization (INIT.ORA or SPFILE) parameters. Through SGA, the user can view memory performance which is a critical aspect of systems, as transactions fail and sessions can’t be created once memory performance falls short. App Monitoring enables DBAs to operate on optimized memory levels as users are alerted about memory usage proactively. Users can set memory parameters, punch threshold at the right locations and decide about memory provisioning by taking a quick walk through of SGA performances.

 
SGA Details
 

SGA Details

  1. Buffer cache size
  2. Shared Pool Size
  3. RedoLog Buffer Size
  4. Fixed Area Size
  5. Java Pool size
  1. Large Pool Size
  2. Free Memory
  3. SGA Latches Hit Ratio
  4. SGA Shared Pool
  1. Reload Ratio
  2. SGA Shared Pool Free Percentage

SGA Performance

  1. Details Status of SGA Performance in rela-time graphs and percentage metrics
  2. Buffer hit ratio
  3. Data dictionary hit ratio
  4. Library hit ratio

Analyse PGA Performance

PGA allows users to get instant details of memory region that contains data and control information for server processes. PGA is a non-shared memory region created by Oracle when a server process is started.

 
PGA Details
 

PGA Performance

  1. PGA freed back to OS
  2. Total freeable PGA
  3. Maximum PGA allocated
  1. Total PGA allocated
  2. Total PGA used
  1. Cache Hit Percentage
  2. Resource used by processes

Get Real-time Stats of Processes in Oracle

Process tab allows user to get instant access to processes running in Oracle, analyse consumption of PGA, learn about allocated and freeable PGA, etc. Users can take a detailed view of type of processes utilizing system resources and accordingly decide to stop/continue with processes as required.

 
processes
 

Oracle Process

  1. All running process details
  2. Their respective Max. PGA used (in MB) wise bar graph
  1. detailed table report of real-time process stats

Set Threshold based Alerts Through Multiple Configurable Parameters

Monitor Setting in eMagic provides the user with multiple parameters to configure threshold based alerts on Oracle Database performance. Users can analyse historical data for each monitoring parameter represented in convenient graphical form, and edit settings in monitor conveniently.

 
Monitor Setting

Monitoring Parameters Details

  1. 50+ Parameters are available for configuring threshold based alerts on Oracle Database performances
  2. Based on criticality of parameter; polling time, first alert time, repeated alert time can be defined for each parameter separately
  3. Historical data for each monitoring parameter is available in graphical form

Get Access to Events/Logs

In Events and Logs, user can check monitoring alerts and notifications generated by App monitoring tool.
It helps users to figure out exact time of events taking place.

 
Events/Logs Details

See Query Results in a Click

Run Query provides user a platform to execute any database Query and observe the Query results.
It saves user's time to log into the system to execute any query.

 
Run Query

MS SQL Database Server Monitoring is effortless, with eMagic

User can take control of MS SQL database with eMagic SQL Server monitoring module which helps database administrators monitor

 
  1. Performance and availability of production databases
  2. SQL statistics
  3. Buffer Manager statistics
  4. Cache details
  5. Latch details
  6. Lock details
  1. Monitor custom SQL database queries and get active updates about Access method details
  2. Database details
  3. Connection statistics
  4. Memory usage
  5. Scheduled Jobs

Get Overview of MS SQL Database At a Glance

Overview Section enables user to get active updates of MS SQL with complete details about name, type, IP, CPU count, business vertical, etc. Users also get real-time and historical information of MS SQL like hit ratios, user connections, today’s availability, etc.

 
overview
 

MS SQL Overview

  1. Application Information
  2. Name
  3. Type
  4. IP
  1. Version
  2. CPU Count
  3. Memory (MB)
  4. Startup Time
  1. Location
  2. Business Unit
  3. Business Vertical

Real-time & historical graphical info

  1. Buffer Cache hit ratio
  2. Plain Cache hit ratio
  1. Current user connections
  2. Todays availability

Analyze Actual Memory Consumption & Future Requirements

Memory displays a list of details presenting actual memory consumption, buffer manager statistics, detailed information on cache, access logs, lock and latch details which enable the user to take corrective decisions to optimally utilize the memory.

 
MSSQAL Memory
 

Monitoring Memory related parameters

  1. In details & with graphs

Memory usage

  1. Total Server Memory
  2. SQL Cache Memory
  3. Optimizer Memory
  1. Lock Memory
  2. Connection Memory
  1. Target Server Memory
  2. Granted WorkSpace Memory

Buffer Manager Statistics

  1. Buffer Cache Hit Ratio
  2. Page Lookups/Sec
  3. Pages Read/Sec
  1. Page Writes
  2. Database Pages
  3. Page Life Expectancy (ms)
  1. Database Pages
  2. Page Life Expectancy (ms)

Cache Details

  1. Cache Hit Ratio
  1. Cache Count
  1. Cache Pages

Access Details

  1. Full Scans/Sec
  2. Range Scans/Sec
  1. Probe Scans/Sec
  2. Work Files Created/Sec
  1. Work Tables Created/Sec
  2. Index Searches/Sec

Cache Details

  1. Cache Hit Ratio
  1. Cache Count
  1. Cache Pages

Latch Details

  1. Latch Waits/Sec
  1. Average Latch Wait Time

Instantly Walk through Sessions

Under sessions, the user can view the Connection Statistics, SQL Statistics, and Host Details
with complete information of host/machine accessing the MS SQL database and Session Details.

 
Sessions
 

Connection Statistics

  1. User Connections
  1. Logins/Sec
  1. Logouts/Sec

SQL Statistics

  1. Batch Requests/Sec
  2. SQL Compilations/Sec
  3. SQL Recompilations/Sec
  1. Auto-Param Attempts/sec
  2. Failed Auto-Params/Sec
  3. Safe Auto-Params/Sec
  1. Unsafe Auto-Params/Sec

Host Details

  1. Host Name
  2. Login Name
  3. DB Name
  4. User Name
  1. Domain
  2. Number Of Connections
  3. Memory(MB)
  1. CPU(ms)
  2. I/O

Session Details

  1. SPID
  2. Status
  3. User Name
  4. Host
  1. Program
  2. CPU(ms)
  3. I/O
  4. DB Name
  1. Command
  2. Query

Schedule Jobs & Back Ups Effectively

Jobs allows user to view Job Execution, Job Steps Execution Info & Job Schedule Info. MS SQL admins can get a close view of actual jobs being executed, whether or not, as scheduled. Under backups the user can view Recent Database Backup & Back-up within Past 24 Hours. App Monitoring enables quick and detailed view of jobs and backups and sends recommendations for provisioning of resources for uninterrupted database performance.

 
Jobs & Back Up
 

Job Details: Provides real-time Job info.

  1. Job Name
  2. Last Run Time
  1. Last Run Status
  2. Last Run Duration (HH:MM:SS)
  1. Last Run Status Message
  2. Next Run Time

Backup Details

  1. Server
  2. Last Backup Date
  3. Backup Start Date
  1. Expiration Date
  2. Size
  3. Logical Device Name
  1. Physical Device Name
  2. Backupset name

Take Command over MS SQL Performance

Users can take full control of performance of MS SQL by taking a survey of top queries by CPU, I/O, lowest plan reuse, frequency as well as top waits, most blocked queries and more. With a list of details about status of queries and their memory usage, admins can conveniently decide which queries must be stopped or continued.

 
Performance
 

Performance Category wise reports & graphs

  1. Top Queries by CPU
  2. Top Slow Running Queries
  3. Top Queries by Lowest Plan Reuse
  1. Top Queries by I/O
  2. Most Frequently Executed Queries
  3. Cost of Missing Indexes
  1. Top Waits by Waiting Tasks
  2. Most Blocked Queries

For example, Most frequently executed queries

  1. Details of Queries
  2. Display with Graphs & Tables
  3. Covers table info such as,
  1. Server
  2. Last Backup Date
  3. Backup Start Date
  1. Expiration Date

Cover Table Info such as

  1. Server
  2. Expiration Date
  1. Last Backup Date
  1. Backup Start Date

Check, Configure, Reconfigure Memory

Through configuration, users can run checks of regular, advanced and memory configurations being
managed in MS SQL database as well as re-configure configurations.

 
Configuration
 

In Memory Configuration

  1. Name
  2. Minimum
  1. Maximum
  2. Configured Value
  1. Value In Use
  2. Description

Categorized In

  1. All Configurations
  2. Advanced Configurations
  1. Reconfigure Configurations
  2. Memory Configurations

Cover Table Info such as

  1. Server
  2. Expiration Date
  1. Last Backup Date
  1. Backup Start Date

Manage Monitor Settings in a few clicks

Monitor settings gives a close view of existing settings and allows users to edit settings as well as update host details. Users can click on a single window to add/ remove parameters, reset monitoring interval, alert time, repeated alert time, punch threshold parameters and much more.

 
Monitor Settings
 

Monitoring Parameters Details

  1. 50+ Parameters are available for configuring threshold based alerts on MSSQL database performance.
  2. Based on criticality of parameter, polling time, first alert time, repeated alert time can be defined for each parameter separately
  3. Historical data for each monitoring parameter is available in graphical form

Cover Table Info such as

  1. Server
  2. Expiration Date
  1. Last Backup Date
  1. Backup Start Date

Take a close view of Events

In Events and Logs, user can check all monitoring alerts and notifications generated by App monitoring tool.
It helps users to figure out exact time of events taking place.

 
Emagic Details

MY SQL Database Server Monitoring is convenient, with Database Application monitoring

Application monitoring helps database administrator to monitor the performance and availability of an MYSQL database.

 
  1. MySQL Health Monitoring
  2. MySQL Database Report
  1. MYSQL Database Optimizer
  2. User Management

Get Overview of MYSQL Database At a Glance

Overview section under MySQL application monitoring, helps the user to directly have an overview of the performance status, network statistics, MySQL statistics, InnoDB Statistics, today’s availability, database details along with the database ENGINE Data.

 
MYSQL Overview
 

Database Info

  1. IP
  2. Host name
  3. Location
  1. Inno DB version
  2. Slave type Conversion
  3. Version
  1. VersionnCompile OS
  2. Version SSL Library

Network stats

  1. Threads Connected
  1. Threads running
  1. bytes send
  1. bytes received

MySQL Stats

  1. Frequency of Select querries
  2. freq of update querries
  1. insert querries
  2. delete querries
  1. Read request count
  2. Request count

Database details/ Database Engines

  1. Name DB
  2. Table Details
  3. Row Size
  1. Data Size
  2. Index Size
  3. Total Size
  1. Index Fraction

Analyse your MySQL Performance with MySQL Optimizer

MySQL Optimizer allows admin to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.

 

It analyses your MySQL performance and, based on the statistics it gathers, gives recommendations which variables you should adjust in order to increase performance. That way, you can tune your my.cnf file to tease out the last bit of performance from your MySQL server and make it work more efficiently.

 
Major Issue Major issue.
Ok Normal status of the alert generated.
Alert Generated User regarding the alert generated.
 
MYSQL-Optimizer
 

Performance Metrics

  1. MySQL System check
  2. MySQL Server version checks
  3. MySQL security checks
  4. MySQL database information
  1. MySQL Index information
  2. MySQL Connections information
  3. MySQL server information
  4. MySQL sort, join and temp table information
  1. MySQL global buffer information
  2. MySQL query cache checks
  3. MySQL memory checks

Recommendations

  1. Storage Engine Statistics
  2. Security Recommendations
  1. MyISAM Metrics
  2. InnoDB Metrics
  1. Replication Metrics
  2. Recommendations – General / Security

Get detailed status of your Database with MYSQL Reports

MySQL Report displays a well-formatted report of important MySQL status variables that can help admin to gain an understanding of what is happening under MySQL's hood. It can help diagnose problems. The benefit of MySQL report is that it allows you to very quickly see a wide array of performance indicators for your MySQL server which would otherwise need to be calculated by hand from all the various SHOW STATUS values. MySQL Report transforms the values from SHOW STATUS into an easy-to-read report that provides a much more in-depth understanding of how well MySQL is running.

 
MYSQL Report
 
 
  1. IP
  2. Key Details
  3. Database Query Statistics
  4. Query Cache Details
  1. Table Details
  2. Table Lock Details
  3. Connection Details
  4. Client Details
  1. Thread Details
  2. Data Transferred Details
  3. InnoDB Engine Details

Get detailed status of server & system variables

The MySQL server maintains many Status and System variables that provide information about its operation and its configuration. Each Variable has some values. From here user can check any variable value without executing any command. Significance of each variable is also shown there, so user can immediately figure out the significance and current value for different variables of MySQL database.

 
MYSQL-Server-Variables
 

Status Variables

  1. Performance
  2. Performance Schema
  3. Networking Stats
  1. Threading
  2. Query Cache
  3. SSL
  1. InnoDB
  2. Transactions
  3. Command DDL/DML

System Variables

  1. General
  2. InnoDB
  3. Logging
  1. MYISM
  2. Networking
  3. Performance
  1. Replications
  2. Security

Manage, Host and Assign privileges as per requirement.

Under User and Privileges, the user can manage host and can assign privileges as per requirement.

 
MYSQL Users
 

Bullets

  1. Login details Mgt.
  2. Account limit Mgt.
  1. Privileges Mgt.
  2. Privileges Mgt.

Manage, Host and Assign privileges as per requirement.

Monitor settings gives a close view of existing settings and allows users to edit settings as well as update host details. Users can click on a single window to add/ remove parameters, reset monitoring interval, alert time, repeated alert time, punch threshold parameters and much more.

 
MYSQL Users
 

Monitoring Parameters Details

  1. 50+ Parameters are available for configuring threshold based alerts on MSSQL database performance.
  2. Based on criticality of parameter, polling time, first alert time, repeated alert time can be defined for each parameter separately
  3. Historical data for each monitoring parameter is available in graphical form

Manage Monitor Settings in a few clicks

Monitor settings gives a close view of existing settings and allows users to edit settings as well as update host details. Users can click on a single window to add/ remove parameters, reset monitoring interval, alert time, repeated alert time, punch threshold parameters and much more.

 
MYSQL Users
 

Monitoring Parameters Details

  1. 50+ Parameters are available for configuring threshold based alerts on MSSQL database performance.
  2. Based on criticality of parameter, polling time, first alert time, repeated alert time can be defined for each parameter separately
  3. Historical data for each monitoring parameter is available in graphical form

Take a close view of Events

In Events and Logs, user can check all monitoring alerts and notifications generated by App monitoring tool. It helps users to figure out exact time of events taking place.

 
MYSQL-Events
Videos