Windows - SQL Performance (WMI)
on
|host_description| - Windows - SQL Performance
1
120
500
on
on
2
on
on
100
0
1000
hash_0800149c3c1739ccc22cb19964b1141a14f975
0
1
1
0
hash_060014e9c43831e54eca8069317a2ce8c6f751
1
hash_0800146c04dce74207058093907598a550d387
0
1
1
0
hash_060014e9c43831e54eca8069317a2ce8c6f751
2
0
FF0000
4
1
hash_0500149b107691c743fc00234a1d088bb23023
hash_060014e9c43831e54eca8069317a2ce8c6f751
Buffer Cache Hit %:
3
0
0
9
4
hash_0500149b107691c743fc00234a1d088bb23023
hash_060014e9c43831e54eca8069317a2ce8c6f751
Current:
4
0
0
9
1
hash_0500149b107691c743fc00234a1d088bb23023
hash_060014e9c43831e54eca8069317a2ce8c6f751
Average:
5
0
0
9
3
hash_0500149b107691c743fc00234a1d088bb23023
hash_060014e9c43831e54eca8069317a2ce8c6f751
Maximum:
on
6
hash_080014edfbbda6254a1d97250584b6c2c117f9
00FF00
4
1
0
hash_060014e9c43831e54eca8069317a2ce8c6f751
Batch Requests/sec:
7
hash_080014edfbbda6254a1d97250584b6c2c117f9
0
9
4
0
hash_060014e9c43831e54eca8069317a2ce8c6f751
Current:
8
hash_080014edfbbda6254a1d97250584b6c2c117f9
0
9
1
0
hash_060014e9c43831e54eca8069317a2ce8c6f751
Average:
9
hash_080014edfbbda6254a1d97250584b6c2c117f9
0
9
3
0
hash_060014e9c43831e54eca8069317a2ce8c6f751
Maximum:
on
10
hash_080014c3ec2d66a871bec2820986176e3ae7d3
0000FF
4
1
0
hash_060014e9c43831e54eca8069317a2ce8c6f751
Transactions/sec:
11
hash_080014c3ec2d66a871bec2820986176e3ae7d3
0
9
4
0
hash_060014e9c43831e54eca8069317a2ce8c6f751
Current:
12
hash_080014c3ec2d66a871bec2820986176e3ae7d3
0
9
1
0
hash_060014e9c43831e54eca8069317a2ce8c6f751
Average:
13
hash_080014c3ec2d66a871bec2820986176e3ae7d3
0
9
3
0
hash_060014e9c43831e54eca8069317a2ce8c6f751
Maximum:
on
14
Data Source [Transactions]
task_item_id
hash_0000145bec96c03abf563072afe3422c75ef96|hash_0000145760911b873f0f43f0173a2a68b747f6|hash_000014450743f3b2098210b8347ae8372024e0|hash_000014ca58ae852de8432c89b0f55b7ac30825
Data Source [BatchRequestsPersec]
task_item_id
hash_000014a4806ad1e577d1a8a3ee4b37ae9f1ec1|hash_000014c96067f92594f996d98eadab9835c8b2|hash_000014f824783f31e0e85b14ce2ce4c06132a1|hash_00001444d9058e115b15ca5d10ec1d43afe8ca
Data Source [Buffercachehitbase]
task_item_id
hash_00001406a479b38cedc79377cabe6460ae5581|hash_00001482fcafb0ecaba2cb0ead90316e87631c
Data Source [Buffercachehit]
task_item_id
hash_0000149ce7e7fec8532d14d3483867e87836c4
Windows - SQL Transactions (WMI)
on
|host_description| - Windows - SQL Transactions
hash_03001405a203d8464bcdf10b892a5e1d0883c4
300
on
hash_150014c21df5178e5c955013591239eb0afd46|hash_1500140d9c0af8b8acdc7807943937b3208e29|hash_1500146fc2d038fb42950138b0ce3e9874cc60|hash_150014e36f3adb9f152adfa5dc50fd2b23337e
Transactions
0
100000
1
600
hash_07001458b921857a580555df5d9912f825e50d
hash_0700145a120c3218d60479ee092005e2e6b034
hash_070014e22549051b379383112286b72101bd41
hash_070014c52ab880553062b3bdf3ff98b8ac0001
Win32_PerfRawData_MSSQLSERVER_SQLServerTransactions
hash_0700142d8a136edc11759602ee92fdb9c41f4e
Transactions
hash_0700141b8ac267fdf06beb3086eb1aaef48130
cacti
hash_070014733acc470935645cbd7b2a2363c057da
Windows - SQL Statistics (WMI)
on
|host_description| - Windows - SQL Statistics
hash_03001432c173c206a87f7ef0694812bb745010
300
on
hash_150014c21df5178e5c955013591239eb0afd46|hash_1500140d9c0af8b8acdc7807943937b3208e29|hash_1500146fc2d038fb42950138b0ce3e9874cc60|hash_150014e36f3adb9f152adfa5dc50fd2b23337e
BatchRequestsPersec
0
100000000000
2
600
hash_070014cc25153dece97955bda449aef6f0b7b0
hash_0700145ef4b27e361cd604bba880beddc1b914
hash_070014548328b06e9222b26a83d2f974ae405c
hash_07001476e73713ec5bd534e1d1795680a4bcc3
BatchRequestsPersec
hash_070014eef480fe8e5b35916b5819b08def7459
Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics
hash_07001420eb758a12e5260e320a465aa31e350e
cacti
hash_070014e69fe8a3ce804b781db33757d084e2c4
Windows - SQL Buffer Manager (WMI)
|host_description| - Windows - SQL Buffer Manager
hash_0300148479b6c6f5e5babce7179623898b4403
300
on
hash_150014c21df5178e5c955013591239eb0afd46|hash_1500140d9c0af8b8acdc7807943937b3208e29|hash_1500146fc2d038fb42950138b0ce3e9874cc60|hash_150014e36f3adb9f152adfa5dc50fd2b23337e
Buffercachehit
0
10000
1
600
hash_070014ae306f84c43851efb267dc5e15e130b7
Buffercachehitbase
0
10000
1
600
hash_070014efb014ab72680f7a9120aa8659420389
hash_070014bae07e1bba8c44fc7d677302d6113d1d
hash_070014307bc0d2a8629ea213d7dd4aebe61a50
hash_0700144a0da5d0067ac4a6f7363cae24bd4745
Buffercachehitratio,Buffercachehitratio_Base
hash_070014b54681afa7ed5b514c6d868990ddca24
Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager
hash_070014b943e3804f3c783388515bdc0babbfa5
cacti
hash_070014dd6fb328b93fe8725498b5e5d8fc1118
WMI - SQL Transactions
1
/usr/bin/php -q <path_cacti>/wmi.php <host> <credential> <class> <columns> <filter> <filterval>
Hostname
hostname
in
host
Credential
in
credential
Class
in
class
Columns
in
columns
Filter
on
in
filter
Filter Value
on
in
filterval
Transactions
on
out
Transactions
WMI - SQL Statistics
1
/usr/bin/php -q <path_cacti>/wmi.php <host> <credential> <class> <columns> <filter> <filterval>
Hostname
hostname
in
host
Credential
in
credential
Class
in
class
Columns
in
columns
Filter
on
in
filter
Filter Value
on
in
filterval
BatchRequestsPersec
on
out
BatchRequestsPersec
WMI - SQL Buffer Manager
1
/usr/bin/php -q <path_cacti>/wmi.php <host> <credential> <class> <columns> <filter> <filterval>
Hostname
hostname
in
host
Credential
in
credential
Class
in
class
Columns
in
columns
Filter
on
in
filter
Filter Value
on
in
filterval
Buffercachehitratio
on
out
Buffercachehitratio
Buffercachehitratio_Base
on
out
Buffercachehitratio_Base
Daily (5 Minute Average)
0.5
1
600
86400
1|2|3|4
Weekly (30 Minute Average)
0.5
6
700
604800
1|2|3|4
Monthly (2 Hour Average)
0.5
24
775
2678400
1|2|3|4
Yearly (1 Day Average)
0.5
288
797
33053184
1|2|3|4
WMI - Percentage Ratio
1
6
a
2
6
b
3
2
4
4
6
100
5
2
3
Normal
%8.2lf %s