SCOMSQL01 OpsMgr SQL Server

Daily Stats from: 04/21/2019

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max75.1448.0277.4255.0841.847.7347.1871.7652.6550.8649.7142.1751.0551.6952.4652.6350.7145.9944.8242.6799.4342.339.2945.399.43
Avg27.4414.7520.1118.2215.0716.3915.0814.8714.4217.1715.4416.0519.7119.3119.1319.4817.4716.7416.815.3520.1215.8415.1115.8117.33

Available Memory Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min1924196218931851191018811941168019141738193119451951196321261993200120032025199018731929191917701680.33
Max2281227323112254221822472245224222422236224022432283246124632416238023442341229922512219219321792463.44
Avg2165220922442170214621672186215721792128219021812207225624012320232022922257223721862181215121342210.93

Working Set (Used Memory) Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min13449134591342713499135471348913526135181350813532135231352913498133141331513368133521340513435134741347613472135091352613313.5
Max13734136921374313793138581373413705139911369313989136911368013717136531355613758135621362313733137171387413680137031380513991.32
Avg13566135521351913590136111359113575135901356913616135691357213558135051336113434134321346913505135241354513535135581357113538.31

Cache Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min278278279278279279279278276276277277276276277276277277277279279280279279276.2
Max479483477480480477479500477477477476478476476478476475478477478477479478499.61
Avg311301300301300299301304298308299303297297298301297298300301295295292295299.6

Pool Non-Paged Bytes Statistics (MB)

Counter000102030405060708091011121314151617181920212223Total
Min81818181818181818181818181818181818181818181818180.63
Max81818183818281868181818187828281818281818582818286.99
Avg81818181818181818181818181818181818181818281818181.02

% CPU Privileged Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max5.964.615.6910.299.94.73.999.243.6413.733.595.7110.746.349.979.884.9948.888.8518.793.988.439.8218.79
Avg1.130.781.271.390.910.780.790.930.831.120.720.81.020.860.921.080.860.860.980.861.780.830.820.920.97

% CPU User Time Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max72.5446.1361.8146.740.4246.6644.7564.6850.7448.1647.6541.1250.2349.7950.1750.4947.2645.3743.8641.287.5341.4938.4943.987.53
Avg26.313.9718.8416.8214.1615.6114.2813.9413.5916.0514.7215.2518.6818.4518.2118.4216.615.8715.8114.4918.3415.0114.2914.8816.36

Processor Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2232121222221222222392229
Avg0.170.160.190.20.090.140.10.20.110.210.10.150.190.160.140.210.170.190.140.10.230.110.120.10.15

% Page File Usage Statistics

Counter000102030405060708091011121314151617181920212223Total
Min1.331.471.521.341.471.531.561.21.441.521.551.571.581.611.611.191.341.461.451.51.571.591.611.621.19
Max1.491.541.561.561.531.561.581.591.581.581.621.621.631.631.631.631.481.531.511.571.591.621.631.631.63
Avg1.391.51.531.511.491.541.571.521.461.561.581.581.61.621.621.581.421.481.481.541.581.611.621.621.54

Pages/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2598.39511.72511.971177.22512.48512.28511.512353.87256.011961.26512.693507.15230.43511.87511.463323.08512.28512.133436.79484.9752997.69539.591094.62512.1252997.69
Avg50.64.325.2216.016.034.153.7430.244.0517.374.4619.143.193.44.9817.546.174.0320.795.652607.514.311.735.58119.18

Page Reads/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max58.864.0664.1136.2664.2564.1364.04254.2340.27230.0564.19283.0417.9964.0864.03163.5964.1364.12433.9560.721675.2864.45139.364.121675.28
Avg1.090.360.531.640.570.350.342.670.262.860.422.470.280.330.61.460.50.312.550.583.340.391.440.594.41

Page Writes/second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max10.50.610.50.50.11.110.810.80.90.20.30.710.70.70.50.30.50.10.11.1
Avg0.01000.010000.030.010000000.010.0100000000

Disk Percent Usage

Drive000102030405060708091011121314151617181920212223
C - 100GB51.9151.9151.9151.9151.9251.9251.951.9151.9151.9151.9151.9151.9351.9351.9351.9251.9251.9251.9251.9251.9351.9351.9251.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 - 100GB35.7335.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.8

Used Disk Space (GB)

Drive000102030405060708091011121314151617181920212223
C - 100GB51.951.851.951.951.951.951.851.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.735.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.835.8

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.264.164.164.164.164.164.164.164.164.164.164.164.164.164.164.164.164.164.164.164.164.164.164.1

Disk Write Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max9.537.4310.316.926.796.236.925.94.384.632.474.678.418.266.726.137.783.612.713.244.192.839.393.6112.71
Avg0.870.780.740.690.630.690.640.610.590.680.650.710.80.970.750.710.640.681.060.710.640.581.010.820.74

Disk Read Latency (milliseconds)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max8.478.9629.846.179.296.3311.6928.7714.879.937.137.67.267.778.118.527.676.8117.0411.446.976.0112.076.5129.84
Avg1.110.931.050.830.750.740.80.910.830.810.80.790.850.880.720.870.660.721.010.80.810.690.930.920.84

Disk Split IO per second Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max39.133.34.214.914.55.74.833.762.821.7147.36.116.116.67.194.35.313.35.68.714.75.9539.13
Avg1.030.40.430.470.40.410.430.550.380.550.40.490.430.440.450.450.380.410.490.440.480.390.430.420.46

Current Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1422142730153116233183262923927114161915192010239
Avg0.130.280.290.320.140.130.120.170.160.060.10.040.190.170.730.260.030.110.140.250.310.160.140.070.19

Average Disk Queue Length Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max9.475.4628.5114.4410.548.687.7517.745.737.922.374.7210.8810.3512.688.325.414.331.513.075.22.4311.144.4931.51
Avg0.270.280.580.330.180.190.150.170.160.220.130.170.260.360.290.280.240.190.380.180.330.160.260.210.25

Disk Read Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max18.61332.56122.7123.721.0613.354.8717.3221.9117.3725.0213.6912.7111.859.8220.189.2215.2614.4115.3473.768.26.1313.95473.76
Avg0.688.794.740.80.460.470.370.570.610.760.380.340.630.460.470.640.50.520.490.4121.820.480.340.431.92

Disk Write Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max87.59332.9181.5231.5524.6623.7821.6927.1231.1449.0129.9639.932.0331.9439.3434.2235.3237.5349.4834.0237.1947.6931.2743.77332.9
Avg3.2810.747.283.922.712.812.552.663.284.0132.963.523.463.493.843.723.713.693.513.733.693.263.473.85

Total Net Received Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max2.641.352.963.871.461.311.333.781.510.251.481.722.893.131.42.851.222.491.41.382.922.991.371.2410.25
Avg0.370.30.480.820.310.310.280.320.290.420.270.290.360.330.290.350.30.340.310.30.450.320.280.30.35

Total Net Sent Throughput (Mb/sec) Statistics

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max9.745.7725.3814.639.8611.059.2931.8113.0219.6711.545.8411.946.59.4210.629.249.849.638.46124.398.77.997.67124.39
Avg1.180.411.051.310.610.570.890.980.911.090.50.391.40.70.520.760.620.860.950.476.30.640.410.51

SQL User Connections

Counter000102030405060708091011121314151617181920212223Total
Min130134140136139139138136134132136139141123137121139132135141126132134133121
Max161166177187160165163215177235161161172162163167160171155166166164157161235
Avg147.6151.91159.65163.91149.64149.78148.95157.74152.76168.97147.18149.82155.9150.07150.11151.55147.87154.48145.63153.12147.29148.78145.26146.11151.84

SQL Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max97101.94222.65242.1139.56122.05164.0188.89110.71115.4799.995.25102.34116.84106.18101.7794.01111.35108.42117.19116.45113.8896.387.19242.1
Avg35.2835.5179.92100.0846.7240.0236.1533.7938.3139.0434.1734.9236.5236.3936.1438.3637.8838.1337.6635.9536.9136.5233.3434.8341.36

SQL Re-Compilations/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max51.9564.24197.95193.26103.2278.63143.8157.7367.3880.2164.8464.2568.0267.1659.5664.1866.7874.7365.4673.4471.3866.4959.7554.63197.95
Avg14.1114.5254.4876.224.9518.6914.9712.8715.8915.4913.0813.814.771514.5115.9115.6215.4715.4113.7314.6114.7112.3613.4119.36

SQL Batch Req/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1263.32955.331236.361798.09982.33894.95872.871321.171149.321420.851042.56970.611028.751425.361064.521029.81888.621165.661007.54929.51352.851202.05876.19906.311798.09
Avg230.58204.78325.9534.24221.69217.34184.33219.1204.32254.33181.6192.35216.58231.02196.49212.98202.45235.11210.13201.25238.87224.63191.57201.3230.54

Log Flushes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max474.28509.571193.39782.38502.67519.66509.97515.57597.5502.47575.11475.4370.75506.32511.68372.44425.05464.44579.98630.41504.17473.22348.68578.81193.39
Avg71.6670.04119.73119.8568.7468.3860.7353.677.575.857.1858.7670.4668.6368.9772.371.2471.1972.9365.6470.7368.5560.9163.4971.96

Lazy Writes/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max75.3714.7441.4910.90.501.740.587.324.310.56.12.202.510.77.7112.395.73.413.424.17.8441.49
Avg2.470.613.230.280.0100.030.030.010.420.120.30.190.0400.070.250.20.310.250.110.380.180.240.41

Page Splits/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max191.29147.524512.24317.09124.28150.98134.05307.7136.43173.79244.94222.62243.83374.32218.75267.05197.79351.23281.28241.4219.33321.98190.84206.514512.24
Avg26.1624.6552.4334.2426.1125.6523.523.4926.7229.0150.7663.7565.0765.3965.9167.0965.271.2469.3467.1366.6165.5863.2763.2950.07

SQL Buffer Cache Hit Ratio

Counter000102030405060708091011121314151617181920212223Total
Min97.7799.4598.9699.9899.9699.8899.9399.9599.9299.9599.9399.9299.8699.9699.9199.9199.9499.9299.999.9499.9299.9199.9399.7497.77
Max100100100100100100100100100100100100100100100100100100100100100100100100100
Avg99.9910099.99100100100100100100100100100100100100100100100100100100100100100100

SQL Cache Memory (MB)

Counter000102030405060708091011121314151617181920212223Total
Min32.5232.5232.3832.4332.532.2332.2332.2332.5632.232.232.2832.2332.1432.1432.1632.1632.1832.1932.1932.1932.1932.229.8129.81
Max32.5232.5232.4332.532.5232.5232.2332.5632.5732.5932.2832.2932.3432.2632.1632.1632.1832.1932.1932.1932.232.232.232.2932.59
Avg32.5232.5232.3832.4732.5132.3832.2332.432.5732.4132.2632.2932.2832.2532.1632.1632.1732.1932.1932.1932.1932.1932.231.8632.29

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
Max221042522222322233222242210
Avg0.040.010.310.280.060.060.040.040.040.070.040.020.050.050.040.070.030.040.030.030.050.050.020.050.06

SQL DeadLocks/sec

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max0.10.20.10.40.10.20.20.10.20.10.20.10.10.20.10.10.10.10.10.10.10.10.10.10.4
Avg0000.01000000.01000000000000000

SQL Locks Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max1779293348070.3315294633453928863322.6730274586438443994789449343064306380735572652319833383021.331232.33482048070.33
Avg49.7860.9214.6676.96109.0475.1454.9164.1562.33141.6782.758.4192.3885.3597.8111.9584.3394.0473.0168.0389.8669.435.6688.9585.06

SQL Latches Avg Wait (ms)

Counter000102030405060708091011121314151617181920212223Total
Min0000000000000000000000000
Max5.954.514.63.415.335.024.426.075.265.275.15.247.965.54.95.045.545.025.974.877.463.944.874.827.96
Avg1.120.910.850.590.710.760.760.840.761.211.131.091.161.21.0510.920.910.90.850.760.720.760.840.91