SCOMSQL01 OpsMgr SQL Server

Daily Stats from: 04/24/2019

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max62.447.6751.4642.6163.0159.4669.257.146.4177.6448.8946.447.3550.2954.3253.6347.3248.146.2548.6898.3444.8653.9145.0798.34
Avg35.3319.6319.6317.9117.7519.6318.7618.9915.8619.3617.417.9818.4417.217.5118.3117.3616.5917.8317.4120.8818.2618.9418.6818.98

Available Memory Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min1180124113211252101512137551285124491310412941063237287529157712271699162129217071752160159.88
Max1581159016191540154315321590158015741582148615301707180621002092208320202036213621482116209822362236.22
Avg1458151415661475146214621487153315071463141713931562170218521902201219601968193120702056203519921699.05

Working Set (Used Memory) Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min14314142281421114301142941430114217142471427314279143051433814136140611367713691137221373013708136991366413654136871356213562.22
Max14628145371453614642147381463914591144631453714986145771463514547143891429714096139921392613945140191397513929139171404014986.14
Avg14402143471428914368143851436914332143241432814373144081443014289141401392013788137831379613793137801372813724137451370714106.13

Cache Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min297296298304295295306305303303305299302299273274274275276269269271272266266.02
Max501499496504503505866508506510506505501503500787473482484484478479477984983.52
Avg344319319327319326334327328329327327322321305339296299299300291294294296315.82

Pool Non-Paged Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min80808080818180808080808080808080808080808080808079.65
Max86808582818181808080808180818281808186828180808286.27
Avg80808080818180808080808080808080808080808080808080.1

% CPU Privileged Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max10.224.1521.225.5311.4910.715.024.77.1316.464.7410.566.339.178.698.938.564.336.2810.0311.538.099.5110.9821.22
Avg1.010.691.291.120.991.091.111.020.81.240.871.151.0311.041.140.990.851.021.131.320.950.981.171.04

% CPU User Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max61.3745.850.7241.2958.7455.7764.4752.4745.0864.3744.6345.5144.2846.953.1947.3143.5947.0144.0845.3186.8844.0644.3343.986.88
Avg34.3218.9318.3416.7916.7618.5417.6617.9715.0618.1116.5216.8317.4116.216.4717.1716.3615.7316.816.2719.5617.3117.9517.5117.94

Processor Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2232223224222222222262226
Avg0.390.260.140.170.140.140.210.160.190.110.160.130.180.190.160.20.250.120.220.160.240.170.160.180.18

% Page File Usage Statistics

Counter000102030405060708091011121314151617181920212223Total
Min1.741.841.861.781.841.881.92.062.082.092.12.122.352.353.635.615.555.515.395.3776.866.76.61.74
Max2.021.991.921.911.91.912.082.082.12.112.122.572.394.297.276.316.115.555.517.77.436.996.869.949.94
Avg1.881.951.881.871.851.8922.072.092.12.112.252.373.775.355.85.95.535.435.517.156.926.797.833.85

Pages/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2601.412027.8710004.591360.96512.12511.664647.64123.91512.171389.67512.021879.161058.6110294.8412568.245165.021515.2528.863552.188849.351039.39512.43512.127721.2712568.24
Avg63.113.567.5519.387.934.8484.822.896.7932.35.3130.5712.362.0589.3481.7715.043.434.2339.4615.358.233.98157.2835.89

Page Reads/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max602.65286.44382.24151.6364.1264.06843.6834.97175.52365.0164.19291.52488.11456.08435.02914.33244.2467.67452.29270.14474.1197.4564.12758.88914.33
Avg5.581.814.862.360.870.4513.850.292.358.780.756.823.659.116.713.633.930.375.881.544.432.930.4717.494.95

Page Writes/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max110.811.10.510.410.20.10.10.17.5032.4150.789.19000.434.2300030.4150.78
Avg0.01000.010.0100.0400000.0200.090.180.040000.120000.190.03

Disk Percent Usage

Drive000102030405060708091011121314151617181920212223
C - 100GB52.7952.7952.7952.7852.7852.7852.7852.852.7952.7952.7952.7852.852.7952.7952.7952.7952.7952.852.852.7952.7852.7852.78
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.7271.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.6833.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.6533.65

Used Disk Space (GB)

Drive000102030405060708091011121314151617181920212223
C - 100GB52.752.752.752.752.752.752.752.852.752.752.752.752.752.752.752.752.752.752.852.852.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.4143.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 - 100GB47.247.247.247.247.247.247.247.247.247.247.247.247.247.247.247.247.247.247.247.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.656.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.366.366.366.366.366.366.366.366.366.366.366.366.366.366.366.366.366.366.366.366.366.366.3

Disk Write Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max9.785.22.014.353.34.1512.510.164.797.437.76.297.685.659.617.385.474.8710.2210.226.657.849.095.0412.5
Avg0.760.730.620.520.620.710.840.980.660.790.790.830.860.80.770.90.750.751.340.970.830.771.171.020.82

Disk Read Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max5.336.9612.4711.3610.546.865.128.146.776.769.957.519.627.827.496.678.218.4311.767.726.877.2197.33797.33
Avg1.090.91.020.730.760.691.080.930.811.010.860.950.860.940.961.010.930.861.340.9210.841.451.160.96

Disk Split IO per second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max43.0423.3924.223.624.45.57.817.797.29.814.66.55.112.2139.7822.4114.596.38.86.25.67.095.955.8355.83
Avg1.10.480.50.510.360.380.550.430.450.550.370.470.370.510.610.610.480.410.520.440.440.410.390.740.5

Current Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max281521121718182468328322316101411721652622114246
Avg0.070.360.260.060.120.050.280.210.170.850.360.150.170.170.10.110.510.170.270.390.450.050.160.170.24

Average Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max11.625.2214.464.294.045.9813.6510.923.125.698.435.479.116.5513.537.327.374.4615.4214.2411.227.4116.915.3316.91
Avg0.270.250.330.150.140.140.470.30.150.180.210.20.30.240.260.270.20.190.380.390.310.240.380.30.26

Disk Read Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max23.66274.47108.7816.6312.3510.11309.087.7613.4810.186.948.225.228.0413.3521.545.934.9814.0911.43463.54.319.5817.89463.5
Avg0.955.12.590.740.50.379.040.620.470.560.360.520.450.470.520.710.420.320.560.4310.990.350.430.781.59

Disk Write Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max100.72288.68308.627.0521.492035.4226.6121.2354.0722.4426.9232.1832.3348.9537.3532.3430.6344.4837.6236.9731.1431.8732.34308.6
Avg4.347.165.843.122.522.372.892.812.663.222.843.013.023.033.263.323.23.073.383.493.193.183.473.673.42

Total Net Received Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max0.830.833.346.171.321.21.343.191.4212.171.353.482.561.481.362.871.51.443.163.093.391.381.491.512.17
Avg0.230.210.450.810.310.280.290.480.270.370.30.330.370.290.290.310.290.280.390.340.360.290.320.290.34

Total Net Sent Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max6.7510.2511.710.7210.339.9611.078.775.9816.429.596.317.787.257.858.326.525.528.586.36122.775.435.964.92122.77
Avg1.150.50.891.360.620.460.940.810.470.520.430.531.130.440.430.560.470.40.940.533.180.410.460.490.75

SQL User Connections

Counter000102030405060708091011121314151617181920212223Total
Min139131134127142135138128137140134128132136138128133137132128133137133136127
Max158156166181164165159169171214166161165162164166163157172167165157160162214
Avg146.39142.26150.41158.9152.61150.91147.38152.63149.8157.55149.66149.09150.99148.79150.01150.19148148.05151.33148.71146.85147.86146.8149.31149.77

SQL Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max93.24164.57244.54271.17121.29122.27206.81109.5102.7103.5795.0495.19133.23109.07103.84105.64112.22112.16120.43108.69106.48113.92104.18102.49271.17
Avg35.4535.0679.54100.8943.9237.8935.4535.1633.8735.4335.2433.8834.9234.1135.1134.3235.6134.0934.735.5634.6834.9236.0435.9540.07

SQL Re-Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max53.4665.56205.35235.1288.7977.98191.5163.6255.2554.9160.6564.192.0966.569.8564.3676.7167.2569.6658.9560.8574.9166.7956.09235.12
Avg13.4813.154.376.7222.0316.6914.1714.1512.6112.8713.8112.8313.1712.9913.413.2313.6912.6213.6413.9812.8713.2914.4913.8618.25

SQL Batch Req/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max574.77671.861815.683200.761021.24893.56873.311208.111070.14909.65892.841369.221004.941146.63886.831091.85970.36944.811512.271101.23934.11942.99995.04944.733200.76
Avg141.6140.84306.74517.41208.11192.21188.93288.65183.91193.71196.88223.86217.11188.88194.23206.83201.64187.31239.71206.3221.49193.62211.96191.89218.49

Log Flushes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max458.84486.961356.42752.44465.67539.71566.96407.28460.08506.41415.53512.32498.27530.39352.14385.22407.93449.5370.69537.85456.28591.05358.07550.821356.42
Avg74.4867.61124.3487.7566.2463.1961.9968.1667.0764.9162.2560.2966.2361.8264.5262.0664.8262.1565.766.4857.2962.8666.8467.9468.21

Lazy Writes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max87.265.6334.881.91.60.2189.420008.198.314.51.72.31.27.93.62.8305.014.34.4334.88
Avg3.010.124.360.090.0200.810000.450.190.230.030.050.020.110.190.110.0900.10.080.120.42

Page Splits/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max134.74123.272554.34377.53109.79121.95916.75309.18187.96299.1190.95418.52347.28192.5174.59367.49185224.04249.56271.01313.11141.25137.13127.492554.34
Avg26.7224.8743.7732.3426.4325.4128.5927.1532.2668.0165.0365.7964.864.2265.8766.0364.2865.8269.7765.6127.2124.9825.1125.1745.64

SQL Buffer Cache Hit Ratio

Counter000102030405060708091011121314151617181920212223Total
Min99.5899.9298.8899.8399.9899.9798.3399.6899.6299.9299.8699.8899.9499.9799.9499.9199.9664.8498.6699.9299.9399.8399.8799.964.84
Max100100100100100100100100100100100100100100100100100100100100100100100100100
Avg99.9910099.9910010010099.9810010010010010010010010010010099.910010010010010010099.99

SQL Cache Memory (MB)

Counter000102030405060708091011121314151617181920212223Total
Min31.2231.2233.2933.3433.2532.7332.7332.2330.830.832.0932.0531.1531.1531.1631.1631.1631.1831.1631.1631.2131.2231.2331.2530.8
Max31.2233.2933.3533.3633.3433.2632.7333.0532.2332.0932.0932.1232.0531.1631.1631.1631.1831.1931.1931.2131.2231.2331.2631.2633.36
Avg31.2232.5833.3233.3433.2633.1132.7332.4931.5131.2432.0932.0931.5331.1531.1631.1631.1731.1831.1731.1931.2131.2331.2531.2631.82

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
Max2234624242222222222322226
Avg0.050.030.110.140.050.010.080.050.030.010.050.030.030.030.010.040.040.050.050.040.020.030.030.040.04

SQL DeadLocks/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max0.10.20.10.20.10.10.40.20.20.10.10.10.10.10.10.10.20.10.20.10.10.20.10.10.4
Avg0000000.010.0100000000000000000

SQL Locks Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max4071337048991024.334742457171763854500842123947333839633619482033694695335443683260.33307447891871.543537176
Avg106.9760.8572.9652.8476.0647.35110.1987.2563.760.1885.1196.692.6856.8662.5576.4481.7875.5124.0169.952.0163.5553.7580.0675.38

SQL Latches Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max6.774.174.043.525.814.54.914.944.076.575.023.874.83.854.294.14.144.464.573.954.274.264.824.996.77
Avg1.030.610.570.460.630.781.020.810.680.840.770.890.940.860.760.840.870.880.890.820.880.850.840.90.81