A script enabled browser is required for this page to function properly.
Skip to main content
StorageTek Tape Analytics Administration Reference Guide, Version 1.0.2
E28379-03
Table of Contents Previous Next Index


Database Services Administration : Resource Monitor Reports

Resource Monitor Reports

The Resource Monitor can produce two different reports:

•
“Resource Monitor Standard Report”
•
“Resource Depletion Alert Report”

Resource Monitor Standard Report

A Resource Monitor Standard Report is sent once a day at approximately the time specified by the staresmonadm “daily report send time” (-T) command line option. The report is sent to the email recipients you specified when you configured this service.

Note – For Resource Monitor configuration information, see the “Configuring STA Services” chapter within the StorageTek Tape Analytics Configuration Guide.

If you do not set a time, the report is sent at the first scan after midnight.

The report provides data for these server resources:

•
Database tablespace
•
Database disk volume
•
Logging volume disk
•
System physical memory

If any of these resources exceeds a high-water mark threshold, an alert appears in the report.

▼

Set a Specific Time to Send a Report
1.
Enter the following command if you want the Standard Report sent at 05:15.
 
# staresmonadm -T 05:15
Contacting daemon...connected.
Setting Send Time............ 05:15
Done.
 Current STA Resource Monitor Service Settings:
   Configured              [yes]
   Send Reports         -T [05:15]
   Sleep Interval       -i [3600 sec]
   Alert Nagging        -n [on]
   DB Username          -U [stadba]
   DB Password          -P [********]
   DB Tablespace hwm    -t [66%]
   DB Disk Volume hwm   -d [75%]
   STA Log Volume hwm   -l [75%]
   System Memory hwm    -m [80%]
   Email 'From:'        -f [StaResMon@staapp01.mycompany.com]
   Email 'To:'          -r [joe.adminguy@mycompany.com]
   Email 'Subject:'     -s [STA Resource Report <staapp01>]
   Output File          -o [/var/log/tbi/db/staresmon.csv]
===================================================

An example of a typical Standard Report is shown below:

STA RESOURCE MONITOR STANDARD REPORT
System: staapp01
Scanned: 2011-10-28 12:46:10
 
+---------------------------------+
| Database Tablespace             |
+---------------------------------+
  HWM            : 80.00%
  Used           : 0.03%
  MB Used        : 5
  MB Free        : 19451
  MB Total       : 19456
  Location       : /dbdata/mysql
 
+---------------------------------+
| Database Disk Volume            |
+---------------------------------+
  HWM            : 80.00%
  Used           : 22.95%
  MB Used        : 12367
  MB Free        : 41508
  MB Total       : 53875
  Directory      : /dbdata/mysql
 
+---------------------------------+
| Logging Disk Volume             |
+---------------------------------+
  HWM            : 82.00%
  Used           : 22.95%
  MB Used        : 12367
  MB Free        : 41508
  MB Total       : 53875
  Directory      : /var/log/tbi
 
+---------------------------------+
| System Physical Memory          |
+---------------------------------+
  HWM            : 90.00%
  Used           : 61.87%
  MB Used        : 4944
  MB Free        : 3047
  MB Total       : 7991
  Hostname       : staapp01

Resource Depletion Alert Report

A Resource Depletion Alert Report is sent after every scan, if the staresmonadm alert “Nag” mode (-n) command line option is set to “ON.” The interval between each scan is determined by the Sleep Interval (-i) attribute, and the report is sent to the email recipients you specified when you configured this service.

Note – For Resource Monitor configuration information, see the “Configuring STA Services” chapter within the StorageTek Tape Analytics Configuration Guide.

▼

Set the Nag Mode
1.
Specify ON for the “Nag” mode. If the “Nag” mode is OFF, alerts are shown only in the Standard Report.
 
# staresmonadm -n ON
Contacting daemon...connected.
Setting Send Time............ 05:15
Done.
 Current STA Resource Monitor Service Settings:
   Configured              [yes]
   Send Reports         -T [05:15]
   Sleep Interval       -i [3600 sec]
   Alert Nagging        -n [on]
   DB Username          -U [stadba]
   DB Password          -P [********]
   DB Tablespace hwm    -t [66%]
   DB Disk Volume hwm   -d [75%]
   STA Log Volume hwm   -l [75%]
   System Memory hwm    -m [80%]
   Email 'From:'        -f [StaResMon@staapp01.mycompany.com]
   Email 'To:'          -r [joe.adminguy@mycompany.com]
   Email 'Subject:'     -s [STA Resource Report <staapp01>]
   Output File          -o [/var/log/tbi/db/staresmon.csv]
===================================================

An example of an Alert Report for a low system memory condition is shown below:

Subject: ALERT :: STA Resource Depletion [2011-10-28 12:53:26]
Date: Fri, 28 Oct 2011 12:53:27 -0600
From: RESMON@stabackups.mycompany.com
To: Bob Smith
 
 
STA RESOURCE DEPLETION REPORT
System: stabackups
Scanned: 2011-10-28 12:53:26
 
************************************************************
*                     A L E R T S                          *
************************************************************
==================================================
ALERT - Low System Physical Memory
==================================================
  Physical memory usage has exceeded threshold value!
  HWM             [60.00%]
  Used            [61.76%] (!)
  MB Used         [4935]
  MB Free         [3056]
  MB Total        [7991]
  Hostname        [staapp01]
  Recommendations:
  1) Shutdown unneeded processes.
  2) Install additional memory.
Table of Contents Previous Next Index Link to documentation
Copyright © 2012 Oracle and/or its affiliates. All rights reserved. Legal Notices