Network statistics

Job details

Parameters

Job Summary

• Purpose: To monitor and collect data on the number of bytes sent and received by clients over the database network, ensuring performance optimization and identifying potential issues in data flow.
• Why: Monitoring network usage is critical for maintaining database performance and operational efficiency. It helps in preventing network congestion, identifying unexpected spikes in data transfer, and aids in capacity planning. Monitoring also assists in detecting possible data breaches, where large amounts of data might be unexpectedly sent or received.
• Manual checking: You can manually check the network statistics in the database by executing the following SQL commands:

SELECT bytes_received, bytes_sent FROM dbw_network_statistics_last;

Job Details

Job Objective

The job’s core function is to track the volume of network traffic (bytes sent and received) to gauge the instance’s performance. It helps in understanding the bandwidth usage patterns and ensures that the database does not suffer from under-provisioning or overloading due to network traffic.

How It Functions

• The job functions by creating and updating a history table for network statistics.
• It collects data for the amount of data sent and received over the network.
• Accumulated data is recorded for designated intervals and used to calculate average and total transfer rates over these intervals and a cumulative 24-hour period.
• The job is scheduled to run every 5 minutes as per the default scheduling setting embedded in the job configuration.

Tables and Procedures Created:

Key Metrics Tracked

• Total bytes received and sent during the specified monitoring period.
• Average bytes sent and received per minute over the last 24 hours.

Rationale for Using This Monitoring Job

This job is significant because it enables:

• Proactive monitoring which is crucial for timely detection and resolution of performance issues.
• Maintenance of efficient network traffic management, helping to prevent bottlenecks.
• Historical data analysis that provides insights for future capacity planning.

Cleaning Up

• The job includes cleanup mechanisms in case of installation failure, where it drops the created tables and related procedures to keep the environment clean.

Reporting Features

Report Overview

• Title: Network Statistics
• Description: Provides a graph and data table showing average network traffic per minute (received and sent) over the last 24 hours.
• The report is updated hourly based on new data collected.

Presentation In Report

This formatted and structured reporting helps in visualizing trends and understanding peak usage times, which is crucial for resource management and planning.