SCOMSQL01 OpsMgr SQL Server

Weekly Stats from: 04/26/2019 - 05/02/2019

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Processor % Usage00000000
Max Processor % Usage99.9499.9897.3599.7394.0191.9194.1199.98
Avg Processor % Usage19.1220.9622.822.7316.3316.7919.0119.68

Available Memory Statistics (MB)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Available Memory (MB)1414.651425.721398.4669.041897.711591.21819.2369.04
Max Available Memory (MB)2190.772146.192034.453122.892995.342549.492550.743122.89
Avg Available Memory (MB)1937.881924.651892.012304.892767.722321.412395.632220.6

Working Set (Used Memory) Statistics (MB)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Working Set (MB)13547.2313575.2413713.1612521.812678.4913200.1613199.2812521.8
Max Working Set (MB)14229.0314241.6814263.1414232.4213502.7714036.8913869.914263.14
Avg Working Set (MB)13794.8313814.9713856.9913362.9612842.3613414.0613340.3413489.5

Cache Bytes Statistics (MB)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Cache Bytes (MB)273.46272.55270.1253.17259.04262.09262.93253.17
Max Cache Bytes (MB)516.89501.14678.721050.73574.75486.82502.281050.73
Avg Cache Bytes (MB)291.14291.91298.88311.9336.6285.5285.18300.16

Pool Non-Paged Bytes Statistics (MB)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Non-Paged Pool Bytes (MB)81.0781.6782.1480.9982.7376.6976.7176.69
Max Non-Paged Pool Bytes (MB)89.0289.0186.4393.4785.7779.9389.2893.47
Avg Non-Paged Pool Bytes (MB)81.6282.7282.6881.9183.0376.7576.8380.79

% CPU Privileged Time Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Priv CPU Usage00000000
Max Priv CPU Usage15.3313.7615.319.5217.5216.8611.9519.52
Avg Priv CPU Usage0.860.890.891.030.961.661.771.15

% CPU User Time Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min User CPU Usage00000000
Max User CPU Usage87.7188.4587.791.0782.7382.384.5891.07
Avg User CPU Usage18.2620.0721.9121.6915.3715.1317.2418.52

Processor Queue Length Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Processor Queue Length00000000
Max Processor Queue Length131161155413
Avg Processor Queue Length0.20.220.230.210.160.150.160.19

% Page File Usage Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min PageFile % Usage5.565.414.694.6913.850.790.820.79
Max PageFile % Usage6.196.936.3436.7219.561.291.2536.72
Avg PageFile % Usage5.946.145.6713.1815.91.161.167.02

Pages/second Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Pages/sec00000000
Max Pages/sec58123.0850892.2747579.3446577.383518.3343691.372589.8858123.08
Avg Pages/sec113.6107.42121.83143.819.22102.988.8386.81

Page Reads/second Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Page Reads/sec00000000
Max Page Reads/sec1848.151639.841579.931468.69444.951395.26258.311848.15
Avg Page Reads/sec4.334.355.66.540.863.890.783.76

Page Writes/second Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Page Writes/sec00000000
Max Page Writes/sec111146.71111146.71
Avg Page Writes/sec00.0100.0800.0100.01

Disk Percent Usage

Drive04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019
C - 100GB52.952.952.852.852.851.951.9
D - 100GB0.80.80.80.80.80.80.8
F - 200GB71.671.671.671.671.671.671.6
L - 100GB24.324.324.324.324.324.324.3
T - 100GB11.311.311.311.311.311.311.3
U - 100GB33.934.134.234.534.530.932.1

Used Disk Space (GB)

Drive04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019
C - 100GB52.852.852.752.752.751.851.8
D - 100GB0.80.80.80.80.80.80.8
F - 200GB143.2143.2143.2143.2143.2143.2143.2
L - 100GB24.324.324.324.324.324.324.3
T - 100GB11.311.311.311.311.311.311.3
U - 100GB33.934.134.234.434.430.832.1

Free Disk Space (GB)

Drive04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019
C - 100GB47.147.147.247.247.248.148.1
D - 100GB99.299.299.299.299.299.299.2
F - 200GB56.856.856.856.856.856.856.8
L - 100GB75.775.775.775.775.775.775.7
T - 100GB88.688.688.688.688.688.688.6
U - 100GB6665.865.765.465.46967.8

Disk Write Latency (milliseconds)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Disk Write Latency00000000
Max Disk Write Latency24.521.2625.6727.8613.3518.311.1427.86
Avg Disk Write Latency0.80.911.030.960.810.740.770.86

Disk Read Latency (milliseconds)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Disk Read Latency00000000
Max Disk Read Latency23.5553.6733.9958.17136.2823.1648.89136.28
Avg Disk Read Latency0.70.750.80.860.880.70.720.77

Disk Split IO per second Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Disk Split I/Os00000000
Max Disk Split I/Os35.9337.3882.846.3337.48212.2434.47212.24
Avg Disk Split I/Os0.470.440.50.470.440.450.410.45

Current Disk Queue Length Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Current Disk Queue Length00000000
Max Current Disk Queue Length255206235135191141227255
Avg Current Disk Queue Length0.230.270.290.250.180.240.230.24

Average Disk Queue Length Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Avgerage Disk Queue Length00000000
Max Avgerage Disk Queue Length40.0328.6629.0227.97116.514.0319.99116.5
Avg Avgerage Disk Queue Length0.340.370.480.30.240.230.250.32

Disk Read Throughput (Mb/sec) Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Disk Read Mb/sec00000000
Max Disk Read Mb/sec463.98505.07480.4448.75365.71459.14472.08505.07
Avg Disk Read Mb/sec1.861.882.452.181.481.721.371.85

Disk Write Throughput (Mb/sec) Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Disk Write Mb/sec00000000
Max Disk Write Mb/sec289.66370.67317.29317.01301.32297.86278.31370.67
Avg Disk Write Mb/sec3.83.984.514.093.513.593.573.86

Total Net Received Throughput (Mb/sec) Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Net Received Mb/sec00000000
Max Net Received Mb/sec11.7614.358.838.117.6610.578.2214.35
Avg Net Received Mb/sec0.370.390.40.420.340.410.410.39

Total Net Sent Throughput (Mb/sec) Statistics

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min Net Sent Mb/sec00000000
Max Net Sent Mb/sec128.84136.04138.68126.4993.81122.29131.73138.68
Avg Net Sent Mb/sec1.091.021.130.970.820.940.880.98

SQL User Connections

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL User Connections119128131120107130121107
Max SQL User Connections213238259227199234221259
Avg SQL User Connections159.05165.21168.43162.27148.99162.01161.41161.05

SQL Compilations/sec

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Compilations/sec00000000
Max SQL Compilations/sec284.1221.31259.31176.93208.68247.49231.11284.1
Avg SQL Compilations/sec43.243.214436.9636.941.8942.1641.19

SQL Re-Compilations/sec

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Re-Compilations/sec00000000
Max SQL Re-Compilations/sec193.35180.14236.42147.61136.83171.12213.41236.42
Avg SQL Re-Compilations/sec19.719.6219.914.4915.0919.2619.0918.16

SQL Batch Req/sec

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Batch Req/sec00000000
Max SQL Batch Req/sec1937.812390.451807.172019.971527.621603.351501.362390.45
Avg SQL Batch Req/sec239.97241.14247.91228.01217.63230.84227.89233.34

Log Flushes/sec

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Log Flushes00000000
Max SQL Log Flushes1892.891243.9112731476.571331.021978.492006.292006.29
Avg SQL Log Flushes73.6975.1374.2764.7665.1269.567.9470.06

Lazy Writes/sec

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Lazy Writes00000000
Max SQL Lazy Writes495.8296331.55302.35192.3397.35200.55495.82
Avg SQL Lazy Writes0.30.180.260.210.270.080.10.2

Page Splits/sec

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Page Splits00000000
Max SQL Page Splits4690.33541.724258.94410.394400.614230.112327.14690.3
Avg SQL Page Splits70.5934.3145.5953.2324.0127.0927.240.29

SQL Buffer Cache Hit Ratio

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Buffer Cache Hit Ratio57.769999.5152.4498.6674.9197.5752.44
Max SQL Buffer Cache Hit Ratio100100100100100100100100
Avg SQL Buffer Cache Hit Ratio99.9910010099.99100100100100

SQL Cache Memory (MB)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Cache Memory27.7231.8530.2428.9528.12529.6625
Max SQL Cache Memory34.4233.7533.7733.7932.5730.9731.7234.42
Avg SQL Cache Memory32.2832.5932.0531.1730.8329.3430.2731.22

SQL Total Memory (GB)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Total Mem10.7410.7410.7410.7410.7410.7410.7410.74
Max SQL Total Mem10.7410.7410.7410.7410.7410.7410.7410.74
Avg SQL Total Mem10.7410.7410.7410.7410.7410.7410.7410.74

SQL Target Memory (GB)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Target Mem10.7410.7410.7410.7410.7410.7410.7410.74
Max SQL Target Mem10.7410.7410.7410.7410.7410.7410.7410.74
Avg SQL Target Mem10.7410.7410.7410.7410.7410.7410.7410.74

SQL Processes Blocked

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Processes Blocked00000000
Max SQL Processes Blocked1414263981226
Avg SQL Processes Blocked0.050.040.050.030.040.040.060.04

SQL DeadLocks/sec

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL DeadLocks/sec00000000
Max SQL DeadLocks/sec0.30.20.40.20.40.20.30.4
Avg SQL DeadLocks/sec00000000

SQL Locks Avg Wait (ms)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Locks Avg Wait00000000
Max SQL Locks Avg Wait47471486710909.264992516985906.2916402.9551698
Avg SQL Locks Avg Wait74.1562.6171.0563.5983.975456.9666.62

SQL Latches Avg Wait (ms)

Counter04/26/201904/27/201904/28/201904/29/201904/30/201905/01/201905/02/2019Total
Min SQL Latches Avg Wait00000000
Max SQL Latches Avg Wait15.614.211.1513.317.116.2115.3116.21
Avg SQL Latches Avg Wait0.850.851.111.210.750.570.670.86