Sybase Network Test

This test, executed by an internal agent, tracks various statistics pertaining to network traffic of the Sybase Adaptive Server.

Target of the test : A Sybase ASE (Below v15) server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every Sybase ASE (Below v15) server being monitored.

Configurable parameters for the test
Parameter	Description
Test Period	How often should the test be executed.
Host	Refers to the IP address of the Sybase server.
Port	The port number at which the Sybase server listens to.
User	A Sybase user who has the “sa_role”.
Password	The password corresponding to the above user.
Confirm Password	Confirm the password by retyping it here.

Measurements made by the test
Measurement	Description	Measurement Unit	Interpretation
I/O requests	The total number of packets received and sent per second	Pkts/Sec
I/O delays	The percentage of times network I/O was delayed	Percent	A non-zero value over a period of time indicates a problem.
Receive rate	Reports the rate at which the network bytes are being received.	KBytes/Sec	This measure indicates the amount of data coming to the database server through the network. A high value of this measure indicates higher rate of incoming data to the server. If this measure is considerably high, the value of the default network packet size parameter should be increased.
Send rate	Reports the rate at which the network bytes are being sent.	KBytes/Sec	This measure indicates the amount of data going out of the database server through the network. A high value of this measure indicates higher rate of outgoing data from the server. If this measure is considerably high, the value of the default network packet size parameter should be increased.
Avg packet size	The average number of bytes sent per packet	Bytes	If the Adaptive server receives a command that is larger than the packet size, the server waits to begin processing until it receives the full command. Therefore, commands that require more than one packet are slower to execute and take up more I/O resources. If the average bytes per packet is near the default packet size configured for your server, you may want to configure larger packet sizes for some connections. You can configure the network packet size for all connections or allow certain connections to log in using larger packet sizes.