Properties on Sybase Instances


Properties are grouped below by topic.

Activity and utilization

Name Description Typical values
active_session_count The number of active sessions on the instance
activity Overall activity score
activity_active_sessions The current active session count
activity_active_sessions_score A score derived from the active session count
activity_disk_reads Disk reads per second
activity_disk_reads_counter The current disk read counter
activity_disk_reads_lasttime The last disk read sample time in milliseconds since 1970
activity_disk_reads_score A score derived from the disk read rate
activity_disk_writes Disk writes per second
activity_disk_writes_counter The current disk write counter
activity_disk_writes_lasttime The last disk write sample time in milliseconds since 1970
activity_disk_writes_score A score derived from the disk write rate
activity_dtu_test DML performance test task ID
activity_enabled Whether activity monitoring is enabled
activity_logical_reads Logical reads per second
activity_logical_reads_counter The current logical read counter
activity_logical_reads_lasttime The last logical read sample time in milliseconds since 1970
activity_logical_reads_score A score derived from the logical read rate
activity_total_sessions The total number of sessions on the instance
disk_usage The approximate disk usage (in GB) for the instance 45.3
memory_usage The approximate memory usage (in MB) for the instance 2450
sec_after_1970 Seconds since 1970
time Current time
total_logical_reads Total logical reads
total_session_count The total number of sessions on the instance 12, 432
utc_diff_h UTC difference in hours
utc_diff_s UTC difference in seconds

Alerts and issues

Name Description Typical values
alerts_history_sec Alert history in seconds since 1970
alerts_history_sec/job_name Job name
alerts_history_sec/status Alert status
alerts_history_sec/time_stamp_txt Alert timestamp text
alerts_per_day_histr_sec Alerts per day history
alerts_per_day_histr_sec/alarm_count Alarm count
alerts_per_day_histr_sec/alert_count Alert count
alerts_per_day_histr_sec/last_alert_txt Last alert text
alerts_per_day_histr_sec/warning_count Warning count
monitoring_statistics_enabled Whether monitoring statistics are enabled

Database and instance metadata

Name Description Typical values
address_info Listener address information
database Database name
db_count The number of databases on the instance 23
dbhost Database host name
edition The edition of the instance Standard Edition, Enterprise Edition
hosttype Host type
instance_name Instance name
instance_started_sec_1970 Instance start time in seconds since 1970
iscluster Whether the instance is clustered
one Constant value one
platform_info Platform and version info
prop_user Property user
started A text representation of the start time for the instance 21.10.2020 11:39:16, 11.10.2023 11:47:08
version Sybase version

Storage and devices

Name Description Typical values
device Device usage
device/allocated_mb Allocated space in MB
device/frag_count Fragment count
device/phyname Physical device name
device/size_mb Device size in MB
device/vdevno Virtual device number
sql_repository_obj_id SQL repository object
sql_repository_obj_id/name SQL repository object name
sql_repository_obj_id/size_mb SQL repository object size in MB
sql_repository_size_mb SQL repository size in MB

Sessions and logins

Name Description Typical values
inactive_session_count The number of inactive sessions on the instance
login Login account
login/crdate Login creation date
login/dbname Database name
login/lastlogindate Last login date
login/pwdate Password date

Performance and SQL statistics

Name Description Typical values
int_sql_exec_histr_sec Internal SQL execution history
int_sql_exec_histr_sec/histr_date History date
int_sql_exec_histr_sec/main_proc Main procedure
int_sql_exec_histr_sec/sim_calc Similarity calculation
int_sql_exec_histr_sec/space_calc Space usage check
sql_statistics_avg_exec_time_ms Average SQL execution time in ms
sql_statistics_exec_time_ms SQL execution time in ms
sql_statistics_max_exec_time_ms Maximum SQL execution time in ms

Versioning and platform

Name Description Typical values
maj_version Major Sybase version
maj_version_old Major Sybase version (legacy)
maj_version_test Major Sybase version test

Miscellaneous

Name Description Typical values
obj_name_id Object name and ID
servername Server name