SCOMSQL01 OpsMgr SQL Server

Weekly Stats from: 04/12/2019 - 04/18/2019

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Processor % Usage00000000
Max Processor % Usage98.7999.8899.6399.4198.9597.3395.9199.88
Avg Processor % Usage21.5925.3220.5920.1517.1123.2620.3821.2

Available Memory Statistics (MB)

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Available Memory (MB)1575.131375.761250.111245.351482.331607.161176.061176.06
Max Available Memory (MB)2451.892459.572419.362498.752406.262455.22424.312498.75
Avg Available Memory (MB)2288.722283.242263.082279.722224.942291.342224.362265.06

Working Set (Used Memory) Statistics (MB)

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Working Set (MB)13258.7413291.6813329.313256.2313339.2313310.0913334.4113256.23
Max Working Set (MB)14064.4114271.6714407.7214345.814242.6414059.4314491.8314491.83
Avg Working Set (MB)13443.2913457.2613492.713454.513520.7413457.2413518.9613477.81

Cache Bytes Statistics (MB)

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Cache Bytes (MB)271.96272.18271.63272.68274.32274.32275.38271.63
Max Cache Bytes (MB)617.93514.92618.37478.05575.12515.5579.31618.37
Avg Cache Bytes (MB)294.66298.42298.62294.17299.48303.13301.27298.54

Pool Non-Paged Bytes Statistics (MB)

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Non-Paged Pool Bytes (MB)77.9378.4378.9678.7779.0278.9380.4677.93
Max Non-Paged Pool Bytes (MB)84.7985.4686.0583.2582.3988.3586.8888.35
Avg Non-Paged Pool Bytes (MB)78.3979.1179.7579.8179.1880.4280.5979.61

% CPU Privileged Time Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Priv CPU Usage00000000
Max Priv CPU Usage17.4517.5919.2817.712.4122.5622.3222.56
Avg Priv CPU Usage1.041.11.071.091.011.621.131.15

% CPU User Time Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min User CPU Usage00000000
Max User CPU Usage97.485.9383.1284.0489.3486.8482.7697.4
Avg User CPU Usage20.5524.2119.5219.0516.121.6419.2520.05

Processor Queue Length Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Processor Queue Length00000000
Max Processor Queue Length6159957515
Avg Processor Queue Length0.20.250.20.180.150.20.170.19

% Page File Usage Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min PageFile % Usage1.091.151.091.021.161.111.131.02
Max PageFile % Usage1.591.691.751.61.831.771.661.83
Avg PageFile % Usage1.481.491.481.431.511.491.511.48

Pages/second Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Pages/sec00000000
Max Pages/sec51702.3349402.9955161.0252443.533438.218624.4756444.756444.7
Avg Pages/sec112.7112.95114.11112.469.6713.24110.1783.61

Page Reads/second Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Page Reads/sec00000000
Max Page Reads/sec1648.651559.211734.881692.32434.16433.451794.11794.1
Avg Page Reads/sec4.184.254.294.340.831.094.133.3

Page Writes/second Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Page Writes/sec00000000
Max Page Writes/sec111.111111.1
Avg Page Writes/sec0.0100.010.010.010.010.010.01

Disk Percent Usage

Drive04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019
C - 100GB525252525251.951.9
D - 100GB0.80.80.80.80.80.80.8
F - 200GB71.671.671.671.671.671.771.6
L - 100GB24.324.324.324.324.324.324.3
T - 100GB11.311.311.311.311.311.311.3
U - 100GB33.833.9343437.237.233.4

Used Disk Space (GB)

Drive04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019
C - 100GB51.951.951.951.951.951.951.9
D - 100GB0.80.80.80.80.80.80.8
F - 200GB143.2143.2143.2143.2143.2143.3143.2
L - 100GB24.324.324.324.324.324.324.3
T - 100GB11.311.311.311.311.311.311.3
U - 100GB33.733.933.933.937.237.233.4

Free Disk Space (GB)

Drive04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019
C - 100GB48484848484848
D - 100GB99.299.299.299.299.299.299.2
F - 200GB56.856.856.856.856.856.756.8
L - 100GB75.775.775.775.775.775.775.7
T - 100GB88.688.688.688.688.688.688.6
U - 100GB66.16665.965.962.762.766.5

Disk Write Latency (milliseconds)

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Disk Write Latency00000000
Max Disk Write Latency13.2218.2511.9816.7613.9814.6721.0721.07
Avg Disk Write Latency0.80.880.690.780.810.80.730.78

Disk Read Latency (milliseconds)

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Disk Read Latency00000000
Max Disk Read Latency34.4135.9425.9919.2427.2540.3921.5940.39
Avg Disk Read Latency0.750.920.80.850.770.730.760.8

Disk Split IO per second Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Disk Split I/Os00000000
Max Disk Split I/Os33.6735.8738.1635.3736.6340.7336.2840.73
Avg Disk Split I/Os0.440.480.470.470.460.440.460.46

Current Disk Queue Length Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Current Disk Queue Length00000000
Max Current Disk Queue Length186247235125238140168247
Avg Current Disk Queue Length0.20.340.210.180.270.280.210.24

Average Disk Queue Length Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Avgerage Disk Queue Length00000000
Max Avgerage Disk Queue Length31.2931.5984.4744.2518.2626.2628.6884.47
Avg Avgerage Disk Queue Length0.260.280.220.230.30.270.240.26

Disk Read Throughput (Mb/sec) Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Disk Read Mb/sec00000000
Max Disk Read Mb/sec450.81421.94415.95484.88487.44454465.95487.44
Avg Disk Read Mb/sec2.111.881.921.861.63.232.042.09

Disk Write Throughput (Mb/sec) Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Disk Write Mb/sec00000000
Max Disk Write Mb/sec393.93420.55415.64397.62302.45367.73351.07420.55
Avg Disk Write Mb/sec3.953.593.73.424.25.163.893.99

Total Net Received Throughput (Mb/sec) Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Net Received Mb/sec00000000
Max Net Received Mb/sec13.6812.079.6410.4110.519.048.0213.68
Avg Net Received Mb/sec0.360.350.360.360.350.350.360.36

Total Net Sent Throughput (Mb/sec) Statistics

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min Net Sent Mb/sec00000000
Max Net Sent Mb/sec107.87125.88109.93128.09137.72138.02129.61138.02
Avg Net Sent Mb/sec1.070.980.990.980.780.931.351.01

SQL User Connections

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL User Connections121122117120122120127117
Max SQL User Connections243224233218215218236243
Avg SQL User Connections154.68155.89156.36154.45152.7152.38155.24154.53

SQL Compilations/sec

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Compilations/sec00000000
Max SQL Compilations/sec211.56206.01247.58219.05213.87253.56217.58253.56
Avg SQL Compilations/sec41.4540.8841.6541.3640.6442.5541.7741.47

SQL Re-Compilations/sec

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Re-Compilations/sec00000000
Max SQL Re-Compilations/sec184.42177.33214.77172.02185.7224.77189.93224.77
Avg SQL Re-Compilations/sec19.2918.7519.3619.1118.4719.4319.719.16

SQL Batch Req/sec

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Batch Req/sec00000000
Max SQL Batch Req/sec1912.031749.861784.931961.42173.792058.811532.042173.79
Avg SQL Batch Req/sec237.05227.59234.36234.77230.42231.54232.21232.56

Log Flushes/sec

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Log Flushes00000000
Max SQL Log Flushes1274.711457.671209.731094.541469.971165.321255.491469.97
Avg SQL Log Flushes69.3966.771.3871.769.9472.1573.5570.69

Lazy Writes/sec

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Lazy Writes00000000
Max SQL Lazy Writes666.96401.26280.51367.48140.19102.33341.92666.96
Avg SQL Lazy Writes0.270.530.460.520.950.330.460.5

Page Splits/sec

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Page Splits00000000
Max SQL Page Splits3179.054127.444431.763705.137597.9442153222.317597.94
Avg SQL Page Splits61.96182.57265.93266.05266.67269.6266.19225.57

SQL Buffer Cache Hit Ratio

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Buffer Cache Hit Ratio52.0383.3558.7198.9338.0298.3585.0138.02
Max SQL Buffer Cache Hit Ratio100100100100100100100100
Avg SQL Buffer Cache Hit Ratio99.9999.9999.9999.9999.9710099.9999.99

SQL Cache Memory (MB)

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Cache Memory26.2727.1730.5628.831.4129.8127.0626.27
Max SQL Cache Memory31.8633.7331.734.0733.5836.5432.9836.54
Avg SQL Cache Memory30.5331.6431.132.4232.0633.7331.7931.9

SQL Total Memory (GB)

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/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/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/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/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Processes Blocked00000000
Max SQL Processes Blocked2669131211626
Avg SQL Processes Blocked0.090.050.060.060.060.060.050.06

SQL DeadLocks/sec

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL DeadLocks/sec00000000
Max SQL DeadLocks/sec0.30.30.30.30.20.30.30.3
Avg SQL DeadLocks/sec00000000

SQL Locks Avg Wait (ms)

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Locks Avg Wait00000000
Max SQL Locks Avg Wait120913.412683.4310833.484440.138517.418959.8623345.82120913.4
Avg SQL Locks Avg Wait96.1282.9190.6486.879.0176.9789.1885.95

SQL Latches Avg Wait (ms)

Counter04/12/201904/13/201904/14/201904/15/201904/16/201904/17/201904/18/2019Total
Min SQL Latches Avg Wait00000000
Max SQL Latches Avg Wait20.5219.4511.5435.7210.6153.7438.4453.74
Avg SQL Latches Avg Wait0.971.180.891.040.830.880.990.97