SHAREPOINTSQL01 SharePoint SQL Server

Weekly Stats from: 04/19/2019 - 04/25/2019

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Processor % Usage00000000
Max Processor % Usage100100100100100100100100
Avg Processor % Usage31.0635.0530.929.7520.3622.3134.5129.13

Available Memory Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Available Memory (MB)460.92481.62809.072598.22867.42491.886043.53460.92
Max Available Memory (MB)1714.4324918.384765.954114.3611368.6828236.468021.1928236.46
Avg Available Memory (MB)746.53602.0340293717.9210489.884866.567231.834954.82

Working Set (Used Memory) Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Working Set (MB)37222.1438118.2952535.0252698.8152580.6334144.3752827.8934144.37
Max Working Set (MB)39284.7453630.8253475.7953452.5353678.4253491.2653695.9453695.94
Avg Working Set (MB)38549.1645235.0153008.1353023.9352937.3448797.2853276.7849261.09

Cache Bytes Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Cache Bytes (MB)24341.570.936350.197097.830.14609.622821.080.14
Max Cache Bytes (MB)25713.4724946.487826.888157.188074.4427861.484416.7627861.48
Avg Cache Bytes (MB)24827.8715115.916937.587419.95702.919833.383499.729762.47

Pool Non-Paged Bytes Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Non-Paged Pool Bytes (MB)124.21124.13134.03127.19127.07138.03145.43124.13
Max Non-Paged Pool Bytes (MB)172.16377.33331.43145.41151.01511.52226.73511.52
Avg Non-Paged Pool Bytes (MB)125.25156.89166.29129.82128.48237.96165.04158.53

% CPU Privileged Time Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Priv CPU Usage00000000
Max Priv CPU Usage22.5120.2416.3917.718.1820.8419.9322.51
Avg Priv CPU Usage3.293.893.233.022.063.513.383.2

% CPU User Time Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min User CPU Usage00000000
Max User CPU Usage99.1499.2898.8299.21101.398.7199.12101.3
Avg User CPU Usage27.7631.1627.6626.7318.318.7931.1225.93

Processor Queue Length Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Processor Queue Length00000000
Max Processor Queue Length2038211818243939
Avg Processor Queue Length0.420.380.450.430.370.340.420.4

% Page File Usage Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min PageFile % Usage1.731.71.691.631.521.141.121.12
Max PageFile % Usage4.843.762.091.871.841.741.354.84
Avg PageFile % Usage2.352.141.851.781.661.421.231.78

Pages/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Pages/sec00000000
Max Pages/sec34841.7730253.4316036.3612720.7311162.2913582.811373.8534841.77
Avg Pages/sec1434.341149.06933.62784.44188.36396.981154.63863.06

Page Reads/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Page Reads/sec00000000
Max Page Reads/sec1695.311867.421511.811426.861471.491575.221533.121867.42
Avg Page Reads/sec141.22146.13111.1778.2918.95235.28111.02120.29

Page Writes/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Page Writes/sec00000000
Max Page Writes/sec128.9899.2911.1115.491128.98
Avg Page Writes/sec0.110.080.020.020.030.030.020.04

Disk Percent Usage

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 200GB55.455.355.355.355.355.355.2
F - 1792GB91.891.991.991.991.992.192.1
L - 250GB616161616163.263.2
T - 100GB61.461.461.461.461.461.461.4
U - 750GB93.392.892.5929189.787.8
X - 32768GB86.886.886.886.886.886.886.8
Z - 65536GB48.94949.249.349.349.449.5

Used Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 200GB110.8110.6110.6110.6110.6110.5110.4
F - 1792GB1645.916461646.21646.31646.616511650.6
L - 250GB152.3152.3152.3152.3152.3157.8157.8
T - 100GB61.361.361.361.361.361.361.3
U - 750GB699.8696.2693.4689.5682.4672.4658.7
X - 32768GB28450.228450.228450.228450.228450.228450.228450.2
Z - 65536GB32019.932129.732221.632304.832332.132354.532445.8

Free Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 200GB89.289.389.389.389.389.489.4
F - 1792GB146145.9145.7145.6145.3140.8141.3
L - 250GB97.697.697.697.697.69292
T - 100GB38.538.538.538.538.538.538.5
U - 750GB50.153.756.460.367.577.591.2
X - 32768GB4317.74317.74317.74317.74317.74317.74317.7
Z - 65536GB3351633406.133314.333231.133203.833181.433090.1

Disk Write Latency (milliseconds)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Disk Write Latency00000000
Max Disk Write Latency25.0925.1224.9428.9319.830.3210.9530.32
Avg Disk Write Latency0.941.11.041.030.910.990.961

Disk Read Latency (milliseconds)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Disk Read Latency00000000
Max Disk Read Latency45.6219.334.2948.55225.3107.71181.57225.3
Avg Disk Read Latency2.072.252.482.081.683.842.612.43

Disk Split IO per second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Disk Split I/Os00000000
Max Disk Split I/Os481.72463.75421.63607.08614.57721.45432.54721.45
Avg Disk Split I/Os5.375.394.74.453.123.814.954.54

Current Disk Queue Length Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Current Disk Queue Length00000000
Max Current Disk Queue Length18090231171159242175242
Avg Current Disk Queue Length1.631.691.531.230.662.321.571.52

Average Disk Queue Length Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Avgerage Disk Queue Length00000000
Max Avgerage Disk Queue Length183.5225.62174.09128.8593290.85175.53593
Avg Avgerage Disk Queue Length1.811.821.541.290.822.471.71.64

Disk Read Throughput (Mb/sec) Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Disk Read Mb/sec00000000
Max Disk Read Mb/sec812.82807.47856.76821.48831635.39600.29856.76
Avg Disk Read Mb/sec38.5556.0941.6741.2836.5954.541.744.34

Disk Write Throughput (Mb/sec) Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Disk Write Mb/sec00000000
Max Disk Write Mb/sec338.43354.8345.82339.28350.02536.47369.19536.47
Avg Disk Write Mb/sec17.7218.7116.1716.5512.0416.0515.4116.09

Total Net Received Throughput (Mb/sec) Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Net Received Mb/sec00000000
Max Net Received Mb/sec80.8260.8764.7451.5929.5253.3446.1480.82
Avg Net Received Mb/sec3.793.262.662.270.60.963.342.41

Total Net Sent Throughput (Mb/sec) Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Net Sent Mb/sec00000000
Max Net Sent Mb/sec183.57304.6316.64295.83326.5313.06308.62326.5
Avg Net Sent Mb/sec13.5421.2214.99139.449.4617.1314.11

SQL User Connections

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL User Connections182181162153144139176139
Max SQL User Connections714766675689608579718766
Avg SQL User Connections476.44475.78465.65456.64410.34416.56482.82454.89

SQL Compilations/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Compilations/sec00000000
Max SQL Compilations/sec155.89229.4294.48149.43131.14216161.69229.42
Avg SQL Compilations/sec9.38.816.566.523.214.7711.837.29

SQL Re-Compilations/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Re-Compilations/sec00000000
Max SQL Re-Compilations/sec20.0130.6138.319.6922.4134.7212.3138.31
Avg SQL Re-Compilations/sec0.40.360.320.260.120.220.350.29

SQL Batch Req/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Batch Req/sec00000000
Max SQL Batch Req/sec3128.783170.052778.221988.31615.231187.332908.383170.05
Avg SQL Batch Req/sec467.65466.68448.07415.24258.1250.75690.56428.15

Log Flushes/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Log Flushes00000000
Max SQL Log Flushes609.02467.79555.1471.311147.16963.74462.861147.16
Avg SQL Log Flushes60.7462.1152.1446.9434.735.1463.350.72

Lazy Writes/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Lazy Writes00000000
Max SQL Lazy Writes277.27777.73455.04353.5171.65928.24254.21928.24
Avg SQL Lazy Writes0.973.181.131.070.440.830.561.17

Page Splits/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Page Splits00000000
Max SQL Page Splits2787.013601.934265.073008.753645.562828.45758.384265.07
Avg SQL Page Splits32.2865.3280.5134.3365.7721.4725.7946.5

SQL Buffer Cache Hit Ratio

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Buffer Cache Hit Ratio53.4653.1757.0570.3381.8766.3676.2353.17
Max SQL Buffer Cache Hit Ratio100100100100100100100100
Avg SQL Buffer Cache Hit Ratio99.8299.8199.8399.8499.7599.7199.8499.8

SQL Cache Memory (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Cache Memory3.692.32171.61161.81168.351.98146.11.98
Max SQL Cache Memory182.52215.51232.05227.95205.17201241.19241.19
Avg SQL Cache Memory128.93147.89204.32202.91182.81155.76197.36174.28

SQL Total Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Total Mem33.3734.0348.8348.8348.8330.0348.8330.03
Max SQL Total Mem35.8148.8348.8348.8348.8348.8348.8348.83
Avg SQL Total Mem34.9541.3448.8348.8348.8344.6548.8345.18

SQL Target Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Target Mem33.3934.0348.8348.8348.8330.0348.8330.03
Max SQL Target Mem35.9648.8348.8348.8348.8348.8348.8348.83
Avg SQL Target Mem34.9741.448.8348.8348.8345.5748.8345.32

SQL Processes Blocked

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Processes Blocked00000000
Max SQL Processes Blocked7811367263610451113
Avg SQL Processes Blocked0.170.20.110.10.020.680.110.2

SQL DeadLocks/sec

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL DeadLocks/sec00000000
Max SQL DeadLocks/sec0.60.20.20.20.20.30.30.6
Avg SQL DeadLocks/sec00000000

SQL Locks Avg Wait (ms)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Locks Avg Wait00000000
Max SQL Locks Avg Wait27116721016221497261102402191182352557.3318201262711672
Avg SQL Locks Avg Wait551.08425.14200.07281.6850.14241.77345.68299.37

SQL Latches Avg Wait (ms)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Latches Avg Wait00000000
Max SQL Latches Avg Wait31.1255.4255.1532.4573.7353.4522.7273.73
Avg SQL Latches Avg Wait11.111.060.990.921.021.01