Go to Server Analyzer Menu to view the details.
[Screenshot 1 is not available on this page.]
Dashboard
Database performance metrics help you with database performance monitoring and optimize it for your business. The metrics are calculated for the entire server not restricted to the database specified in the JDBC URL.
Oracle
> [Screenshot 2 is not available on this page.]
MySQL
[Screenshot 3 is not available on this page.]
MSSQL
[Screenshot 4 is not available on this page.]
PostgreSQL
[Screenshot 5 is not available on this page.]
OS
This view provides a fast and convenient window into your physical server's/VM's performance including # of processes, context switches, CPU, memory, storage performance and etc.
[Screenshot 6 is not available on this page.]
CPU CORE Analyzer
This view provides the overall CPU and it's individual CPU core details.
[Screenshot 7 is not available on this page.]
Processes
This view provides the performance stats for CPU, memory and running processes organized.
Historical snapshots of various processes running at any point of time and what kind of resources they were consuming at that point of time are available here. Applicare by default would take a snapshot of this info every 30 minutes but this can be configured by changing the snaps interval.
[Screenshot 8 is not available on this page.]
Disk
This view provides the disk usage accessed by each and every process.
[Screenshot 9 is not available on this page.]
Network Connections
This view provides the TCP, UDP, RAW, and UNIX connection Details.
[Screenshot 10 is not available on this page.]
MBean Browser
MBean Browser allows browsing of mbeans properties and their values.
Oracle
[Screenshot 11 is not available on this page.]
MySQL
[Screenshot 12 is not available on this page.]
MSSQL
[Screenshot 13 is not available on this page.]
PostgreSQL
[Screenshot 14 is not available on this page.]
SQL
SQL Statement Profiling provides the performance statistics of database requests. You can view what statements are taking the most time and quickly diagnose performance impacting SQL/s. It also provides detailed stats including the database, count, average and various percentiles.
MySQL
> [Screenshot 15 is not available on this page.]
MSSQL
[Screenshot 16 is not available on this page.]
PostgreSQL
[Screenshot 17 is not available on this page.]
Oracle
[Screenshot 18 is not available on this page.]
Top SQL Details
It displays the SQL statements that are executed most often, that use more system resources than other SQL statements.
[Screenshot 19 is not available on this page.]
Session Details
It displays information about the current user’s session.
[Screenshot 20 is not available on this page.]
RAC Details
Oracle Real Application Clusters (RAC) allow customers to run a single Oracle Database across multiple servers in order to maximize availability and enable horizontal scalability, while accessing shared storage.
[Screenshot 21 is not available on this page.]
SGA Details
The System Global Area (SGA) is a group of shared memory structures, known as SGA components, that contain data and control information.
[Screenshot 22 is not available on this page.]
Database Growth
It display the Database Growth details.
[Screenshot 23 is not available on this page.]
SQL Report
The SQL statements can be downloaded as a report by clicking the print icon from the Server Analyzer menu SQL Screen.
[Screenshot 24 is not available on this page.]
[Screenshot 25 is not available on this page.]
[Screenshot 26 is not available on this page.]