Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The table below describes to which Tiers the metric sets are relevant.

Table 4-1    Metric 1 Metric set dependency

Tier / Metrics

...

Trending    Load

Trending

OS    +    +    +        +    +

Web Client    +    +    +    +    +    +

J2EE    +    +    +    +    +    +

DB2    +    +                

WebSphere MQ    +    +    +    +        

Tuxedo    +    +    +    +    +    +

Tier/Metrics Set    Status    Performance    Load    Service    Performance

Trending    Load

Trending

Oracle    +    +    +    +    +    +

SQL Server    +    +    +    +    +    +

EMC Storage        +    +        +    +

SAP    +    +    +    +    +    +

Oracle Applications    +    +    +    +    +    +

Other    +    +    +    +        

Microsoft .NET    +    +    +    +        

Sybase Replication Server        +                

...

SetStatusPerformanceLoadServicePerformance
Trending
Load
Trending
OS(tick)(tick)(tick)(error)(tick)(tick)
Web Client(tick)(tick)(tick)(tick)(tick)(tick)
J2EE(tick)(tick)(tick)(tick)(tick)(tick)
DB2(tick)(tick)(error)(error)(error)(error)
WebSphere MQ(tick)(tick)(tick)(tick)(error)(error)
Tuxedo(tick)(tick)(tick)(tick)(tick)(tick)
Oracle(tick)(tick)(tick)(tick)(tick)(tick)
SQL Server(tick)(tick)(tick)(tick)(tick)(tick)
EMC Storage(error)(tick)(tick)(error)(tick)(tick)
SAP(tick)(tick)(tick)(tick)(tick)(tick)
Oracle Applications(tick)(tick)(tick)(tick)(tick)(tick)
Other(tick)(tick)(tick)(tick)(error)(error)
Microsoft .NET(tick)(tick)(tick)(tick)(error)(error)
Sybase Replication Server(error)(tick)(error)(error)(error)(error)
Info

The Performance Trending and Load Trending metric sets include metrics that are sampled by Report Manager, that is, each metric alerts to one or more Report Manager exception reports. For more information, see

...

Precise Report Manager

...

. Maintenance metrics are available in the Service set.

See “About Alerts metrics” on page 41.

Anchor
StatusSet
StatusSet
Status set

...

The Performance set helps find performance bottlenecks in your system. It includes the following metrics that measure the level of performance currently achieved by the system:

  • General

...

  • Behavior. Measures the resources consumption of the instance to detect times when the instance consumes a higher level of resources than is normal (according to definition), for example when the instance level memory usage is high.
  • Top

...

  • Activities. Reports on resource consumption of activities to allow the detection of activities that are high resource consumers, for example, Oracle programs using a high percentage of Oracle resources. The alert is generated on an activity level, that is, as a percentage of the resources the activity used out of the resources that the instance consumed. For example, when an SQL statement in the Oracle Tier is using 20% of the total resources consumed by the Oracle instance.
  • Top

...

  • Activators. Report on resource consumption of activators to allow the detection of activators that are high resource consumers, for example, Oracle users consuming a high percentage of Oracle resources. The alert is generated on an activator level (such as, Users, Locales, and IPs). The Top Activators are displayed as a percentage of the resources the activator consumed out of the resources that the Oracle instance consumed.
  • Long I/O

...

  • waits. Reports on I/O waits to allow the detection of objects that have a long access time and are causing activities to have a long I/O wait time while accessing them. The alert is generated on an I/O object level, that is, as a percentage of the I/O wait time the I/O file spent out of the total I/O wait time that the Oracle instance spent.
  • Internal performance

...

  • metrics. Reports on internal components and procedures of the instance. These metrics are Tier-specific, for example, for an Oracle database, a report on SGA utilization, on Oracle sessions that are waiting for a lock, and so on.

Anchor
LoadSet
LoadSet
Load set

The Load set helps to identify any increase of load on the system, which can cause a decrease in the performance. It includes the following metrics that measure the load on the system:

  • Frequent

...

  • Activities. Reports on activities that have a high number of executions compared to the total number of executions in the instance. This might help you point out abnormal activities, wrong use of the system, and so on.
  • Frequent

...

  • Activators. Reports on originators that have a high number of executions compared to the total number of executions in the instance. This might help you point out abnormal originators; for example, SAP users running many transactions.
  • High I/O

...

  • activity. Reports on I/O objects that have high access hits compared to the total number of accesses in the instance. This might help you point out objects that were accessed many times compared to all other objects in the system.
  • Internal load

...

  • metrics. Indicates the internal load. This might help you point out times when instance resources are exceeded. For example, when the number of logged-in users approaches, reaches, or

...

  • transgresses the allowed maximum, and so on.

Anchor
ServiceSet
ServiceSet
Service set

The Service set includes SLA metrics. The SLA metrics indicates the actual service level compared to the predefined SLAs. These metrics help to identify a decrease in response time.Note:

Info

Alerts samples the data for the Service metrics from Insight and not from the

...

"Precise for" products (except for

...

SAP and Web Tiers, which retrieve their Service data from their

...

"Precise for" products and not from Insight).

The following SLA metrics are included:

  • Overall SLA

...

  • Compliance. Reports on the total instance performance not conforming to the defined SLA.
  • SLA Breaching

...

  • Activities. Reports on activities that exceeded their defined SLA, for example, programs taking longer than defined.
  • SLA Breaching

...

  • Activators. Reports on activators that get bad response times, for example, users suffering from SLA breaches.

Anchor
PerformanceTrendingSet
PerformanceTrendingSet
Performance trending set

The Performance Trending set helps you point out problematic performance aspects that cannot be pinpointed in the short term. The performance trending set holds the following metrics that measure the performance of the instance over a longer period of time:

  • Instance Performance (Exceptions)

...

  • . Based on daily and/or monthly Report Manager reports that compare the instance performance to a baseline.
  • Activity Performance (Exceptions)

...

  • . Based on daily and/or monthly Report Manager reports for the different activities that:

      ...

        • Compare the average performance of each activity to its baseline.

      ...

        • Compare the average time of all the activities to a baseline.
      • Internal performance trending metrics

      ...

      • . Includes metrics based on daily and/or monthly Report Manager reports that compare the performance of internal instance components to their baseline.

      The metrics in this set are sampled by Report Manager.

      ...

      It holds the following metrics that measure the load of the instance over a longer period of time.

      • Activity Volume (Exceptions)

      ...

      • . Based on daily and/or monthly Report Manager reports that compare:

          ...

            • The number of executions of an activity in relation to its baseline.

          ...

            • The percentage of executions of an activity to the total of executions of all the activities in relation to a baseline.
          • Activator Volume (Exceptions)

          ...

          • . Based on daily and/or monthly Report Manager reports that compare:

              ...

                • The number of executions by each activator in relation to the relevant baseline.

              ...

                • The percentage of executions by activator to the total of executions by all activators in relation to a baseline.

              The metrics in this set are sampled by Report Manager.

              ...

              The Precise status set is available in the Precise Status application for Cross-Tiers.Note:

              Info

              Metrics for the i3 Status application do not appear in the alerts report on screen, and are indicated by the action items defined in the metric properties only. See the Precise Administration Guide for details.

              ...

              • FocalPoints. Indicates the FocalPoint agents' status.

              ...

              • Agents. Indicates the agents' status, excluding FocalPoint agents.

              ...

              • Licenses. Indicates the license status of Precise components.
              • Processes.

              ...

              • Indicates the status of PMDB processes.

              Anchor
              CustomizedSet
              CustomizedSet
              Customized set

              The Customized set holds all user-defined metrics. You can create customized metrics to sample any system data. You can create customized metrics in AdminPoint. See the Precise Administration Guide for details.


              Scroll Ignore
              scroll-pdftrue
              scroll-officetrue
              scroll-chmtrue
              scroll-docbooktrue
              scroll-eclipsehelptrue
              scroll-epubtrue
              scroll-htmltrue
              Newtabfooter
              aliasIDERA
              urlhttp://www.idera.com
               

              ...

              Precise. Performance intelligence from click to storage. Learn more > >

              ...

              Newtabfooter
              aliasProducts
              urlhttps://www.idera.com/productssolutions/sqlserver
               
              Newtabfooter
              aliasPurchase
              urlhttps://www.idera.com/buynow/onlinestore
               | 
              Newtabfooter
              aliasSupport
              urlhttps://idera.secure.force.com/precise/
               | 
              Newtabfooter
              aliasCommunity
              urlhttp://community.idera.com
               
              |
               
              Newtabfooter
              aliasResources
              urlhttp://www.idera.com/resourcecentral
               | 
              Newtabfooter
              aliasAbout Us
              urlhttp://www.idera.com/about/aboutus
               
              Newtabfooter
              aliasLegal
              urlhttps://www.idera.com/legal/termsofuse

              ...