SQL Blocking 1 120 500 on 2 on on 100 0 1000 hash_0800110c3320095bdd8b0600c0a7f0ed24e644 FF0000 6 1 0 hash_060011e9c43831e54eca8069317a2ce8c6f751 Users Blocked 1 hash_0800110c3320095bdd8b0600c0a7f0ed24e644 0 9 4 0 hash_060011e9c43831e54eca8069317a2ce8c6f751 current 2 hash_0800110c3320095bdd8b0600c0a7f0ed24e644 0 9 1 0 hash_060011e9c43831e54eca8069317a2ce8c6f751 average 3 hash_0800110c3320095bdd8b0600c0a7f0ed24e644 0 9 3 0 hash_060011e9c43831e54eca8069317a2ce8c6f751 min on 4 hash_0800119fd629546225950fd5ddb0f8bda72013 750F7D 5 1 0 hash_060011e9c43831e54eca8069317a2ce8c6f751 Total Blocking Locks 5 hash_0800119fd629546225950fd5ddb0f8bda72013 0 1 4 0 hash_060011e9c43831e54eca8069317a2ce8c6f751 current 6 hash_0800119fd629546225950fd5ddb0f8bda72013 0 9 1 0 hash_060011e9c43831e54eca8069317a2ce8c6f751 average 7 hash_0800119fd629546225950fd5ddb0f8bda72013 0 9 3 0 hash_060011e9c43831e54eca8069317a2ce8c6f751 max on 8 Data Source [TotalBlockingLocks] task_item_id hash_0000119a080a5f52a3befcac97b33aa3f2a18b|hash_0000115f4e9d3ac4597201c6c49fe2c1064bc1|hash_0000117019cbe03218fbcf00b0b0ca5cea89d5|hash_0000115e08269eb3142098562fb28107e1bebd Data Source [UsersBlocked] task_item_id hash_00001189b738265cb524100dd60435e5d8fc54|hash_0000115db7bfa828bf3e442e006b460b53a406|hash_000011d77cba44e79ad3b775e7ff0a29116936|hash_000011f6ca6583b1de8b0897c6e35b0f21d60a 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