SCOMSQL01 OpsMgr SQL Server

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 % Usage99.4999.6999.4398.5497.7898.3494.0699.69
Avg Processor % Usage18.5218.1817.4320.2318.5319.0521.0419

Available Memory Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Available Memory (MB)1249.221420.091680.331443.79840.85159.881239.01159.88
Max Available Memory (MB)2383.62361.412463.442296.92289.192236.222164.192463.44
Avg Available Memory (MB)2226.92184.582210.932086.171986.961698.941919.712044.88

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)13343.713380.7513313.51350213492.1813562.2213602.213313.5
Max Working Set (MB)14320.7114306.3413991.3214135.0614952.3614986.1414483.1114986.14
Avg Working Set (MB)13513.7213558.1513538.3413674.5113798.2314106.3213817.513715.25

Cache Bytes Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Cache Bytes (MB)276.16276.09276.2275.3253.18266.02266.57253.18
Max Cache Bytes (MB)514.71580.78499.61569.15680.36983.52592.23983.52
Avg Cache Bytes (MB)302.69301.21299.58295.5302.31315.79294.91301.71

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)80.1280.6780.6379.9879.6879.6579.9679.65
Max Non-Paged Pool Bytes (MB)87.284.1186.9987.0384.6886.2786.387.2
Avg Non-Paged Pool Bytes (MB)80.781.0181.0180.7379.8580.180.2880.53

% 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 Usage17.1217.3118.7918.761821.2214.8121.22
Avg Priv CPU Usage1.021.020.971.091.041.051.041.03

% 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 Usage84.885.0887.5384.3787.1886.8885.9987.53
Avg User CPU Usage17.4917.1516.4519.1517.49182017.96

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 Length57994679
Avg Processor Queue Length0.180.170.150.20.180.180.20.18

% Page File Usage Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min PageFile % Usage1.191.161.191.111.21.745.931.11
Max PageFile % Usage1.641.631.631.832.219.948.069.94
Avg PageFile % Usage1.511.521.541.471.623.846.782.61

Pages/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Pages/sec00000000
Max Pages/sec54434.3355313.8852997.6948807.447431.4712568.2452554.8755313.88
Avg Pages/sec110.24111.25119.37113.8120.9736.29117.4789.91

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/sec1775.081791.061675.281533.87880.49914.331642.341791.06
Avg Page Reads/sec4.094.224.434.373.645.035.224.43

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/sec111.114.150.78150.78
Avg Page Writes/sec00.010.010.010.010.030.010.01

Disk Percent Usage

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 100GB51.951.951.951.952.852.852.8
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.133.235.835.833.733.733.8

Used Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 100GB51.951.951.951.952.752.852.8
D - 100GB0.80.80.80.80.80.80.8
F - 200GB143.2143.2143.2143.2143.2143.4143.2
L - 100GB24.324.324.324.324.324.324.3
T - 100GB11.311.311.311.311.311.311.3
U - 100GB33.133.135.835.833.633.633.7

Free Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 100GB4848484847.247.247.1
D - 100GB99.299.299.299.299.299.299.2
F - 200GB56.856.856.856.856.856.656.8
L - 100GB75.775.775.775.775.775.775.7
T - 100GB88.688.688.688.688.688.688.6
U - 100GB66.866.764.164.166.266.266.2

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 Latency17.1218.4312.7133.0715.6812.524.9133.07
Avg Disk Write Latency0.720.880.740.810.80.830.830.8

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 Latency21.7625.2229.8421.2450.2697.3327.4597.33
Avg Disk Read Latency0.720.920.850.870.840.970.80.85

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/Os37.2336.2839.1335.2355.3955.8335.3355.83
Avg Disk Split I/Os0.450.460.470.450.540.510.480.48

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 Length42250239157117246183250
Avg Current Disk Queue Length0.150.220.190.190.190.240.210.2

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 Length19.3924.6531.5120.4918.4216.9130.7931.51
Avg Avgerage Disk Queue Length0.260.290.250.240.240.260.320.27

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/sec476.58469.74473.76448.96485.66463.5457.9485.66
Avg Disk Read Mb/sec1.991.741.931.771.571.621.741.77

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/sec360.7470.04332.9359.72292.64308.6294.9470.04
Avg Disk Write Mb/sec3.833.623.863.653.833.463.743.71

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/sec11.8210.1710.2510.338.3612.1710.4712.17
Avg Net Received Mb/sec0.370.340.350.360.370.340.380.36

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/sec136.28119.92124.39119.51139.9122.77122.07139.9
Avg Net Sent Mb/sec1.010.9410.991.040.751.080.97

SQL User Connections

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL User Connections119119121937512711875
Max SQL User Connections225226235202215214248248
Avg SQL User Connections150.77153.61151.84151.16148.63149.77152.26151.15

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/sec209.17227.02242.1213.57251.56271.17199.25271.17
Avg SQL Compilations/sec41.5340.8341.4741.8441.3740.1942.1641.34

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/sec169.01205.83197.95185.97233.98235.12171.74235.12
Avg SQL Re-Compilations/sec19.419.1619.4119.619.5118.3219.6419.29

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/sec1658.261811.431798.092731.362486.163200.761944.283200.76
Avg SQL Batch Req/sec239.47225.98231.21237.14233.21219.12246.4233.22

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 Flushes1354.791363.721193.391274.921352.061356.421129.291363.72
Avg SQL Log Flushes73.6272.0972.1572.5770.9968.4175.6772.21

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 Writes302.98580.06441.49228.14320.51334.88430.15580.06
Avg SQL Lazy Writes0.440.320.410.370.330.440.430.39

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 Splits4803.994889.144512.244524.873342.422554.344453.864889.14
Avg SQL Page Splits264.97104.0950.2158.7827.0545.7548.2285.58

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 Ratio54.4672.0597.7773.4961.5964.8454.7854.46
Max SQL Buffer Cache Hit Ratio100100100100100100100100
Avg SQL Buffer Cache Hit Ratio99.9899.9910099.9999.9999.9999.9999.99

SQL Cache Memory (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Cache Memory30.430.5929.8128.2631.2230.831.2628.26
Max SQL Cache Memory34.835.1332.5931.6733.3833.3632.9835.13
Avg SQL Cache Memory33.833.1332.2930.8631.6831.8232.3332.27

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 Blocked1141081461214
Avg SQL Processes Blocked0.070.040.060.060.080.040.050.06

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/sec0.40.20.40.50.20.40.20.5
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 Wait44855.75489948070.3317940.5526336.97717620827.6148070.33
Avg SQL Locks Avg Wait86.0470.6785.18111.1578.9276.0880.6484.1

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 Wait12.0819.397.9615.93166.777.4519.39
Avg SQL Latches Avg Wait0.780.80.911.011.010.810.860.88