SQL Users and Locks
|host_description| - SQL Users and Locks
1
120
500
on
2
on
on
100
0
1000
hash_080011e7277a83ee3a5885a6eb3491c830e47d
005199
6
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
User Connections
1
hash_080011e7277a83ee3a5885a6eb3491c830e47d
0
9
4
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
current
2
hash_080011e7277a83ee3a5885a6eb3491c830e47d
0
9
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
average
3
hash_080011e7277a83ee3a5885a6eb3491c830e47d
0
9
3
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
max
on
4
hash_0800114d602370bc46c57b7f066b7a1a08a7ba
942D0C
5
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Total Locks
5
hash_0800114d602370bc46c57b7f066b7a1a08a7ba
0
9
4
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
current
6
hash_0800114d602370bc46c57b7f066b7a1a08a7ba
0
9
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
average
7
hash_0800114d602370bc46c57b7f066b7a1a08a7ba
0
9
3
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
max
on
8
Data Source [UserConnections]
task_item_id
hash_00001112da206d579bcdf297dfb0104ed35075|hash_000011f99c64a68aa2c1fb156ec3de2687c379|hash_0000117eaa74593e0986d526864679a0cecfa0|hash_0000117e33fdfafc82b13666dee401912fec2e
Data Source [TotalLocks]
task_item_id
hash_000011167dae83130bcb0e2613c466f7999f8d|hash_0000117180fd5cc64dcdfd05ae7f64c6dc4af6|hash_00001128b5a1c3b77db08e07dc71efcf109945|hash_00001127949e4d1245f7dcbc4d436f218e3075
aSQLSTATS
|host_description| - aSQLSTATS
hash_030011e19fc274aea79d03a786f5621c3ffc1c
300
on
hash_150011c21df5178e5c955013591239eb0afd46|hash_1500110d9c0af8b8acdc7807943937b3208e29|hash_1500116fc2d038fb42950138b0ce3e9874cc60|hash_150011e36f3adb9f152adfa5dc50fd2b23337e|hash_1500117c2e7d2c249a45b5bef63d03b3c1962f
UserConnections
0
1000
1
600
hash_070011449b6eba096a9f4746d367c826d64cae
TotalBlockingLocks
0
1000
1
600
hash_07001155864919f6760c46f0260c8bee6b2fb7
TotalLocks
0
1000
1
600
hash_0700119ed3d512efd0437d56c4a7bd1a4c1f3e
UsersBlocked
0
1000
1
600
hash_070011b054ffaf0a025671dca5e401caad3aea
hash_0700119ec16be93d1bcc9af4dff4990061ca9a
hash_07001161051c9263a83ebf58ce6895c9e44f5f
GETSQLSTATS
1
perl <path_cacti>/scripts/SQL_STATS.pl <management_ip> <snmp_community> <snmp_username> <snmp_password> <snmp_version>
SNMP IP Address
hostname
in
management_ip
SNMP Community
snmp_community
in
snmp_community
Total Locks
on
out
TotalLocks
User Connections
on
out
UserConnections
Total Blocking Locks
on
out
TotalBlockingLocks
Users Blocked
on
out
UsersBlocked
Daily (5 Minute Average)
0.5
1
25920
7776000
1|2|3|4
Weekly (30 Minute Average)
0.5
6
9000
7776000
1|2|3|4
Monthly (2 Hour Average)
0.5
24
2250
7776000
1|2|3|4
Yearly (1 Day Average)
0.5
288
797
33053184
1|2|3|4
Yearly (2 Hour Average)
0.5
24
9300
33053184
1|3|4
Normal
%8.2lf %s