SCOMSQL01 OpsMgr SQL Server

Daily Stats from: 09/20/2019

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max64.0458.359.345.9458.8656.7142.3940.1457.651.8660.9947.5251.6852.0456.9753.4152.4841.3945.3447.1399.6952.6848.7152.9499.69
Avg34.9119.6519.7217.0715.5516.7616.0814.7314.9521.7420.9817.0217.3820.1119.2520.2217.7615.7315.7214.8219.0914.814.5415.2318.08

Available Memory Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min1722195419952017195519531834199214201925186718481825187718331475187719591973196717841888185517611420.09
Max2298230923612356230022902277230923072297218321462150217621552311231523032305229022292237222822362361.41
Avg2170224222612271223822262178225922022180211020852091210720982122225022472231223921582170216321332184.57

Working Set (Used Memory) Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min13409134461341113381134631347413486134541346513471135871360713586135791358913431134261343113416134391346013453134371348413380.75
Max13804136931366013733136951366213899136141430613855139201385413784137811389714006137281373213763136491388713663137031383814306.34
Avg13553135121349613482135091352213553134931354613578136501366813666136521366513606135031351413529135181355113529135341356713558.16

Cache Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min279279279279279279280279276277277277277277277278277278278277278278278278276.09
Max506477481478480481484479478477476478477476477581480476476476478478477516580.78
Avg318302300302301303304301308299297299299298299303300298299298300300300300301.23

Pool Non-Paged Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min81818181818181818181818181818181818181818181818180.67
Max81818281818181848281818182818181818184818381818284.11
Avg81818181818181818181818181818181818181818281818181.01

% CPU Privileged Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max6.659.285.568.919.185.848.573.9217.319.348.819.025.324.9710.176.1510.3610.248.672.7916.748.72.898.2517.31
Avg10.771.231.240.990.891.10.911.191.061.10.980.9111.031.010.980.960.940.81.770.830.760.931.02

% CPU User Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max61.3757.7457.2444.0456.7454.5440.6738.6654.6748.859.1546.6549.6250.2548.1852.9550.2340.6943.5944.5585.0851.2247.3351.2185.08
Avg33.918.8818.4715.8314.5515.8714.9713.8113.7620.6819.8816.0516.4719.118.2219.2116.7714.7714.7814.0117.3113.9813.7714.2917.06

Processor Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2252222222222221222272227
Avg0.310.160.190.140.130.160.140.150.120.230.210.150.170.210.190.150.190.140.180.140.260.190.120.140.17

% Page File Usage Statistics

Counter000102030405060708091011121314151617181920212223Total
Min1.221.491.531.341.511.561.161.461.471.511.41.521.541.571.591.181.381.421.461.511.571.61.611.251.16
Max1.51.531.551.571.571.61.61.481.541.531.581.571.61.621.611.61.441.471.521.591.631.631.621.631.63
Avg1.461.521.541.531.521.571.41.471.491.521.521.541.551.581.61.341.41.441.481.541.591.611.621.571.52

Pages/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2596.79512.58522.191308.15537.09512.073163.78534.59607.82511.872122.17512.22495.52127.93512.562379.45512.53512.153432.22476.4955313.88512.23513.333223.7855313.88
Avg56.044.185.2517.375.943.7923.033.679.654.7317.464.055.782.623.7321.185.45.4420.114.152415.374.833.617.49111.04

Page Reads/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max90.0564.2665.24163.3164.0464.11186.965.34112.0664.08279.4364.13212.929.364.17187.464.2564.21433.2956.361791.0664.1364.45193.511791.06
Avg1.410.390.531.80.530.312.040.341.80.681.910.361.650.190.371.950.520.532.470.3178.340.490.331.634.2

Page Writes/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max10.30.310.90.510.10.60.110.70.60.50.310.90.60.80.60.60.30.10.41
Avg0.02000.02000.020000.0100000.0200000000.010

Disk Percent Usage

Drive000102030405060708091011121314151617181920212223
C - 100GB51.9351.9251.9251.9251.9251.9251.9151.9151.9151.9151.9151.9151.9151.9251.9251.9251.9151.9151.9151.9151.9351.9251.9151.91
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.1133.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.1933.19

Used Disk Space (GB)

Drive000102030405060708091011121314151617181920212223
C - 100GB51.951.951.951.951.951.951.951.951.951.951.951.951.851.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 - 100GB33.133.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.866.766.766.766.766.766.766.766.766.766.766.766.766.766.766.766.766.766.766.766.766.766.766.7

Disk Write Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max8.5412.998.377.1315.0112.087.3710.449.8110.5510.798.878.48.756.288.579.198.229.924.465.544.6618.434.318.43
Avg0.890.880.750.590.640.770.7210.810.980.940.910.791.10.871.060.780.791.280.750.750.681.320.950.87

Disk Read Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max10.166.1125.225.8510.078.047.416.619.798.757.646.64.2212.17.2310.578.337.217.943.338.37.095.7413.0225.22
Avg1.020.820.910.670.740.750.80.940.951.070.890.960.770.980.931.120.940.841.150.780.870.861.121.060.91

Disk Split IO per second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max36.285.64.814.913.73.36.593.87.74.528.795.55.14.13.79.395.16.111.26.134.24.519.3836.28
Avg1.010.430.410.490.390.370.440.370.50.410.570.410.40.370.380.450.420.450.50.420.410.410.390.470.45

Current Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1514264423149121492815255525018102421724113118250
Avg0.120.280.230.230.050.060.150.080.130.630.140.120.220.40.810.130.150.140.060.150.380.130.320.190.22

Average Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max15.678.6324.658.748.8910.939.4316.387.357.8112.8610.317.849.878.0912.818.4314.4410.241.937.954.0516.763.8924.65
Avg0.40.320.520.220.180.220.210.280.230.280.350.260.230.40.280.350.270.30.310.180.360.180.360.230.29

Disk Read Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max17.69469.74152.8617.868.6212.8919.317.526.3116.2214.8511.037.4210.776.8211.617.086.9813.767.95449.748.396.3412.37469.74
Avg1.238.062.780.880.550.430.720.480.510.570.610.390.540.530.380.460.30.290.390.420.10.250.290.41.73

Disk Write Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max102.77470.04246.3125.3823.3418.4830.2230.0529.1938.2529.0730.0732.2331.9230.2933.6633.9934.7238.1430.1233.0735.4136.2935.76470.04
Avg4.3110.175.413.452.682.682.892.612.793.373.23.123.193.453.323.453.283.243.23.473.293.23.183.423.6

Total Net Received Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1.381.373.223.021.31.662.611.281.2210.173.721.311.271.492.91.321.491.351.43.382.91.31.332.9610.17
Avg0.320.280.520.620.310.310.340.280.270.420.330.30.310.310.340.280.290.290.30.390.430.280.30.320.34

Total Net Sent Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max13.395.6813.413.179.556.8812.497.0811.1516.8325.1816.129.318.296.699.259.254.257.387.69119.925.626.2211.54119.92
Avg1.40.411.11.240.630.530.790.60.750.610.820.641.270.820.590.570.570.470.870.655.830.410.390.490.94

SQL User Connections

Counter000102030405060708091011121314151617181920212223Total
Min141133129130134137127136132132134139140146139145151153150126132132132119119
Max171161181175163160168162172226225169165164170170175171168182161153157161226
Avg156.27147.85156.38157.67149.93149.13147.97148.78155.01158.95160.12152.64153.8153.3159.3160.89161.84161.27160.64152.02147.6143.49144.62147.35153.62

SQL Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max103.17174.05227.02183125.63108.94155.9189.26119.66115.74109.37110.17138.84102.6995.89103.81116.32123.4191.79104.15107.45107.81119.03113.93227.02
Avg38.4134.3582.7195.7945.6639.2536.9934.5235.2134.8435.6836.936.3337.7835.8536.437.1836.5333.7335.5334.634.6934.2433.8240.71

SQL Re-Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max66.2272.45205.83151.6597.3262.25133.2155.6164.8269.8462.3578106.663.0764.162.5781.3459.8668.4967.5764.2867.6568.6264.38205.83
Avg16.112.9357.6871.8124.2618.3915.8813.7313.412.4614.115.4114.8316.614.2814.8414.8514.9513.2614.5213.2913.6913.813.2119.09

SQL Batch Req/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max936.16935.261811.431266.23878.861201.35934.55886.98893.571129.861403.521040.959071023.351243.081026.241078.39923.68978.951224.1883.7993.65829.261072.181811.43
Avg209.46183.61369.39454.12215.98213.66236.44190.77179.28218.69246.85204.72197.65209.09209.12189.85196.57200.59197.02254.76212.59191.1202.58222.52225.27

Log Flushes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max578.15672.031363.72500.02495.77621.17472.43468.74565.23588.51329.08548.62573.44378.92413.48565.48588.32451.44418.76488.81627.68457.44558.19623.821363.72
Avg75.666.56121.96104.6171.8571.7267.3962.266.5768.4967.5267.3266.0175.2873.4469.6474.0770.6660.7866.6766.165.264.0962.1971.91

Lazy Writes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max23.831.7580.0611.912.81.32.74.7091.0131.6911.183.85.295.412.61.14.83.52.410.9118.96.68.81580.06
Avg1.620.142.90.380.020.010.050.0800.420.220.20.010.060.120.0600.20.10.080.120.450.260.150.32

Page Splits/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max482.46494.674889.14605.63472.59526.12477.87478.29146.84310.57131.73122.8128.43115.99149.1137.53123.62133.11271.07427.09266.88144.31137.48305.724889.14
Avg263.88261.77282.57270.78263.38262.84262.5201.5626.8427.9926.3426.0724.825.2827.8526.2825.125.6728.5429.2427.3124.3723.925.24103.75

SQL Buffer Cache Hit Ratio

Counter000102030405060708091011121314151617181920212223Total
Min96.7599.7394.1599.5499.9472.0599.6799.8891.4499.8399.8699.7999.8893.5399.9799.8699.9799.9899.9899.9399.8499.9599.9499.9772.05
Max100100100100100100100100100100100100100100100100100100100100100100100100100
Avg99.9899.9999.9699.9910099.9210010099.9710010010010099.9810010010010010010010010010010099.99

SQL Cache Memory (MB)

Counter000102030405060708091011121314151617181920212223Total
Min33.1433.1433.9533.9534.0334.0433.9533.9534.2830.5932.5132.5232.5232.5332.5932.4532.4732.4832.4832.4832.4832.4932.4932.5230.59
Max33.1435.1334.7934.0334.0434.0434.0634.2834.334.4432.5532.5932.5432.5932.6132.6232.4832.4832.4832.4832.4832.4932.5232.5235.13
Avg33.1434.2734.573434.0434.0434.0334.134.2933.2832.5432.5732.5332.5632.632.5532.4732.4832.4832.4832.4832.4932.5132.5233.13

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
Max3243224222222222222222224
Avg0.030.030.140.180.050.020.030.030.040.020.050.030.020.050.030.050.050.030.020.030.030.040.010.020.04

SQL DeadLocks/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max0.10.10.10.20.10.10.20.20.10.10.10.10.10.10.20.10.10.10.10.10.10.10.10.10.2
Avg0000.010000000.0100000000000000

SQL Locks Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max347839162313.672468.536973947261542593978174742742418.25331538534368488345394228444648993250.333385483617474899
Avg74.5155.3155.4162.6777.8590.0965.966.3777.2338.99105.2248.7958.6990.8978.08104.85124.8474.8445.5788.1542.6156.4752.5138.3269.76

SQL Latches Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max7.3219.393.453.35.615.084.234.167.674.365.065.76.685.845.477.225.275.743.864.65.85.54.94.6819.39
Avg0.950.710.60.450.570.640.680.790.850.991.050.830.941.050.961.070.860.860.860.610.780.640.670.70.8