SCOMSQL01 OpsMgr SQL Server

Daily Stats from: 04/23/2019

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max72.1860.4458.1846.9259.8851.0948.2950.5347.659.2457.0247.0752.1346.0254.7949.9948.2944.1546.8548.4397.7850.442.3448.2497.78
Avg36.8322.1620.7119.3817.5418.8917.3916.0116.5217.2417.1416.6918.0416.9617.2417.3915.7715.9518.3321.2717.1315.5815.8717.118.46

Available Memory Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min17731906192618871900191016611946155819371779185918501894184918461862177617708411094116211221083840.85
Max2164223222892229223322112230227322762263218021902182218321682160217321822152206114851489146115402289.19
Avg2045218022222166215421482129220721742180211821192115212521182084211521042090144714281399140114171986.85

Working Set (Used Memory) Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min13556135541349613559135251354913519134921350413505135931359413592135801360613593136001360613596137041443314440144411433513492.18
Max13824137161379913857137251373314028136731399613747138101387713795138421377613888137931381513972149521476314725147011468114952.36
Avg13653135971354913608136001361413615135501358513590136471365013647136441365113655136501366913681143991449614487144921443113798.32

Cache Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min279278279278279278279279276276276276276276276276277277278265254253276300253.18
Max479479479478480478480478616475478476476476477475476478477680464496487540680.36
Avg313301302301300302303302301299298298301298298299299299301320281301304334302.34

Pool Non-Paged Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min80808080808080808080808080808080808080808080808079.68
Max83808580808080818080808080808180808082808080808084.68
Avg80808180808080808080808080808080808080808080808079.85

% CPU Privileged Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max8.529.5910.359.76.049.84.724.7415.854.78.779.736.1910.434.198.714.568.719.551812.6511.079.735.9918
Avg1.190.91.21.340.950.970.980.791.040.890.940.950.960.880.860.990.840.851.152.511.080.810.80.961.03

% CPU User Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max69.4459.715743.5855.5748.9746.748.9346.6655.4653.7443.5448.1544.8851.4947.8746.7243.0545.546.1187.1848.8440.5644.1787.18
Avg35.6321.2619.5118.0316.5917.9116.4115.2215.4816.3516.215.7317.0816.0716.3816.414.9315.0917.1718.7616.0414.7615.0716.1417.43

Processor Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2422222222222222221244224
Avg0.320.160.180.190.240.140.240.190.070.140.20.20.10.190.150.190.160.160.110.190.230.150.20.120.18

% Page File Usage Statistics

Counter000102030405060708091011121314151617181920212223Total
Min1.471.711.71.471.541.591.21.451.531.451.461.51.521.591.61.21.431.551.551.471.871.891.91.481.2
Max1.921.751.711.711.581.611.641.471.531.521.461.511.531.621.631.641.481.571.562.211.911.91.921.922.21
Avg1.691.731.711.681.551.61.531.461.531.471.461.511.521.61.611.371.471.561.551.831.891.891.911.741.62

Pages/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2599.45275.12512.181235.98511.82516.722332.78511.81512.23512.49512.12511.77607.7427.8388.032383.64511.81514.023438.223879.73933.081060.391089.857431.477431.47
Avg552.695.7213.295.323.9917.83.616.793.964.694.99.723.411.9317.023.814.3219.92166.3611.4215.3710.13106.9420.75

Page Reads/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max64.234.5864.16136.4764.0864.88155.664.1684.8564.1664.264.07286.1154.098.69174.8964.1664.79434.2474.16444.05563.14137.57880.49880.49
Avg1.180.280.651.620.560.371.580.351.530.470.560.552.160.360.181.340.310.462.5143.142.765.481.217.383.62

Page Writes/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1000.80.10.10.50.10.10000000.80.50.10.14.10.50.20.114.1
Avg0.02000000.01000000000.010000.050000.020

Disk Percent Usage

Drive000102030405060708091011121314151617181920212223
C - 100GB51.9251.9351.9351.9351.9151.9151.9451.9351.9351.9351.9251.9251.9251.9251.9351.9351.9351.9351.9352.7652.7652.7552.7552.79
D - 100GB0.790.790.790.790.790.790.790.790.790.790.790.790.790.790.790.790.790.790.790.790.790.790.790.79
F - 200GB71.671.671.671.671.671.671.671.671.671.671.671.671.671.671.671.671.671.671.671.671.671.671.671.6
L - 100GB24.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.2824.28
T - 100GB11.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.3
U - 100GB33.6933.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.6833.68

Used Disk Space (GB)

Drive000102030405060708091011121314151617181920212223
C - 100GB51.951.951.951.951.951.951.951.951.951.951.951.951.951.951.951.951.951.951.952.752.752.752.752.7
D - 100GB0.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.8
F - 200GB143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2143.2
L - 100GB24.324.324.324.324.324.324.324.324.324.324.324.324.324.324.324.324.324.324.324.324.324.324.324.3
T - 100GB11.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.311.3
U - 100GB33.633.633.633.633.633.633.633.633.633.633.633.633.633.633.633.633.633.633.633.633.633.633.633.6

Free Disk Space (GB)

Drive000102030405060708091011121314151617181920212223
C - 100GB4848484848484848484848484848484848484847.247.247.247.247.2
D - 100GB99.299.299.299.299.299.299.299.299.299.299.299.299.299.299.299.299.299.299.299.299.299.299.299.2
F - 200GB56.856.856.856.856.856.856.856.856.856.856.856.856.856.856.856.856.856.856.856.856.856.856.856.8
L - 100GB75.775.775.775.775.775.775.775.775.775.775.775.775.775.775.775.775.775.775.775.775.775.775.775.7
T - 100GB88.688.688.688.688.688.688.688.688.688.688.688.688.688.688.688.688.688.688.688.688.688.688.688.6
U - 100GB66.266.266.266.266.266.266.266.266.266.266.266.266.266.266.266.266.266.266.266.266.266.266.266.2

Disk Write Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max7.66.176.4210.6313.865.086.5613.1810.146.943.066.752.448.549.124.862.595.3415.689.635.084.913.116.8515.68
Avg0.960.890.670.670.740.770.680.780.650.840.610.780.680.830.670.640.560.681.20.890.840.81.121.030.79

Disk Read Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max11.899.1222.028.145.566.859.735.78.535.775.417.847.085.184.066.497.448.146.997.0614.9212.637.016.5522.02
Avg1.120.891.040.720.670.70.750.710.680.750.660.730.760.820.610.740.60.681.051.11.050.951.041.080.83

Disk Split IO per second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max37.445.64.419.23.66.58.594.25.65.73.64.35.15.43.86.25.16.1111.355.396.3913.18.597.855.39
Avg1.120.420.430.50.40.410.470.430.490.410.390.40.440.410.410.450.420.40.452.160.430.460.440.580.54

Current Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max13121410015215171587217108251291527117223536117
Avg0.210.230.230.420.110.050.10.160.070.340.070.160.170.210.070.060.140.080.210.360.530.130.190.220.19

Average Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max9.275.4615.169.2117.175.486.3616.699.487.695.116.011.697.087.914.991.664.2110.0775.555.429.774.8417.17
Avg0.30.310.420.210.260.170.170.240.190.230.140.180.150.190.210.160.130.160.290.350.350.280.330.320.24

Disk Read Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max11.39290.48133.2420.57167.4210.89.168.595.0319.7512.314.5812.1610.636.8612.2227.771514.2426.07485.665.984.6329.06485.66
Avg1.026.13.140.831.470.650.730.610.530.760.650.510.60.540.590.740.70.620.743.0211.050.470.380.731.55

Disk Write Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max91.88292.64212.5131.1690.9520.7425.2527.6922.2138.9825.834.4532.1830.8133.3534.2432.6935.0432.2349.5436.4436.138.2338.15292.64
Avg4.378.256.123.383.142.862.882.812.823.73.183.123.293.253.423.693.543.573.756.343.633.513.33.53.81

Total Net Received Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1.471.413.053.351.293.062.511.451.428.362.741.451.331.392.42.791.361.382.953.822.770.880.982.638.36
Avg0.320.270.490.80.310.370.350.290.280.460.360.310.330.310.340.380.290.280.390.860.320.230.210.260.37

Total Net Sent Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max7.655.2310.3112.5510.510.769.276.875.0626.311.054.826.046.586.889.2511.958.6112.5322.08139.97.089.249.35139.9
Avg1.310.421.021.30.680.6310.720.470.770.620.461.150.610.590.690.630.551.175.383.290.520.450.541.04

SQL User Connections

Counter000102030405060708091011121314151617181920212223Total
Min1411401321351361271221381401371251351381381201271351381227512813212113275
Max170159178176166164159161165215163163155162166170171160173165159159147152215
Avg153.01148.77157.49159.01150.04150.13145.69149.15151.25157.74145.07151.25147.76150.58148.3148.26150.99150.77152.04129.02144.83145.73138.84141.24148.62

SQL Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max98.97171.31191.27205.03130.6195.01154.62100.87102.79104.3399.19148.9896.89102.3106.69110.85107.9790.9497.42251.56102.2995.7898.36109.43251.56
Avg36.6534.5676.01102.3346.6540.1936.535.6434.8337.3335.4236.53735.436.1836.6336.1835.636.1446.8534.6636.3133.4433.1141.25

SQL Re-Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max63.285.46143.58167.4195.1463.1141.1253.0452.662.0963.1111.4467.5661.168.8780.0968.555.9168.57233.9861.0761.6858.5164233.98
Avg14.813.1449.7878.7524.8218.9315.0914.3313.6514.1513.3914.4714.6613.613.9813.8113.3413.214.4931.8313.1514.7612.7511.919.45

SQL Batch Req/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1069.89934.691429.531772.498821068.871014.55931.631124.261272.181136.221263.16945.19852.171249.051251.21959980.851011.042486.16948.14709.55677.45959.422486.16
Avg203.37183.7340.18521.83217.82232.44242.08198.02190.24241.24250.36212.99213.78201.36231.25238.8191.48184.04232.51406.71178.76153.76138.4177.73232.62

Log Flushes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max585.73789.21352.06459.61525.79521.36444.48433.08592.45650.57469.12545.7480.33495.77621.28557.65452.27520.37644.52651.76640.28757.3524.21559.631352.06
Avg72.4967.06116.4293.5366.1174.4164.8168.3868.0272.1163.4366.4165.9165.6767.2168.3465.6667.2471.5876.3765.0666.9162.4764.6570.84

Lazy Writes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max76.983.5320.512.537.620.12.931.211.80.40.30.53.24.211.92.204.72.63.82.73.68.31320.51
Avg1.860.094.890.050.1800.020.040.020.070.010.0100.030.060.050.0200.060.10.10.060.060.080.33

Page Splits/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max111.42151.533342.42357.74141.15252.91313.19128.5134.05313.05321.96125.83124.26137.89331.08201.81123.38133.5352.16435.61253.69133.99185.03403.063342.42
Avg25.8924.0643.9331.4426.2926.0424.1123.123.0529.0525.824.4724.7824.9926.9427.0225.1526.6331.8128.7528.5125.4924.5126.1727

SQL Buffer Cache Hit Ratio

Counter000102030405060708091011121314151617181920212223Total
Min98.0761.5998.7699.9897.9399.999.9799.8999.9799.8799.9399.9999.8899.9899.9199.9499.9699.9499.9199.9799.8799.9599.9299.9361.59
Max100100100100100100100100100100100100100100100100100100100100100100100100100
Avg99.9999.8999.9910099.9910010010010010010010010010010010010010010010010010010010099.99

SQL Cache Memory (MB)

Counter000102030405060708091011121314151617181920212223Total
Min31.2331.2332.9731.2331.2631.3131.2931.2931.6131.6132.0231.6431.6431.6431.6431.6431.6531.5531.5531.5531.5531.5531.5631.2231.22
Max31.2333.3833.2332.9831.3131.3231.3131.6131.6132.0332.0332.0331.6431.6431.6431.6531.6631.6731.5531.5531.5531.5531.5731.5833.38
Avg31.2332.5332.9832.0731.331.3131.331.4531.6131.7732.0331.6631.6431.6431.6431.6431.6631.631.5531.5531.5531.5531.5731.531.68

SQL Total Memory (GB)

Counter000102030405060708091011121314151617181920212223Total
Min10.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.74
Max10.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.74
Avg10.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.74

SQL Target Memory (GB)

Counter000102030405060708091011121314151617181920212223Total
Min10.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.74
Max10.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.74
Avg10.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.7410.74

SQL Processes Blocked

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max221432322122222221223222214
Avg0.020.030.850.20.060.060.020.0300.050.050.020.030.010.050.040.010.030.050.120.020.020.030.030.08

SQL DeadLocks/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max0.10.10.10.10.10.10.10.20.20.20.10.10.10.10.20.10.10.10.10.20.20.10.10.10.2
Avg000.010000000000000000000000

SQL Locks Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2543326026336.971657.7533234774415027454009.5489914822449439922784375.532452824296435731427.25276136972247385326336.97
Avg79.1862.19347.7453.0760.7496.2277.8759.6833.36120.6146.4545.9263.7846.2976.0974.9746.9681.7162.8552.4974.474.5666.1676.2378.31

SQL Latches Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max11.666.765.54.795.615.925.345.714.784.716.455.895.45.624.65.776.355.436.91164.265.314.56.0616
Avg1.251.060.860.811.041.31.080.891.021.091.071.061.11.071.11.070.991.041.060.720.820.820.970.871.01