SCOMSQL01 OpsMgr SQL Server

Weekly Stats from: 09/15/2019 - 09/21/2019

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Processor % Usage00000000
Max Processor % Usage99.4198.9597.3395.9199.4999.6999.4399.69
Avg Processor % Usage20.1517.1123.2620.3818.5218.1817.4319.29

Available Memory Statistics (MB)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Available Memory (MB)1245.351482.331607.161176.061249.221420.091680.331176.06
Max Available Memory (MB)2498.752406.262455.22424.312383.62361.412463.442498.75
Avg Available Memory (MB)2279.722224.942291.342224.362226.92184.582210.932234.68

Working Set (Used Memory) Statistics (MB)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Working Set (MB)13256.2313339.2313310.0913334.4113343.713380.7513313.513256.23
Max Working Set (MB)14345.814242.6414059.4314491.8314320.7114306.3413991.3214491.83
Avg Working Set (MB)13454.513520.7413457.2413518.9613513.7213558.1513538.3413508.81

Cache Bytes Statistics (MB)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Cache Bytes (MB)272.68274.32274.32275.38276.16276.09276.2272.68
Max Cache Bytes (MB)478.05575.12515.5579.31514.71580.78499.61580.78
Avg Cache Bytes (MB)294.17299.48303.13301.27302.69301.21299.58300.22

Pool Non-Paged Bytes Statistics (MB)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Non-Paged Pool Bytes (MB)78.7779.0278.9380.4680.1280.6780.6378.77
Max Non-Paged Pool Bytes (MB)83.2582.3988.3586.8887.284.1186.9988.35
Avg Non-Paged Pool Bytes (MB)79.8179.1880.4280.5980.781.0181.0180.39

% CPU Privileged Time Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Priv CPU Usage00000000
Max Priv CPU Usage17.712.4122.5622.3217.1217.3118.7922.56
Avg Priv CPU Usage1.091.011.621.131.021.020.971.12

% CPU User Time Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min User CPU Usage00000000
Max User CPU Usage84.0489.3486.8482.7684.885.0887.5389.34
Avg User CPU Usage19.0516.121.6419.2517.4917.1516.4518.16

Processor Queue Length Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Processor Queue Length00000000
Max Processor Queue Length95755799
Avg Processor Queue Length0.180.150.20.170.180.170.150.17

% Page File Usage Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min PageFile % Usage1.021.161.111.131.191.161.191.02
Max PageFile % Usage1.61.831.771.661.641.631.631.83
Avg PageFile % Usage1.431.511.491.511.511.521.541.5

Pages/second Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Pages/sec00000000
Max Pages/sec52443.533438.218624.4756444.754434.3355313.8852997.6956444.7
Avg Pages/sec112.469.6713.24110.17110.24111.25119.3783.77

Page Reads/second Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Page Reads/sec00000000
Max Page Reads/sec1692.32434.16433.451794.11775.081791.061675.281794.1
Avg Page Reads/sec4.340.831.094.134.094.224.433.3

Page Writes/second Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Page Writes/sec00000000
Max Page Writes/sec1111111.11.1
Avg Page Writes/sec0.010.010.010.0100.010.010.01

Disk Percent Usage

Drive09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019
C - 100GB525251.951.951.951.951.9
D - 100GB0.80.80.80.80.80.80.8
F - 200GB71.671.671.771.671.671.671.6
L - 100GB24.324.324.324.324.324.324.3
T - 100GB11.311.311.311.311.311.311.3
U - 100GB3437.237.233.433.133.235.8

Used Disk Space (GB)

Drive09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019
C - 100GB51.951.951.951.951.951.951.9
D - 100GB0.80.80.80.80.80.80.8
F - 200GB143.2143.2143.3143.2143.2143.2143.2
L - 100GB24.324.324.324.324.324.324.3
T - 100GB11.311.311.311.311.311.311.3
U - 100GB33.937.237.233.433.133.135.8

Free Disk Space (GB)

Drive09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019
C - 100GB48484848484848
D - 100GB99.299.299.299.299.299.299.2
F - 200GB56.856.856.756.856.856.856.8
L - 100GB75.775.775.775.775.775.775.7
T - 100GB88.688.688.688.688.688.688.6
U - 100GB65.962.762.766.566.866.764.1

Disk Write Latency (milliseconds)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Disk Write Latency00000000
Max Disk Write Latency16.7613.9814.6721.0717.1218.4312.7121.07
Avg Disk Write Latency0.780.810.80.730.720.880.740.78

Disk Read Latency (milliseconds)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Disk Read Latency00000000
Max Disk Read Latency19.2427.2540.3921.5921.7625.2229.8440.39
Avg Disk Read Latency0.850.770.730.760.720.920.850.8

Disk Split IO per second Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Disk Split I/Os00000000
Max Disk Split I/Os35.3736.6340.7336.2837.2336.2839.1340.73
Avg Disk Split I/Os0.470.460.440.460.450.460.470.46

Current Disk Queue Length Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Current Disk Queue Length00000000
Max Current Disk Queue Length12523814016842250239250
Avg Current Disk Queue Length0.180.270.280.210.150.220.190.21

Average Disk Queue Length Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Avgerage Disk Queue Length00000000
Max Avgerage Disk Queue Length44.2518.2626.2628.6819.3924.6531.5144.25
Avg Avgerage Disk Queue Length0.230.30.270.240.260.290.250.26

Disk Read Throughput (Mb/sec) Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Disk Read Mb/sec00000000
Max Disk Read Mb/sec484.88487.44454465.95476.58469.74473.76487.44
Avg Disk Read Mb/sec1.861.63.232.041.991.741.932.06

Disk Write Throughput (Mb/sec) Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Disk Write Mb/sec00000000
Max Disk Write Mb/sec397.62302.45367.73351.07360.7470.04332.9470.04
Avg Disk Write Mb/sec3.424.25.163.893.833.623.864

Total Net Received Throughput (Mb/sec) Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Net Received Mb/sec00000000
Max Net Received Mb/sec10.4110.519.048.0211.8210.1710.2511.82
Avg Net Received Mb/sec0.360.350.350.360.370.340.350.35

Total Net Sent Throughput (Mb/sec) Statistics

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min Net Sent Mb/sec00000000
Max Net Sent Mb/sec128.09137.72138.02129.61136.28119.92124.39138.02
Avg Net Sent Mb/sec0.980.780.931.351.010.9411

SQL User Connections

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL User Connections120122120127119119121119
Max SQL User Connections218215218236225226235236
Avg SQL User Connections154.45152.7152.38155.24150.77153.61151.84153

SQL Compilations/sec

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Compilations/sec00000000
Max SQL Compilations/sec219.05213.87253.56217.58209.17227.02242.1253.56
Avg SQL Compilations/sec41.3640.6442.5541.7741.5340.8341.4741.45

SQL Re-Compilations/sec

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Re-Compilations/sec00000000
Max SQL Re-Compilations/sec172.02185.7224.77189.93169.01205.83197.95224.77
Avg SQL Re-Compilations/sec19.1118.4719.4319.719.419.1619.4119.24

SQL Batch Req/sec

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Batch Req/sec00000000
Max SQL Batch Req/sec1961.42173.792058.811532.041658.261811.431798.092173.79
Avg SQL Batch Req/sec234.77230.42231.54232.21239.47225.98231.21232.23

Log Flushes/sec

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Log Flushes00000000
Max SQL Log Flushes1094.541469.971165.321255.491354.791363.721193.391469.97
Avg SQL Log Flushes71.769.9472.1573.5573.6272.0972.1572.17

Lazy Writes/sec

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Lazy Writes00000000
Max SQL Lazy Writes367.48140.19102.33341.92302.98580.06441.49580.06
Avg SQL Lazy Writes0.520.950.330.460.440.320.410.49

Page Splits/sec

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Page Splits00000000
Max SQL Page Splits3705.137597.9442153222.314803.994889.144512.247597.94
Avg SQL Page Splits266.05266.67269.6266.19264.97104.0950.21212.54

SQL Buffer Cache Hit Ratio

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Buffer Cache Hit Ratio98.9338.0298.3585.0154.4672.0597.7738.02
Max SQL Buffer Cache Hit Ratio100100100100100100100100
Avg SQL Buffer Cache Hit Ratio99.9999.9710099.9999.9899.9910099.99

SQL Cache Memory (MB)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Cache Memory28.831.4129.8127.0630.430.5929.8127.06
Max SQL Cache Memory34.0733.5836.5432.9834.835.1332.5936.54
Avg SQL Cache Memory32.4232.0633.7331.7933.833.1332.2932.75

SQL Total Memory (GB)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/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)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/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

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Processes Blocked00000000
Max SQL Processes Blocked13121161141013
Avg SQL Processes Blocked0.060.060.060.050.070.040.060.06

SQL DeadLocks/sec

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL DeadLocks/sec00000000
Max SQL DeadLocks/sec0.30.20.30.30.40.20.40.4
Avg SQL DeadLocks/sec00000000

SQL Locks Avg Wait (ms)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Locks Avg Wait00000000
Max SQL Locks Avg Wait84440.138517.418959.8623345.8244855.75489948070.3384440.13
Avg SQL Locks Avg Wait86.879.0176.9789.1886.0470.6785.1881.98

SQL Latches Avg Wait (ms)

Counter09/15/201909/16/201909/17/201909/18/201909/19/201909/20/201909/21/2019Total
Min SQL Latches Avg Wait00000000
Max SQL Latches Avg Wait35.7210.6153.7438.4412.0819.397.9653.74
Avg SQL Latches Avg Wait1.040.830.880.990.780.80.910.89