REPORTSQL01 Main Reporting DB 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 % Usage10010010010010099.91100100
Avg Processor % Usage39.0737.7531.4831.0229.9419.9436.0532.18

Available Memory Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Available Memory (MB)6131.047700.3910788.486769.656937.4711851.147220.466131.04
Max Available Memory (MB)13811.3613988.6814511.19191406.0315572.1614934.5913919.82191406.03
Avg Available Memory (MB)11894.8611252.2112433.8118607.4713683.9313160.5912688.3213388.74

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)212511.94212543.18212002.8829130.75211021.96211427.42212163.5729130.75
Max Working Set (MB)220700.83219169.11215763.7216334.46213522.78214340.65219450.29220700.83
Avg Working Set (MB)214580215072.74214090.24206952.73212799.97213059.51213651.35212886.65

Cache Bytes Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Cache Bytes (MB)452.67459.88465.58242.35366.07376.01400.98242.35
Max Cache Bytes (MB)682.75714.79791.25823.644645.9629.93691.444645.9
Avg Cache Bytes (MB)514.01522.61520.92493.06425.09427.82439.98477.64

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)149.74152.34152.1692.66112.75126.14144.2692.66
Max Non-Paged Pool Bytes (MB)262.24248.59255.38267.29296.4289.99211.32296.4
Avg Non-Paged Pool Bytes (MB)154.72156.21156.37153.59129.54144.76152.34149.65

% 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 Usage20.3122.1321.5118.3911.8317.1412.9622.13
Avg Priv CPU Usage4.223.963.33.052.732.082.573.13

% 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.1102.1299.399.15101.9599.4299.44102.12
Avg User CPU Usage34.8433.7928.1727.9627.217.8633.4729.04

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 Length3436182219122036
Avg Processor Queue Length0.490.620.360.380.320.180.410.39

% Page File Usage Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min PageFile % Usage0.120.120.12000.020.030
Max PageFile % Usage0.190.20.20.180.070.090.10.2
Avg PageFile % Usage0.140.140.140.130.030.040.050.1

Pages/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Pages/sec00000000
Max Pages/sec76047.3578829.7979307.8877573.2372711.0978892.4677026.2979307.88
Avg Pages/sec1887.311909.012269.181923.561961.441867.441902.781960.1

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/sec4160.684259.454273.054199.933939.954319.844186.434319.84
Avg Page Reads/sec77.877.8696.7779.278.575.6477.0280.4

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/sec11111111
Avg Page Writes/sec0.010.010.010.010.010.010.010.01

Disk Percent Usage

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 200GB21.921.821.721.921.721.721.7
F - 2038GB88.788.788.888.890.488.989
L - 1024GB17.117.117.117.117.117.117.1
T - 700GB24.124.124.124.124.124.124.1
U - 500GB87.886.586.586.786.786.387.3

Used Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 200GB43.743.743.443.843.443.443.5
F - 2038GB1807.21807.81808.71808.81841.91812.11814
L - 1024GB175.3175.3175.3175.3175.3175.3175.3
T - 700GB168.8168.8168.8168.8168.8168.8168.8
U - 500GB438.9432.4432.4433.3433.3431.3436.4

Free Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 200GB156.3156.3156.6156.2156.6156.6156.5
F - 2038GB230.5229.8229228.9195.7225.5223.6
L - 1024GB848.6848.6848.6848.6848.5848.5848.5
T - 700GB531.1531.1531.1531.1531.1531.1531.1
U - 500GB60.967.567.466.666.668.663.5

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 Latency6250.766851.414521.994240.889499.212803.513396.689499.21
Avg Disk Write Latency25.9828.213027.5325.6111.8329.925.58

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 Latency271.73260.66251346.68249.6233.25289.39346.68
Avg Disk Read Latency6.076.716.547.565.564.686.826.28

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/Os1966.752010.782161.481978.092403.192009.592102.982403.19
Avg Disk Split I/Os11.6910.9311.1511.0112.999.411.1511.19

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 Length474495434484450404404495
Avg Current Disk Queue Length14.2413.9113.412.9610.536.9115.0412.43

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 Length26172.6616189.1916563.814092.2118842.867906.4716894.9626172.66
Avg Avgerage Disk Queue Length7068.1571.6169.0157.525.3281.963.36

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/sec763.74768.97769.98755.23756.36767.76761.08769.98
Avg Disk Read Mb/sec125.26119.71118.61118.65115.1790.34124.81116.08

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/sec621.94684.61708.48674.62653.43657.72677.94708.48
Avg Disk Write Mb/sec36.8333.131.5329.8927.7124.6135.8531.36

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/sec155.22160.23164.76203199.26174.08172.79203
Avg Net Received Mb/sec1.960.440.440.420.40.370.460.64

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/sec446.32417.48410.99381.61378.17413.25395.12446.32
Avg Net Sent Mb/sec36.9437.4138.5637.0536.6236.4136.9437.13

SQL User Connections

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL User Connections7370703538364035
Max SQL User Connections293335289311229212304335
Avg SQL User Connections114.84121.57106.92102.8858.2557.3388.4192.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/sec774.15937.45770.11947.97413.16852.18882.21947.97
Avg SQL Compilations/sec10.449.79.3511.396.044.999.398.76

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/sec16.8113.7923.614.416.829.914.4923.6
Avg SQL Re-Compilations/sec0.280.260.250.210.080.070.30.21

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/sec19044.6611855.6214060.6813546.9813896.1215004.0125763.7825763.78
Avg SQL Batch Req/sec563.85421.35394.54420.15141.48177.78737.64408.11

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 Flushes2078.792038.591864.381918.381042.9410502060.12078.79
Avg SQL Log Flushes156.83171.66156.64140.4685.2279.63142.6133.29

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 Writes5916.985677.0410091.326976.715597.418261.92710310091.32
Avg SQL Lazy Writes166.41131.22145.56124.0578.748.77173.87124.08

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 Splits24110.6727986.5922295.7528799.3422362.0322403.422548.2928799.34
Avg SQL Page Splits167.72195.65150.05166.69131.42121.64155.78155.56

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 Ratio28.9870.4752.2851.7648.7273.6554.6328.98
Max SQL Buffer Cache Hit Ratio100100100100100100100100
Avg SQL Buffer Cache Hit Ratio99.8399.8499.8199.8299.7599.8499.8199.81

SQL Cache Memory (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Cache Memory217.27206.44210.9610.663.66260.15265.653.66
Max SQL Cache Memory361.98310.27251.38236260.15381.98392.01392.01
Avg SQL Cache Memory283.08247.84235.31181.96208.4366.75327.76264.44

SQL Total Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Total Mem203.5203.47203.4726.47203.53203.53203.6826.47
Max SQL Total Mem206.23206.52205.98206.68205.71206.07205.5206.68
Avg SQL Total Mem205.06205.03205.06197.75205.06205.05205.08204.01

SQL Target Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Target Mem205.08205.08205.08200.98205.08205.08205.08200.98
Max SQL Target Mem205.08205.08205.08205.08205.08205.08205.08205.08
Avg SQL Target Mem205.08205.08205.08204.94205.08205.08205.08205.06

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 Blocked1110518221218
Avg SQL Processes Blocked0.490.290.080.20.020.050.260.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/sec00.20.10000.10.2
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 Wait164877771045566901451871079337056130995656633016487777
Avg SQL Locks Avg Wait2992.56902.8485.72589.57188.08467.1842.72924.08

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 Wait84.68506.67517.65262.83361.2129.64308.42517.65
Avg SQL Latches Avg Wait2.42.862.382.652.591.452.562.41