SCOMSQL01 OpsMgr SQL Server

Daily Stats from: 04/19/2019

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max78.7158.9657.5753.4253.7355.7250.437.6650.7159.6545.0451.9251.2656.3849.0260.3158.6646.3659.9443.899.4940.5936.8450.1299.49
Avg38.3923.219.5418.8917.4117.3116.2216.0419.5620.2918.5920.4120.8620.3720.3118.1517.1116.3417.9215.0416.5211.111.3411.6118.44

Available Memory Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min1863194920352022198219661767194119711249186118502060204718991959202620042022195617711884186218791249.22
Max2277229223802339229723262344232123042309217023552378238423662353235623502337229322322206221721902383.6
Avg2165221623102272223222622248226122392139210621532318232022932265228522882253222921552153214221392226.86

Working Set (Used Memory) Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min13483134781338013418134731341813430134161343713445135821341813375133441336513392133711338913414134601345313484134701347813343.7
Max13793138511364113739137361364313970135861372214321138931379013577135641378513758137081361613811136731389013655136961380514320.71
Avg13577135401344113478135241349213501134721351613597136471359813429134241345913460134651346813505135231355813540135561355813513.72

Cache Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min278278278278279279278279276276276276277277277277277277278279279279279279276.16
Max481481481481479480481481480515478475476477479479477480480479483481478480514.71
Avg316302301303303303305303301313301301301301299303302301302303303300299300302.71

Pool Non-Paged Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min81818181818181818181818181818181818180808081818180.12
Max87818181818181818181818184818781818181818681878187.2
Avg81818181818181818181818181818181818181808281818180.7

% CPU Privileged Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max10.979.285.3410.9811.454.419.663.39.7116.388.979.126.375.9711.346.268.124.619.214.2217.123.863.598.0117.12
Avg1.340.951.091.361.070.80.940.841.111.360.970.880.870.871.030.90.910.941.310.821.720.690.740.811.01

% CPU User Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max75.1258.4754.2349.6247.9854.2849.636.4246.5555.4744.3649.4548.3650.8146.3758.7150.5844.756.0741.8684.838.6635.7643.2184.8
Avg37.0522.2418.4417.5316.3416.5115.2715.218.4518.9217.6219.5319.9819.4919.2817.2516.1915.416.6114.2214.810.4110.5910.817.42

Processor Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2223222222222222223252225
Avg0.360.180.120.180.110.140.110.140.120.230.20.20.220.260.220.220.170.160.190.140.220.110.10.130.18

% Page File Usage Statistics

Counter000102030405060708091011121314151617181920212223Total
Min1.451.531.361.491.541.561.21.311.41.491.481.481.491.461.461.191.321.451.51.521.551.591.611.631.19
Max1.541.591.581.561.571.61.61.441.531.561.511.541.51.491.471.511.461.511.531.551.591.611.631.641.64
Avg1.51.561.521.521.561.581.561.381.481.511.491.511.51.471.461.351.441.51.521.541.581.61.621.631.52

Pages/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2486.99283.381254.96619.86512.12512.383137.03859.461301.03935.11513.83513.62511.411050.95512.073751.67288.87512.643438.05511.9154434.33511.82513.18341.7854434.33
Avg52.864.4613.428.74.813.5515.6610.2114.3113.925.014.643.376.625.7520.564.664.0820.133.782409.983.783.794.41110.1

Page Reads/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max108.4635.52157.1469.4564.1264.15205.9164.81163.94128.5764.3464.364.03111.7264.11211.836.4664.18434.264.261775.0864.0864.2581.351775.08
Avg1.640.371.410.850.470.311.320.731.282.580.610.430.430.710.691.610.280.422.470.3477.350.340.350.644.07

Page Writes/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max0.90.6110.20.30.6110.80.40.6000.10.910.70.30.20.30.20.10.11
Avg0.0100.010.01000.010.010.010000000.020.0100000000

Disk Percent Usage

Drive000102030405060708091011121314151617181920212223
C - 100GB51.9351.9251.9251.9251.9351.9351.9351.9351.9351.9251.9251.9251.9251.9251.9251.9251.9451.9351.9351.9351.9251.9251.9151.93
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 - 100GB32.9733.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.1133.11

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.951.951.951.951.951.9
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 - 100GB32.933.133.133.133.133.133.133.133.133.133.133.133.133.133.133.133.133.133.133.133.133.133.133.1

Free Disk Space (GB)

Drive000102030405060708091011121314151617181920212223
C - 100GB484848484848484848484848484848484848484848484848
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.966.866.866.866.866.866.866.866.866.866.866.866.866.866.866.866.866.866.866.866.866.866.866.8

Disk Write Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max9.698.437.224.366.5514.328.667.263.123.843.056.455.977.667.823.473.636.157.163.8314.3115.3717.1210.6317.12
Avg0.830.720.530.580.520.640.530.660.640.620.560.70.550.70.680.620.610.670.940.720.940.941.360.960.72

Disk Read Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max7.046.0217.944.736.594.356.494.593.584.1312.233.715.024.765.548.065.084.417.035.035.255.3521.7621.76
Avg1.020.710.740.580.530.560.570.640.630.720.710.690.650.760.660.760.70.710.870.720.760.720.920.850.72

Disk Split IO per second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max37.236.41145.423.37.65.914.810.513.33.83.414.93.86.14.66.817.23.384.53.74.437.23
Avg1.020.420.470.420.40.380.420.420.550.550.390.380.380.420.40.450.430.40.450.370.450.380.410.370.45

Current Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max34920111221817231623428232414101718264222242
Avg0.220.290.290.110.040.110.20.090.180.230.050.070.120.170.150.190.090.070.160.20.250.160.080.150.15

Average Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max9.635.938.94.634.9113.256.215.795.174.784.486.856.1215.8910.262.365.34.869.964.7415.218.219.3918.7819.39
Avg0.30.290.310.180.150.170.130.190.160.20.160.180.150.230.250.140.160.180.270.20.630.470.650.510.26

Disk Read Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max17.3360.4111.5121.6420.316.5212.0526.6118.1917.6611.359.874.8913.268.3314.667.6813.3416.657.17476.589.239.2614.41476.58
Avg1.597.983.331.141.090.630.740.761.21.080.760.690.60.580.720.540.420.490.670.5420.290.530.640.51.98

Disk Write Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max94.23360.7320.1234.7737.9727.2423.1434.4423.9447.7530.2528.734.4732.1835.832.6733.3733.2632.5434.8834.2841.0835.4336.74360.7
Avg4.7510.315.593.633.352.752.863.033.494.143.313.293.263.433.563.333.193.343.573.493.493.423.553.463.82

Total Net Received Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2.592.42.693.012.921.311.313.113.6411.822.841.291.391.623.581.271.533.162.61.312.81.343.151.3511.82
Avg0.340.350.380.640.410.310.310.350.450.460.390.310.30.320.460.290.260.380.360.290.430.290.410.30.37

Total Net Sent Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max11.456.8511.289.739.758.518.0312.3725.2213.29.225.787.5114.566.875.685.578.2410.268.92136.28118.046.5136.28
Avg1.520.560.861.250.990.570.820.881.480.840.690.521.330.660.790.460.440.540.820.535.880.530.650.451

SQL User Connections

Counter000102030405060708091011121314151617181920212223Total
Min127120135139120139137130124131132137140143126136137138119140131131119136119
Max167159173176173161159181225222168153155163167160162173162165168163167162225
Avg151.66146.17152.39159.41154.97148.78148.19151.63156.91158.71148.32145.69147.61151.95147.98148.78149.34152.47149.95150.48151.92149.84147.54147.89150.77

SQL Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max97.04184.43183.19209.17162.44101.26173.91131.6391.99125.44116.5696.0398.86111.16119.587.41104.39121.97123.46123.73114.26100.34112.7696.16209.17
Avg36.5535.6868.71102.2855.4138.9737.8335.2435.0741.5739.9536.4536.2537.0236.2634.8833.8635.2535.8436.735.3636.2736.135.5741.38

SQL Re-Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max71.3364.82160.99169.01121.5963.48148.0168.1666.7567.9874.9457.462.9370.5773.657.7153.7164.2577.460.360.2671.6373.853.72169.01
Avg1513.9843.1477.6732.717.5415.813.614.0218.2917.5414.9214.2314.6114.413.1712.5614.114.4515.113.9114.2914.8313.8919.32

SQL Batch Req/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1175.76948.81334.611266.151158.11969.93933.421194.151451.71521.961125.78887.361016.151129.971424.18878.741070.81658.261083.59972.751008.42970.841216.76954.241658.26
Avg222.45217.3286.22446.03296.82215.97212.09207.42279.97267.14245.55209.86190.86217.27268.86203.63173.25238.63246.58199.71215.08198.25265.84204.28238.71

Log Flushes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max618.33447.921354.79448.43434.32478.62405.16505.32480.26555.26760.84408.66620.18456.29461.44426.83601.07476.8533.22491.22704.63576.24555.7434.81354.79
Avg75.873.2112.6497.2982.0366.966.5769.7269.383.1274.5871.1968.5474.6973.3462.9866.5766.2270.3865.8770.0565.0267.3568.7973.42

Lazy Writes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max29.384.4302.9819.528.10.40.73.66.579.7673.94.65.11.131.73.29.418.56.814.574.4302.98
Avg1.690.173.030.370.150.010.020.090.060.980.60.10.050.140.050.170.070.150.340.470.450.310.470.530.44

Page Splits/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max456.47604.774803.99475.26467.99497.02485.72482.52505.88534.85484.43474.66461.01465.23627.73453.67468.55543.21546.97560.56503.42493.27506.92522.074803.99
Avg264.67263.15280.14267.63265.69262.24260.57262.38262.89266.67263.68262.59262.09262.8265.91262.37261.36263.85266.72264.79263.37262.03263.25261.6264.27

SQL Buffer Cache Hit Ratio

Counter000102030405060708091011121314151617181920212223Total
Min99.6399.8778.2499.9399.8599.8199.8288.1399.7454.4699.7399.8799.7799.9699.9599.8599.7599.8499.7799.4799.4199.299.1199.7454.46
Max100100100100100100100100100100100100100100100100100100100100100100100100100
Avg99.9999.9999.9210010010010099.9610099.8699.9910010010010010099.9910099.9999.9999.9899.9999.9899.9999.98

SQL Cache Memory (MB)

Counter000102030405060708091011121314151617181920212223Total
Min32.6932.6934.2834.2834.3434.3134.3134.3130.430.433.9733.6233.6233.6333.6333.6333.6333.6333.6333.6333.6333.6433.6433.1430.4
Max32.6934.834.2934.3434.3534.3534.3134.6234.6233.9733.9933.9933.6333.6433.6333.6333.6333.6333.6333.6333.6433.6533.6633.6634.8
Avg32.6933.7734.2834.3134.3534.3334.3134.4734.632.5233.9933.9133.6233.6333.6333.6333.6333.6333.6333.6333.6433.6433.6533.5833.79

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
Max421134222222232222222222011
Avg0.050.030.670.160.110.020.010.020.060.050.050.030.040.030.030.040.020.060.030.020.050.020.0500.07

SQL DeadLocks/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max0.10.20.10.10.20.10.10.10.30.40.20.10.10.10.20.10.20.20.10.10.20.10.40.10.4
Avg0000000000.0100000000.0100000.0100

SQL Locks Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max4009.673923.544855.75679.8644783370397833703932483647584586318346182714432149614899358839152443.226054743366644855.75
Avg101.9948.94372.2551.9469.8384.3665.4246.4799.06110.4782.4367.5662.3166.1370.195.6460.02110.1890.842.6555.3146.36106.7936.5985.15

SQL Latches Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max7.956.8112.083.355.026.034.455.024.825.194.34.635.094.134.524.993.74.55.545.096.863.372.813.5812.08
Avg1.340.970.90.620.810.930.870.9410.690.730.80.820.790.770.710.670.640.80.720.660.510.470.450.78