SCOMSQL01 OpsMgr SQL Server

Daily Stats from: 04/22/2019

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max75.3157.3364.1343.4164.8553.5242.645.5843.1255.8677.9145.5961.5474.3652.2856.7144.4449.4652.3246.0998.5445.4243.9242.7298.54
Avg35.8430.4129.8917.5419.7918.7117.719.7117.2418.5119.1216.9218.4419.8918.3722.4119.7417.3218.3416.0222.1815.9217.7115.9220.15

Available Memory Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min1861183819691656188318661869185117631820144417891779177917741558180417721794185617571744172917561443.79
Max2297227522692224220821642171217222012159209820942122209320852105210321002166218521502112210521542296.9
Avg2152222622132148214221032122210421342068199020472044203320261982205020472064212520672055203320902086.13

Working Set (Used Memory) Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min13502135131350713525135601360713594135851357013629136861367313663136621370413662136741366513603135991354813579135651354713502
Max13848138041374914131138561390113872139121385513856141351393313863139781388114101138501386313913137571400913912138891370614135.06
Avg13593135561356713603136281366913647136501364013710137801373813736137391375513767137301373513721136541366513661136561358913674.54

Cache Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min279279278278278278278278275276276276277277277277277277278278279279279279275.3
Max479478477498477477477477479475569476475475476519475478482477478477480479569.15
Avg313293293295291293294294292292300289293299291308291290291294296297303301295.52

Pool Non-Paged Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min81818181818181818181818181818181818181818080808079.98
Max86818282818187828281818187828181818187818580808087.03
Avg81818181818181818181818181818181818181818180808080.73

% CPU Privileged Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max6.348.8811.549.219.4713.138.635.759.665.0117.79.156.328.524.459.159.826.119.944.6218.768.525.395.5418.76
Avg1.020.911.091.161.340.980.971.150.971.031.310.870.971.120.961.251.131.041.230.781.990.910.970.81.08

% CPU User Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max74.0155.562.542.2860.7645.541.6243.6442.2653.1860.1844.9760.5873.0450.8851.642.6747.2449.3843.9584.3743.9241.4941.7984.37
Avg34.8229.528.7916.3718.4417.7216.7318.5616.2617.517.816.0517.4618.7617.421.1518.6116.2817.1115.2320.181516.7415.1219.07

Processor Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2222222212222222222291229
Avg0.340.320.310.180.140.080.190.220.180.150.140.180.180.20.150.190.220.140.280.160.30.110.140.330.2

% Page File Usage Statistics

Counter000102030405060708091011121314151617181920212223Total
Min1.621.661.641.221.291.391.441.111.371.391.421.411.411.411.471.181.431.461.471.491.521.531.131.311.11
Max1.831.71.661.641.51.471.471.481.391.421.431.421.421.51.491.471.461.471.491.511.541.551.61.481.83
Avg1.691.681.651.391.431.421.451.341.381.41.421.421.411.431.481.431.441.471.481.51.531.541.511.421.47

Pages/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2375.14512.12512.233165.621770.56512.06511.662859.84512.37511.71668.06512.28813.82511.97853.233739.61511.97107.213433.18511.9248807.44512.382013.19511.4648807.44
Avg50.014.033.721.4319.245.763.9219.814.694.0116.134.118.284.799.0626.55.762.318.093.662454.124.9627.226.2113.66

Page Reads/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max64.0964.1264.13160.91249.3664.2664.15155.68124.0264.06105.0364.13161.6264.175.42177.6564.18.9433.5664.091533.8764.15246.6664.031533.87
Avg1.070.430.391.82.370.50.341.640.860.382.960.472.120.420.952.280.580.192.280.3578.610.522.690.374.36

Page Writes/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max10.10.1110.90.310.10.10.10.100.8010.50.10.10.10.10.1111
Avg0.01000.010.010.0100.0200000000.020000000.020.010

Disk Percent Usage

Drive000102030405060708091011121314151617181920212223
C - 100GB51.9151.9151.9151.9251.9151.9251.9151.9351.9251.9251.9251.9251.9251.9251.9251.9251.9251.9151.9351.9351.9351.9251.9351.92
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 - 100GB35.833.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.6933.69

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 - 100GB35.833.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 - 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 - 100GB64.166.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
Max4.365.668.299.915.087.849.8912.233.4613.6512.266.442.97.9411.454.119.688.699.355.0733.074.8221.864.6833.07
Avg0.720.810.720.580.580.720.680.930.640.890.740.810.70.920.690.780.690.791.110.880.890.651.360.940.8

Disk Read Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max13.717.569.1710.877.665.216.359.25.957.578.89.316.4221.246.885.776.776.896.395.419.785.286.16.0421.24
Avg1.11.020.950.740.770.680.710.910.720.860.820.870.941.190.720.860.70.791.030.840.880.661.080.870.86

Disk Split IO per second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max35.233.24.97.920.825.97.36.894.63.96.13.864.26.297.75.794.7911.55.8912.715.417.825.235.23
Avg0.970.370.370.450.50.410.410.440.380.370.50.410.430.440.40.470.420.360.430.390.50.420.50.390.45

Current Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1010519171515711471516437122711159851215431933157
Avg0.130.460.150.130.140.580.10.250.130.110.090.150.070.150.120.170.090.120.090.140.740.040.230.270.19

Average Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max4.865.5819.035.364.777.766.589.692.4211.068.15.832.820.497.934.1110.837.518.043.938.626.4118.917.4520.49
Avg0.280.330.360.170.180.170.170.250.150.280.210.20.170.350.220.210.250.210.260.180.370.180.380.230.24

Disk Read Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max19.04356.81130.729.6415.0422.1310.6311.0627.7415.9320.5810.195.0117.365.1814.384.6417.0813.886.88448.967.969.498.71448.96
Avg1.077.122.370.830.620.450.410.450.580.50.530.330.330.480.460.590.560.80.760.5320.520.550.80.561.76

Disk Write Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max105.85359.72267.9631.4721.3429.4718.1425.6431.0160.9328.1729.5930.2933.1733.6527.4234.3336.673929.9432.6838.3338.8235.99359.72
Avg4.6410.335.523.0832.442.382.562.863.212.912.842.853.243.233.553.413.663.613.393.443.453.793.583.62

Total Net Received Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1.372.961.272.864.92.611.343.051.2110.331.231.261.252.591.331.352.782.462.311.372.11.262.882.8310.33
Avg0.30.320.290.540.810.350.310.380.30.390.290.270.320.350.330.320.370.370.350.310.370.30.40.350.36

Total Net Sent Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max11.556.729.4514.3819.3110.559.3610.9313.5519.1110.177.138.21116.869.347.238.217.424.98119.515.837.116.63119.51
Avg1.40.530.491.041.280.670.911.220.730.680.630.51.220.960.580.580.580.631.080.445.870.430.710.560.99

SQL User Connections

Counter000102030405060708091011121314151617181920212223Total
Min1351261371459312413913814113813413413412113514712613312414313813312112493
Max164162165179177168162171172202159159172180158171171168174167168157164167202
Avg151.7147.74148.82161.12157148.83150.38150.72152.85153.96148.39148.75148.7152.97146.3159.18150153.67148.19155.13148.68146.74146.55151.36151.16

SQL Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max125.2899.76182.43195.12213.57119.71122.02105.8691.74106.18150.83105.1117.198.87106.35113.3689.19112.29110.94123.23118.05100.36107.0397.78213.57
Avg37.8635.4541.7896.4486.8141.5539.4835.1138.5335.7638.2135.9736.6336.6637.3240.4435.2635.8736.2340.9534.8235.0134.3534.9541.73

SQL Re-Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max82.8973.55101.13159.38185.9788.78101.179.0769.4679.41113.5751.5154.9965.7173.5284.7755.2265.1767.8285.9961.3569.6861.3155.62185.97
Avg14.7913.8516.8971.3862.8220.0817.7814.0316.0712.6215.8813.9514.1814.714.9818.5213.9414.5214.7919.4513.5813.1313.6813.519.55

SQL Batch Req/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1032.151158.86883.241365.592731.361530.341047.591120.27832.47914.96856.38846.9871.821101.391028.24920.31979.061005.451156.83869.4998.64876.041262.17955.642731.36
Avg190.11223.78202.4393.56485.6250.52212.39232.38207.25223.5197.15180.27203.94237.12227.14219.44224.6237.78244.25216.78193.9199.18252.97222.13236.59

Log Flushes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max693.23417.391274.92471.35527.46380.51401.24446.03559.45609.62441.29659.83451.25503.57523.55484.89550.67560.58528.08449.14456.95514.36459.6591.021274.92
Avg75.2670.499.1890.3293.2969.7665.5266.7472.0667.7971.0568.5164.975.6170.8975.1272.3369.5870.6666.9161.9364.1766.8769.0972.41

Lazy Writes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max65.0715.48228.142.113.790.50.24.21.4121.376.5324.1816.281.515.82.800001.81.24.5228.14
Avg2.820.653.490.080.150.0100.10.020.450.160.090.30.110.050.250.0400000.010.040.040.37

Page Splits/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max186.43366.134524.87251.26450.96329.19190.44205.29181.17227.65307.18215.84295.91312.51313.9239.81236.81202.39364.28153.24184.39208.19238.96244.964524.87
Avg66.665.7981.6568.3171.3166.2664.7663.8164.667.4766.565.5765.4968.4777.66106.3979.4638.5424.872528.5927.3627.0425.4458.62

SQL Buffer Cache Hit Ratio

Counter000102030405060708091011121314151617181920212223Total
Min99.5599.8797.5199.6799.9873.4999.6799.5299.9299.8599.8199.6599.8599.9199.7999.9499.999.9799.9599.9699.9899.9599.9799.9773.49
Max100100100100100100100100100100100100100100100100100100100100100100100100100
Avg99.9910099.9810010099.92100100100100100100100100100100100100100100100100100100100

SQL Cache Memory (MB)

Counter000102030405060708091011121314151617181920212223Total
Min29.8129.8329.8430.0430.1130.2630.2430.2430.3528.2631.1631.231.231.2131.2331.2931.5931.6631.2731.2731.2731.2731.2731.2328.26
Max29.8329.8430.0430.1230.3130.3130.2630.5730.3831.1631.231.231.2131.2331.2931.5931.6631.6731.6631.2731.2731.2731.2931.331.67
Avg29.8329.8329.8930.0930.2530.2830.2530.3730.3630.7231.1931.231.231.2231.2531.4431.6431.6631.5631.2731.2731.2731.2831.2930.86

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
Max4283522222222224222222228
Avg0.080.020.220.210.260.050.030.050.040.040.040.040.030.070.030.050.060.060.030.020.040.030.040.030.07

SQL DeadLocks/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max0.50.20.20.20.10.10.10.20.20.20.20.10.20.20.10.20.10.20.20.10.10.10.10.10.5
Avg000.010.01000000000000000000000

SQL Locks Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max3260.673478110451411.672966.8847582153446148671701376035564649488325323229.64945457149601372427449144992404011045
Avg113.4795.43844.2153.0268.01104.9147.78114.736967.4106.5266.0372.87111.7744.0171.5978.683.617234.6875.0265.1566.8976.16108.45

SQL Latches Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max12.667.5415.933.273.775.075.636.514.055.435.074.835.557.165.24.745.224.224.884.545.933.6710.775.9615.93
Avg1.1711.240.630.851.061.111.141.061.171.161.171.011.121.071.161.110.890.880.670.840.740.960.881