Windows - SQL Server - Processes Blocked
|host_description| - SQL Server - Processes Blocked
1
150
600
on
on
2
on
on
0
0
1000
procs
hash_0800199bad85593f6c427d504738f744f81488
D6883A
4C
7
1
0
hash_06001919414480d6897c8731c7dc6c5310653e
1
hash_0800199bad85593f6c427d504738f744f81488
D6883A
FF
4
1
0
hash_06001919414480d6897c8731c7dc6c5310653e
Processes Blocked
2
hash_0800199bad85593f6c427d504738f744f81488
0
FF
9
4
0
hash_06001919414480d6897c8731c7dc6c5310653e
Current:
3
hash_0800199bad85593f6c427d504738f744f81488
0
FF
9
1
0
hash_06001919414480d6897c8731c7dc6c5310653e
Average:
4
hash_0800199bad85593f6c427d504738f744f81488
0
FF
9
3
0
hash_06001919414480d6897c8731c7dc6c5310653e
Maximum:
on
6
Data Source [mssql_procs_blocked]
task_item_id
hash_00001921cfb6acfdae585a4af73f24a4582f22|hash_000019690afa338a62fbbe8174bb1fc9c48ae5|hash_00001975f3f4b9c8daeb215697613800cf3b50|hash_000019b21cac9d3bb32175357a1074c29a7bf9|hash_000019280df8abe6ee90eaa5682692a327512a|hash_0000190dd1db85b8f2b7d08a9c7f573c4116de
Windows - SQL Server - Processes Blocked
|host_description| - SQL Server - Processes Blocked
hash_0300199dda811739f34a1323dabe11dcd7f8f6
300
on
hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5
mssql_procs_blocked
0
10000
1
600
hash_0700194ead5ea36fe74c0aee39f9e4fb4df4e6
hash_0700191ba0c2888e5f7852bccdb04aec691842
hash_0700196263033dbca030500c11a68fddade9a8
on
hash_0700192d5aadff482008d18b0cdf8b96c5820c
on
hash_07001944eafbd65af147d9d782cb8062d11e57
on
Windows - SQL Server - Processes Blocked
5
<path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> procsblocked <user> <password>
Hostname
hostname
in
hostname
SQL Port
on
in
port
SQL username
on
in
user
SQL Password
on
in
password
Number of Blocked Processes
on
out
processesblocked
Daily (5 Minute Average)
0.5
1
1440
86400
1|3
Weekly (5 Minute Average)
0.5
1
8928
604800
1|3
Monthly (5 Minute Average)
0.5
1
25920
2678400
1|3
Yearly (30 Minute Average)
0.5
6
35040
31536000
1|3
Hourly (1 Minute Average)
0.5
1
500
14400
1|3
3 Year (2 Hour Average)
0.5
24
13140
94608000
1|3
Exact Numbers
%8.0lf