Once a problem is isolated you can display a drilldown page with charts and tables that provide a detailed breakdown of the underlying statistics.
|Drilldown||Click to open||Keyboard Shortcut||Drilldown Pages||Description|
|CPUs||CTRL+C||CPUs Page | Processing Page | Multiprocessor Page|
|Memory||CTRL+M||Summary Page | Paging Activity Page | Cache Page|
|Disks||CTRL+D||Logical Disk Activity Page | Physical Disk Activity Page | Logical Disk Space Usage Page | Disk Summary Page | File Sizes Page||
The Disks drilldown displays detailed information about the logical and physical disks on the Windows system.
|Network||CTRL+N||Network Page | TCPIP Page | NBT Page | SPX Page | Sessions Page | Shares Page | Open Ports Page | cLAN Gigabit Page|
|Activity Summary||CTRL+A||Activity Summary Page||
The Activity Summary drilldown displays summaries of recent Windows activity including, paging and packet rates, CPU usage across all processors, the number of threads waiting to be run, and the number of I/O requests that were queued for each logical disk.
|Event Log||CTRL+E||Event Log Page|
|Single Application||CTRL+S||Summary Page | CPUs Page | Memory Page | Disks Page||
The Single Application drilldown displays detailed information about specified individual processes (or a group of processes) on a Windows system.
Choose the processes you want Spotlight to analyze from View | Options | Data collection | Windows applications metrics.
The Alarm Log drilldown displays information on the alarms associated with the Windows system, including the name of the component that issued the alarm, the date and time the alarm was logged, and the severity of the alarm.
Note: The Alarm Log drilldown is common to all Spotlight applications. The alarms are specific to the current Spotlight connection. Spotlight on Windows Alarms
Use Spotlight on MySQL to monitor your MySQL databases, detect and resolve problems.
|Connect to a MySQL Database||Create / Modify / Delete connections to MySQL systems.|
|Spotlight on MySQL Home Page||The Spotlight home page shows the flow of information and commands between various sub-components and the size and status of internal resources such as processes, disk files and memory structures.|
|Spotlight on MySQL Alarms||
Spotlight alerts you to problems with your system by issuing an alarm. You can configure Spotlight in the level of severity that constitutes an alarm, to disable an alarm, and the actions Spotlight takes on raising the alarm.
|Spotlight on MySQL Drilldowns||When you have isolated a problem, you can display a drilldown page, whose charts and tables provide a detailed breakdown of the underlying statistics.|
Select the database to connect to.
Note: Ensure the Unix or Windows server on which the MySQL database is installed is accessible to Spotlight.
Click File | Connect
Select Spotlight on MySQL on the Connections menu.
Double-click Add new connection.
Fill in the connection Properties | Details page. MySQL Connection Details
This is the display name for the connection in Spotlight.
Tip: Fill in the Host field first.
MySQL connection details
|Host||Enter the name of the host machine for the MySQL database.|
Enter the user name to login to the MySQL database.
Enter the password to login to the MySQL database.
|Port||Enter the port used for the Spotlight on MySQL connection. The default value is 3306.|
|Database||Select the name of the database that you wish to connect to.|
OS Connection Details
Select to monitor the operating system on the database server.
Tip: Clear this option if the database is running on an operating system that is NOT supported by Spotlight on MySQL. If you leave this option checked and Spotlight on MySQL is unable to collect statistics from the server operating system, you may experience errors.
Enter the address of the host machine for the MySQL database.
If you select one of the Unix systems, make sure the SSH or REXEC daemon is running on the database server and is configured to receive remote connections.
Enter the port number for SSH (secure shell) connection to the database server. The default value is 22.
Note: Applicable when OS Type is Unix(SSH).
Type the user name to login to the database server.
Note: When OS Type is Windows:
Type the user password to login to the database server (if required).
Click Save password details (for this connection) to save all the entered password details.