Feature released in SummitAI IT Operations Management (Denali SP1)

What's New?

Additional monitoring parameters are added to monitor SQL Server and Oracle Server. Also, new monitoring parameters are added to monitor the HPE3PAR Storage. The Parameter grouping helps in better organization and improves searching ability.

Parameter Groups for SQL Servers

Access Method Details

Free Space Scans
Full Scans
Index Searches
Page Splits
Probe Scans
Range Scans
Scan Point Revalidations
Work Files Created
Work Tables Created

Blocking And Deadlock

Average Lock Wait Time
Lock Requests
Lock Wait Time

Blocking Details

Average Execution Time
Average Time Blocked
Last Execution Time
Query
Total Time Blocked

Data File

File Name
Growth Size
Max Size
Percentage Free
Percentage Used
Space Free
Total File Size
Used Size

Database Properties

Auto Create Statistics
Auto Shrink
Auto Update Statistics
Compatibility Level
Creation Date
Database Mode

Index Space

Free Unused Space
Total Reserved Space
Used Data Space

Job Failure Alerts

Failure Reason
Failure Time
Job Time
Status

Log File

File Name
Growth Size
Max Size
Percentage Free
Percentage Used
Space Free
Total File Size
Used Size

Login Details

No of Connections

Lowest Plan Reuse Details

Average Execution Time
Cache Object Type
Last Execution Time
Plan Usage
Plan Use Counts
Query

Missing Index Details

Average Total Cost
Average User Impact Percent
Improvement Measure
Include Columns
Index Script

Most Frequently Executed Queries

Average Execution Time
Execution Count
Last Execution Time
Query

Plan Cache

Cache Count
Cache Pages
Cache Used

Slow Running Queries

Average Execution Time
Last Execution Time
Maximum Execution Time
No of Executions
Query

SQL Statistics

Auto Params
Failed Auto Params

Standard

Port
SQL Status
Version

Table Row

Rows

Top Queries By CPU

Average CPU Time
Average Execution Time
Execution Count
Last Execution Time
Query
Total CPU Time

Top Queries BY I/O

Average Execution Time
Average Logical I/O
Execution Count
Last Execution Time
Query
Total I/O

Top Intervals By Waiting Tasks

Blocked By Query
Wait Time
Wait Type

Transaction Details

Active Transactions
Bulk Copy Rows
Bulk Copy Throughput
Log Cache Hit Ratio
Log Cache Reads
Log Growths
Log Shrinks
Log Transactions
Replication Transactions

User Connection

Logouts

Parameter Groups for Oracle Servers

Alert Logs

Host Address
Message Level
Message Text
Originating Time
Record Id

Archive Log Destination

Applied Sequence
Delay
Destination
Destination ID
Error
Fail Sequence
Log Sequence
Net Timeout
Status
Transmit Mode
Type

ASM Status

Header Status
Mode Status
Mount Status
State

ASM Utilization

Bytes Read
Bytes Written
Failed Read Requests
Failed Write Requests
Read Requests
Used Space
Used Space Perc
Write Requests

Buffer Gets Details

Buffer Gets
Executions
SQL Query

Corrupted Block

File Number
Number of Corrupted Blocks
Type of Block Corruption

Data File Utilization

Data File Status
Read Time
Write Time

Database Config

Archive Log Compression
Control File Type
Database Created Time
DB ID
DB Role
Force Logging
FRA Status
Guard Status
Log Mode
Open Mode
Open Reset Logs
Protection Mode
Switch Over Status

Database Data Files

Data Files Size
Temp Files Size

Database Parameter

Available Free Memory
Available Free Space
Buffer Cache Hit Ratio
Dictionary Cache Hit Ratio
Library Cache Hit Ratio
No of connected users to DB through SQL-Net

DB Links

Creation Time
Link Owner
Link User Name

Deadlock Details

Blocking Session Status
Event
QUERY
Schema
SID
SQLFULLTEXT
Status
Terminal
User Name
Wait Class

Fast Recovery Area Details

FRA Space Limit
FRA Space Reclaimable Limit
FRA Space Used
Used Percentage

Fast Recovery Area Usage

FRA Actual Used Percentage
FRA Reclaimable Percentage

Index Details

Index Status
Owner
Table Space Name

Listener Status

Listener Status

Longest Transaction

Elapsed Seconds
Message
Opname
Sofar
Start Time
Target
Total Work
Units

OEM Advisor Status

OEM Status

PGA Stats

Cache Hit Percentage
Maximum PGA Allocated
PGA Freed Back To OS
Total Freeable PGA
Total PGA Allocated
Total PGA Used

PGA Stats Per Process

Freeable PGA
Max PGA Used
PGA Allocated
PGA Used
Process Id

Redo Logs

Archive Status
Log Group
Log size
Log Status
Log Thread
Member Count
Member Group
Member Status
Member Type

Resource Limit For Process

Current Utilization
Max Utilization

RMAN Backup

End Time
Input Type
Session Key
Start Time
Status

Rollback Segment

Extends
High Water Mark Size
Hit Ratio
Initial Extent
Maximum Extent
Minimum Extent
Next Extent
Shrinks
Table Space Name
Wraps

Session Details

Serial Number
Session Commits
Session CPU Used
Session Cursor
Session Logical Reads
Session Memory Sorts
Session Physical Reads
Session Table Scans

Shared Pool Area

Fixed Area Size
Library Cache Size
Shared Pool Free Size
Shared Pool Size
SQL Area Size

User Details

Account Status
Days To Expire
DB Privileges
Expiry Date
User Name
User Profile

Parameter Groups for HPE3PAR Storage

Cache Memory Page Statistics

Read Accesses
Read Hit Perc
Read Hits
Write Accesses
Write Hit Perc
Write Hits

Logical Disks Statistics

Read Band width
Read IOs
Read Service Time
Total Band width
Total IOs
Total Service Time
Write Band width
Write IOs
Write Service Time

Physical Disks Statistics

Read Band width
Read IOs
Read Service Time
Total Band width
Total IOs
Total Service Time
Write Band width
Write IOs
Write Service Time

Port Statistics

Read Band width
Read IOs
Read Service Time
Total Band width
Total IOs
Total Service Time
Write Band width
Write IOs
Write Service Time

Virtual Volumes Statistics

Read Band width
Read IOs
Read Service Time
Total Band width
Total IOs
Total Service Time
Write Band width
Write IOs
Write Service Time

VLUN Statistics

Read Band width
Read IOs
Read Service Time
Total Band width
Total IOs
Total Service Time
Write Band width
Write IOs
Write Service Time

UI Changes

SQL Server

A new SQL Server Advanced option is added in the Server Type drop-down list on the FILTERS pop-up page of the APPLICATION PARAMETER THRESHOLD. Select this option to search the newly added Parameter Groups and the respective Parameters.
You can select the Copy Below check box to replicate the values in the first row of a column to all the subsequent empty rows.
For example:
If you select the Copy Below check box of the column Threshold Values, the value 9000 in the first row of the column is replicated to all the empty rows of that column. See the following screenshot:

Oracle Server

A new Oracle Advanced option is is added in the Server Type drop-down list on the FILTERS pop-up page of the APPLICATION PARAMETER THRESHOLD. Select this option to search the newly added Groups and the respective Parameters.
You can select the Copy Below check box to replicate the values in the first row of a column to all the subsequent empty rows.

HPE3PAR Storage

A new HPE3PAR Storage option is added in the Server Type drop-down list on the FILTERS pop-up page of the APPLICATION PARAMETER THRESHOLD. Select this option to search the newly added Groups and the respective Parameters.
You can select the Copy Below check box to replicate the values in the first row of a column to all the subsequent empty rows.

Configuration

On the SERVICE ENTITLEMENT page, select the Monitoring Parameters (Operations > Configuration > General > Service Entitlement > Select the Tenant and Device Type as Server from the Filters pop-up page > Click ADD NEW on the ACTIONS panel and specify the Service Entitlement name > Select the required parameter’s check box and click SUBMIT). For more information, see Configuring Service Entitlements.

To set SQL Server Monitoring Parameters Threshold:

On the APPLICATION PARAMETER THRESHOLD page, select the required filter criteria with the Server Type as SQL Server Advanced, and configure the Threshold value to create an Event or log an Incident (Operations > Configuration > General > Application Parameter Threshold > Select the Tenant , Device Type as Server, and other required details from the Filters pop-up page > Click SEARCH > Specify the required Threshold values, Action Template, and Incident Template > Click SUBMIT). For more information, see Configuring Application Parameter Threshold.

To set Oracle Server Monitoring Parameters Threshold:

On the APPLICATION PARAMETER THRESHOLD page, select the required filter criteria with the Server Type as Oracle Advanced, and configure the threshold value to create an Event or log an Incident (Operations > Configuration > General > Application Parameter Threshold > Select the Tenant , Device Type as Server, and other required details from the Filters pop-up page > Click SEARCH > Specify the required Threshold values, Action Template, and Incident Template > Click SUBMIT). For more information, see Configuring Application Parameter Threshold.

To set HPE3PAR Storage Monitoring Parameters Threshold:

On the APPLICATION PARAMETER THRESHOLD page, select the required filter criteria with the Server Type as HPE3PAR Storage, and configure the threshold value to create an Event or log an Incident (Operations > Configuration > General > Application Parameter Threshold > Select the Tenant , Device Type as Server, and other required details from the Filters pop-up page > Click SEARCH > Specify the required Threshold values, Action Template, and Incident Template > Click SUBMIT). For more information, see Configuring Application Parameter Threshold.

References

For the list of Monitoring Parameters, see SummitAI IT Operations Management Monitoring Parameters List.