SCOMSQL02 OpsMgr Data Warehouse

Weekly Stats from: 04/19/2019 - 04/25/2019

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Processor % Usage00000000
Max Processor % Usage94.195.296.0291.4891.7895.3195.1996.02
Avg Processor % Usage5.794.854.684.977.234.955.235.39

Available Memory Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Available Memory (MB)1769.831114.881720.911661.011236.42780.92891.08780.92
Max Available Memory (MB)2534.092579.052637.072716.232683.371952.392042.492716.23
Avg Available Memory (MB)2353.482407.352465.942530.132363.071797.261857.332253.51

Working Set (Used Memory) Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Working Set (MB)12854.912831.8312780.4612711.1612686.7313581.2713494.712686.73
Max Working Set (MB)13576.6614740.5913736.2213574.5714273.5514564.1114599.9314740.59
Avg Working Set (MB)13132.6513074.2513015.2312953.6313096.1113840.1113790.5113271.78

Cache Bytes Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Cache Bytes (MB)340.5337.6337.53316.59300.92334.86338.48300.92
Max Cache Bytes (MB)631.83665.1578.03646.32660.591036.34589.291036.34
Avg Cache Bytes (MB)366.26359.55358.83360.92357.63361.21362.68361.01

Pool Non-Paged Bytes Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Non-Paged Pool Bytes (MB)109.58109.68109.49109.47109.85109.61109.62109.47
Max Non-Paged Pool Bytes (MB)118.05127.04127.7116.4119.85119.95119127.7
Avg Non-Paged Pool Bytes (MB)111.65114.76114.73110.5112.76110.78110.87112.29

% CPU Privileged Time Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Priv CPU Usage00000000
Max Priv CPU Usage18.9620.2418.8924.8223.6819.9417.3224.82
Avg Priv CPU Usage1.020.980.961.081.260.810.91

% CPU User Time Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min User CPU Usage00000000
Max User CPU Usage82.585.5987.1980.0681.0391.6285.6891.62
Avg User CPU Usage4.763.863.713.895.964.144.334.38

Processor Queue Length Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Processor Queue Length00000000
Max Processor Queue Length771610157616
Avg Processor Queue Length0.070.060.070.060.130.070.070.08

% Page File Usage Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min PageFile % Usage25.525.8926.3626.3925.9725.2925.4325.29
Max PageFile % Usage27.727.5728.1427.8327.5728.2528.0628.25
Avg PageFile % Usage26.3226.727.1627.2626.9526.226.6126.74

Pages/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Pages/sec00000000
Max Pages/sec26207.5326117.4827739.0122236.9128772.4117097.828789.9828789.98
Avg Pages/sec187.09177.55177.02170.29324.6721.72170.93175.61

Page Reads/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Page Reads/sec00000000
Max Page Reads/sec860.88945.94970.347351440.291111.83922.851440.29
Avg Page Reads/sec6.756.426.336.2413.842.366.726.95

Page Writes/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Page Writes/sec00000000
Max Page Writes/sec11.1111117.761117.76
Avg Page Writes/sec0.050.060.050.040.050.050.060.05

Disk Percent Usage

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 62GB76.876.876.876.8787878
D - 100GB0.80.80.80.80.80.80.8
F - 2048GB71.671.671.671.671.671.671.6
L - 1127GB8.88.88.88.88.88.88.8
T - 50GB20.420.420.420.420.420.420.4
U - 250GB29.229.327.326.12525.325.4

Used Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 62GB47.547.547.547.548.348.348.3
D - 100GB0.80.80.80.80.80.80.8
F - 2048GB1466.61466.61466.61466.61466.61466.91466.6
L - 1127GB99.499.499.499.499.499.499.4
T - 50GB10.210.210.210.210.210.210.2
U - 250GB72.973.268.265.262.563.163.6

Free Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 62GB14.414.414.414.413.613.613.6
D - 100GB99.299.299.299.299.299.299.2
F - 2048GB581.2581.2581.2581.2581.2581581.2
L - 1127GB1027.41027.41027.41027.41027.41027.41027.4
T - 50GB39.739.739.739.739.739.739.7
U - 250GB177176.6181.6184.7187.4186.8186.3

Disk Write Latency (milliseconds)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Disk Write Latency00000000
Max Disk Write Latency10.3114.699.4816.428.7915.1110.7128.79
Avg Disk Write Latency0.740.790.750.840.820.720.760.77

Disk Read Latency (milliseconds)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Disk Read Latency00000000
Max Disk Read Latency574.04302.48137.75101.04340.67713.49261.68713.49
Avg Disk Read Latency1.391.191.131.32.081.621.271.43

Disk Split IO per second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Disk Split I/Os00000000
Max Disk Split I/Os84.6186.8484.684.3936.3784.5184.5186.84
Avg Disk Split I/Os0.210.210.210.210.250.240.230.22

Current Disk Queue Length Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Current Disk Queue Length00000000
Max Current Disk Queue Length139445224212823750242
Avg Current Disk Queue Length0.220.150.160.220.370.350.160.23

Average Disk Queue Length Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Avgerage Disk Queue Length00000000
Max Avgerage Disk Queue Length921.99634.45237.4172.97270.11698.56444.22921.99
Avg Avgerage Disk Queue Length0.530.280.270.230.510.580.380.4

Disk Read Throughput (Mb/sec) Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Disk Read Mb/sec00000000
Max Disk Read Mb/sec466.53481.73470.55457.89396.99445.81539.17539.17
Avg Disk Read Mb/sec6.155.715.55.197.766.755.296.05

Disk Write Throughput (Mb/sec) Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Disk Write Mb/sec00000000
Max Disk Write Mb/sec164.33140.88142.44123.91314.36205.78141.77314.36
Avg Disk Write Mb/sec3.542.762.782.764.942.793.183.25

Total Net Received Throughput (Mb/sec) Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Net Received Mb/sec00000000
Max Net Received Mb/sec2.932.812.911.291.621.151.722.93
Avg Net Received Mb/sec0.070.060.060.060.080.060.070.07

Total Net Sent Throughput (Mb/sec) Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Net Sent Mb/sec00000000
Max Net Sent Mb/sec109.9100.75105.791.09128.74122.4131.14131.14
Avg Net Sent Mb/sec1.391.291.261.192.060.821.341.34

SQL User Connections

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL User Connections16191812819168
Max SQL User Connections7270707275716975
Avg SQL User Connections27.0227.2727.3227.4227.0226.612727.09

SQL Compilations/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Compilations/sec00000000
Max SQL Compilations/sec139.76145.35151.07128.74131.1134.67143.99151.07
Avg SQL Compilations/sec19.3318.7619.0419.0119.2919.3520.0119.26

SQL Re-Compilations/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Re-Compilations/sec00000000
Max SQL Re-Compilations/sec6.999.616.95.65.716.18.799.61
Avg SQL Re-Compilations/sec0.960.930.950.930.950.951.030.96

SQL Batch Req/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Batch Req/sec00000000
Max SQL Batch Req/sec424.79722.82429.63444.23426.83693.16680.83722.82
Avg SQL Batch Req/sec41.2940.0940.6940.9641.3741.442.6441.21

Log Flushes/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Log Flushes00000000
Max SQL Log Flushes1446.091193.961415.59904.151229.371313.23912.861446.09
Avg SQL Log Flushes35.6628.7228.828.7130.6129.5633.8230.84

Lazy Writes/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Lazy Writes00000000
Max SQL Lazy Writes208.53223.09190.49362.42391.75143.91246.04391.75
Avg SQL Lazy Writes0.770.520.420.420.860.290.710.57

Page Splits/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Page Splits00000000
Max SQL Page Splits8167.856209.128272.244867.138914.7148886168.538914.71
Avg SQL Page Splits39.5227.7125.8328.4530.3327.8833.0830.4

SQL Buffer Cache Hit Ratio

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Buffer Cache Hit Ratio89.0279.6481.1384.0189.2384.7290.5679.64
Max SQL Buffer Cache Hit Ratio100100100100100100100100
Avg SQL Buffer Cache Hit Ratio99.9999.9999.9999.9899.9899.9899.9999.99

SQL Cache Memory (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Cache Memory27.7528.6428.6328.5828.5628.4128.4127.75
Max SQL Cache Memory29.2929.0428.6528.6328.5928.5629.7729.77
Avg SQL Cache Memory28.628.7128.6428.5928.5728.4429.1328.67

SQL Total Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/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/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/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/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Processes Blocked00000000
Max SQL Processes Blocked3236043460
Avg SQL Processes Blocked0.020.020.020.010.020.010.020.02

SQL DeadLocks/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL DeadLocks/sec00000000
Max SQL DeadLocks/sec00000.01000.01
Avg SQL DeadLocks/sec00000000

SQL Locks Avg Wait (ms)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Locks Avg Wait00000000
Max SQL Locks Avg Wait500817009.334500725007134325008500845007
Avg SQL Locks Avg Wait83.5129.28119.5948.5594.1353.874.1986.15

SQL Latches Avg Wait (ms)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Latches Avg Wait00000000
Max SQL Latches Avg Wait1631311626.26161631
Avg SQL Latches Avg Wait0.360.350.370.40.690.440.340.42