SCOMSQL01 OpsMgr SQL Server

Daily Stats from: 04/25/2019

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max84.6756.4952.8449.5651.347.7962.5448.5458.7577.158.8357.3455.6551.8257.6269.6849.9444.5250.9143.394.0638.9939.0453.2594.06
Avg40.0723.4822.2920.9619.0920.052119.8620.5223.1625.0524.225.6622.922.0123.3820.0118.9616.9614.0717.6913.613.1615.1220.97

Available Memory Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min1761182814821730175917061705173317351239156815471539155813911544156915751666164815361601163715321239.01
Max2164213721322097206920742079207320862024187218501876186118761903191719771980196619321918190519742164.19
Avg2055208420652031199820172012201819991919181118001803181217901813183719201918190918471860185219021919.75

Working Set (Used Memory) Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min13602136081361213658136861366813681136751366413739138601385313882138651385313837138071375313751137741378713773137621374913602.2
Max13918138861400813893140241388213961138741389014483141851407414156140361436914230140771402214037139521416214002139791411814483.11
Avg13699136591367713717137451372513732137181375013834139271393913943139311394613914139041382313846138371385413834138391382413817.45

Cache Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min267273273273273274273274272272272272272272273273273273273274275274275275266.57
Max473477476479477476499476475592471472473472472472472473474474474475473497592.23
Avg298296294296297296297296295296294293293294297295295295296297299287292290294.94

Pool Non-Paged Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min80808080808080808080808080808080808080808081818179.96
Max80868680808080808080808180808080808082808481828386.3
Avg80808080808080808080808080808080808080808281818280.27

% CPU Privileged Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max11.728.689.144.68.023.439.849.979.9214.8110.915.0511.435.279.711.059.454.898.874.511.418.544.219.4314.81
Avg1.240.931.221.140.950.781.141.061.111.141.081.071.320.911.11.271.020.840.90.681.480.730.681.081.04

% CPU User Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max83.655.6248.3147.7347.945.2255.8846.2352.9873.1253.5153.3154.2750.451.8764.4547.7643.6449.7741.9185.9938.5538.3651.0885.99
Avg38.8322.5421.0719.8118.1419.2619.8618.819.4122.0223.9623.1324.3421.9920.9122.1118.9818.1216.0613.3716.2112.8712.4814.0419.93

Processor Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max4222222223212222221271227
Avg0.320.30.160.120.130.20.260.10.270.340.260.140.280.120.140.220.270.30.150.240.210.090.110.180.2

% Page File Usage Statistics

Counter000102030405060708091011121314151617181920212223Total
Min7.627.637.316.957.127.16.686.876.86.766.636.656.726.746.356.216.376.46.386.386.326.336.335.935.93
Max8.067.677.497.327.217.157.146.946.946.836.776.766.766.776.766.516.496.456.436.46.376.346.346.338.06
Avg7.77.657.417.227.167.127.076.896.886.816.716.726.746.756.666.456.426.426.416.396.346.336.336.066.78

Pages/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2365.29305.31678.572508.67849.36526.463492.39511.97877.38656.052208.351543.14622.29511.823794.442318.79512.28892.413219.56511.4652554.87512.59514.345721.7252554.87
Avg60.914.9110.6621.898.734.3622.776.1613.2610.7616.8610.598.494.3424.8417.254.967.8520.063.622464.286.713.6462.96117.54

Page Reads/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max401.86206.67339.29390.5564.1967.57213.3464.1234.21139.12328.11200.85272.7664.08183.53267.9764.13769.49402.7664.031642.34140.464.48952.241642.34
Avg3.312.442.652.620.840.382.30.562.82.382.341.042.010.412.521.330.383.062.490.3378.260.980.369.385.22

Page Writes/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max0.60.30.510.80.510.90.30.4110.70.30.710.70.70.40.10.10.10.111
Avg0.01000.020.0100.010000.010.01000.010.020.010000000.020.01

Disk Percent Usage

Drive000102030405060708091011121314151617181920212223
C - 100GB52.7852.852.852.852.852.852.852.852.852.852.852.852.852.7952.7952.852.7952.7952.7952.7952.8152.852.7952.84
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.6533.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.7633.76

Used Disk Space (GB)

Drive000102030405060708091011121314151617181920212223
C - 100GB52.752.752.852.852.752.752.752.852.752.852.852.852.852.752.752.752.752.752.752.752.852.752.752.8
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.733.733.733.733.733.733.733.733.733.733.733.733.733.733.733.733.733.733.733.733.733.733.7

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.147.247.247.1
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.366.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
Max8.028.519.446.967.314.954.834.919.85.799.439.543.594.984.15.468.27.4212.66136.7414.2524.9114.3324.91
Avg0.940.80.770.640.580.650.640.70.710.830.7510.720.770.580.70.690.691.351.120.850.891.361.140.83

Disk Read Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max5.549.814.885.618.278.676.186.469.557.934.7127.456.944.937.13.444.056.095.455.317.945.867.126.5227.45
Avg1.180.950.920.720.680.670.660.670.690.840.780.940.80.780.680.670.620.691.020.80.790.650.950.870.79

Disk Split IO per second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max35.3311.94.829.636.092.86.64.158.6920.9329.627.14.26.424.523.15.4910.36.716.94.84.114.235.33
Avg1.070.430.420.540.440.380.440.440.460.490.530.510.420.430.460.490.390.440.490.440.450.420.390.550.48

Current Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max201428312015111218371802110641984715109203422183
Avg0.140.230.210.210.190.150.070.120.620.080.060.480.150.150.250.150.090.180.120.510.360.050.320.080.21

Average Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max8.846.5313.89.083.286.93.938.9412.619.499.520.325.423.923.044.758.134.7126.5117.9611.1622.3518.7830.7930.79
Avg0.330.260.410.20.160.160.170.220.230.290.270.420.210.180.170.230.240.230.630.460.50.420.570.80.32

Disk Read Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max19.21294.75131.5817.1219.594.7513.556.914.7615.2110.1511.316.059.6614.8211.268.1210.1812.727.9457.94.464.5921.41457.9
Avg1.143.752.20.70.740.440.630.610.650.640.620.640.640.520.620.970.530.610.640.7620.670.510.661.371.72

Disk Write Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max99.62294.9259.1929.7929.0625.2825.7627.8226.351.9326.7138.1934.535.1637.8644.5531.4631.3537.8734.9243.0729.1732.5933.42294.9
Avg4.885.845.793.162.892.612.832.993.053.713.363.473.423.283.684.013.53.653.713.83.633.543.674.53.71

Total Net Received Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2.622.543.145.023.253.321.322.452.8610.471.572.231.41.091.43.481.361.41.292.472.641.412.554.8610.47
Avg0.360.360.470.790.360.40.320.40.360.390.310.360.320.290.310.480.290.280.330.340.440.310.350.60.38

Total Net Sent Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max7.767.31212.6211.539.398.037.998.1421.159.5525.0411.827.6912.2516.546.8911.028.1513.33122.077.976.4529.98122.07
Avg0.850.480.821.40.870.711.310.850.660.70.70.861.580.530.71.350.560.621.070.796.030.480.61.471.08

SQL User Connections

Counter000102030405060708091011121314151617181920212223Total
Min130130141126127128136138123137136142140136143121135130135122122131118124118
Max166159183172172173165162166209163218161163171248164165164159158159160225248
Avg150.01149.69160.31158.46153.75155.17151.96152.52146.84153.88151.38162.86152.54152.07154.24164.11146.27147.94149.3146.77146.91145.49145.26156.38152.25

SQL Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max122.38168.91199.25198.33147.85116.14190.9195.9486.16165.86106.91132.9396.6293.55101.7106.97128.96113.58108.77105.33118.61123.1789.72103.62199.25
Avg38.9334.6578.7398.624839.8739.6239.236.7639.1339.0738.2437.0134.7638.6738.135.3737.0237.7336.136.134.9433.6338.6642.04

SQL Re-Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max89.4365.94160.92171.74103.1666.97171.2164.8454.280.4964.2268.5262.6359.3871.6775.5569.0382.6672.5767.1691.2965.2461.5274.68171.74
Avg16.812.4153.274.2425.1717.7517.0716.8215.1115.3716.1516.214.7713.4615.7415.2813.5714.4415.5913.9814.1513.0813.2116.1719.57

SQL Batch Req/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max979.74891.491462.271944.281092.131236.281083.651211.851139.88888.93976.661062.14932.8759.751092.931686.081062.63966.84893.81065.35972.431024.941038.851944.151944.28
Avg248.62212.49326.26501.79254.06254.8208.55243.67244.26213.83208.73259.69202.33189.76205.64321.85192.72189.28214.87225.8218.01199.77212.99347.94245.74

Log Flushes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max475.89409.121129.29649.13368.86535.58467.95577.44569.4630.87580.81500.37411.41562.08451.16484.33587.45448.75590.93607.58464.04840.86410.22453.011129.29
Avg86.6667.6119.8496.0772.0769.1370.3978.7472.9678.1176.678.3771.7464.2974.9475.7470.8974.2373.2963.347263.4665.0476.275.49

Lazy Writes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max112.392430.156.37.90.90.51.20.8312.739.3714.4905.613.31.92.19.417.23.64.16.68.6430.15
Avg3.390.114.60.120.080.020.010.010.010.120.140.330.0600.170.080.080.020.160.130.170.10.180.180.43

Page Splits/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max147.31221.24453.86377.72305.23193.65152.91246.13320.82374.31552.62419.56113.9123.41259.18478.21197.43175.16213.63326.75255.58211.15312.69491.424453.86
Avg27.5625.0642.8531.828.5826.5324.6125.525.9445.6965.5234.9725.9225.4459.6883.3465.4666.6670.3969.4568.0764.9660.8590.3448.13

SQL Buffer Cache Hit Ratio

Counter000102030405060708091011121314151617181920212223Total
Min99.1299.9696.9599.8799.9799.9699.9699.9899.9499.999.9654.7899.8899.9699.9199.9499.9499.8699.9499.9599.8199.9799.9699.8654.78
Max100100100100100100100100100100100100100100100100100100100100100100100100100
Avg99.9910099.9810010010010010010010010099.8710010010010010010010010010010010010099.99

SQL Cache Memory (MB)

Counter000102030405060708091011121314151617181920212223Total
Min31.2631.4132.5532.4332.4632.4832.4932.4932.8131.4832.1632.1632.2732.3332.432.5232.5932.0232.0632.1632.0532.0532.1532.2431.26
Max31.2732.5532.6132.6232.4932.5132.4932.8132.9132.9832.232.2732.3332.432.5232.7232.7332.7332.1632.1732.1632.1532.2432.2632.98
Avg31.2632.1232.5632.5132.4932.532.4932.6532.8732.6932.1732.2232.3132.3632.4732.6232.6632.0632.1532.1632.1132.1132.2132.2632.33

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
Max321242222322222222212222412
Avg0.070.040.180.210.070.030.040.030.050.040.060.070.040.020.030.030.040.0500.020.020.030.020.060.05

SQL DeadLocks/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max0.10.10.20.10.10.20.20.20.10.10.20.20.20.10.10.20.20.10.10.10.10.10.20.20.2
Avg000000000000000000000000.010

SQL Locks Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max3854386813881133.25382238694789324543212802.333136444625124508.5377540254867457132913385471240871731.6744154867
Avg107.73109.8157.4553.6105.0191.4866.2169.8689.0166.7575.48136.570.9268.7169.6106.9359.3986.7343.5267.972.9853.537.84102.4477.89

SQL Latches Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max6.447.453.84.783.764.814.113.964.916.66.017.295.385.454.485.884.84.525.253.764.224.143.54.527.45
Avg1.270.980.870.70.660.80.830.740.841.021.121.040.991.060.881.030.840.840.780.650.70.740.540.660.86