WEBAPPASQL01 Backend 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 % Usage84.2540.5856.9490.6535.3782.9356.9990.65
Avg Processor % Usage3.953.33.25.462.343.243.623.59

Available Memory Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Available Memory (MB)5872.045903.495942.315908.8942203.75470.035996.695470.03
Max Available Memory (MB)6572.056545.926566.8261855.3448956.5742470.016613.5361855.34
Avg Available Memory (MB)6382.76370.316369.3923488.5444753.429862.666457.6714812.1

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)57069.3957055.0557081.652336.6614823.6421093.4356987.312336.66
Max Working Set (MB)57814.1257834.7957798.1457947.821478.8758193.157702.4858193.1
Avg Working Set (MB)57291.5157310.0357305.5840279.918955.9353820.6157238.9548886.07

Cache Bytes Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Cache Bytes (MB)365.65353.83343.46354.81368.76354.95356.23343.46
Max Cache Bytes (MB)435.57438.54434.91964.04436.24437.6436.6964.04
Avg Cache Bytes (MB)383.12384.45381.57387.49387.35386.54383.39384.84

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)144.73146.66148.57150.58153.09154.91157.3144.73
Max Non-Paged Pool Bytes (MB)148.27149.23151.2154.36155.45157.84160.01160.01
Avg Non-Paged Pool Bytes (MB)145.79147.65149.63151.87154156.36158.29151.94

% 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 Usage14.5210.714.1426.1516.9913.9816.4326.15
Avg Priv CPU Usage0.510.520.520.710.60.490.540.56

% 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 Usage83.5139.7937.6387.3831.5281.8755.0987.38
Avg User CPU Usage3.442.782.674.751.742.753.083.03

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 Length1715121415171317
Avg Processor Queue Length0.40.330.370.410.470.390.340.39

% Page File Usage Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min PageFile % Usage0.670.620.780.650.910.910.960.62
Max PageFile % Usage3.133.273.773.362.883.593.743.77
Avg PageFile % Usage1.762.612.752.61.182.752.992.38

Pages/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Pages/sec00000000
Max Pages/sec5286.034648.214927.0388502.913541.694911.225231.3688502.91
Avg Pages/sec7.486.756.78218.193.887.367.9736.92

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/sec84.8922.686.28318.05415.39403.6443.39415.39
Avg Page Reads/sec0.160.150.151.020.20.210.160.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/sec308.21224.58308.32234.890189.62350.77350.77
Avg Page Writes/sec0.20.170.190.0900.130.270.15

Disk Percent Usage

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 50GB63.963.963.963.963.963.963.9
F - 300GB69696969696969
L - 200GB52525252525252
T - 100GB83.183.183.183.183.183.183.1
U - 150GB78.9797979.162.462.462.4

Used Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 50GB31.731.731.731.731.731.731.7
F - 300GB207.1207.1207.1207.1207.1207.1207.1
L - 200GB104.1104.1104.1104.1104.1104.1104.1
T - 100GB83.183.183.183.183.183.183.1
U - 150GB118.4118.5118.6118.793.693.693.6

Free Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 50GB17.917.917.917.917.917.917.9
F - 300GB92.992.992.992.992.992.992.9
L - 200GB95.995.995.995.995.995.995.9
T - 100GB16.916.916.916.916.916.916.9
U - 150GB31.631.531.431.356.456.456.4

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 Latency106.27170.85138.7116.5221.170.88512.17512.17
Avg Disk Write Latency1.552.442.22.041.391.952.412

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 Latency187.9551.1957.0627.0638.49123.0637.12187.95
Avg Disk Read Latency0.660.910.860.760.560.881.010.81

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/Os35.4936.6929.339.7933.1929.8932.2939.79
Avg Disk Split I/Os0.890.880.880.980.860.870.870.89

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 Length217144842128173142217
Avg Current Disk Queue Length0.060.070.060.120.020.370.090.11

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 Length284.8436.9122.29135.4413.18542.25220.92542.25
Avg Avgerage Disk Queue Length0.120.10.080.220.030.450.140.16

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/sec386.51373.34308.81412.76366.41424.6312.55424.6
Avg Disk Read Mb/sec1.741.721.653.591.593.861.822.28

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/sec170.27174.06173.75278.34195.75238.75136.9278.34
Avg Disk Write Mb/sec0.670.640.592.030.441.970.631

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/sec7.453.24.29116.150.560.710.92116.15
Avg Net Received Mb/sec0.050.040.040.840.020.020.050.15

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/sec218.94154.12133.97346.36144.71249.86149.44346.36
Avg Net Sent Mb/sec1.71.631.633.091.362.551.831.97

SQL User Connections

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL User Connections36373924142362
Max SQL User Connections1011071681187577106168
Avg SQL User Connections45.0644.3747.4943.4244.6244.4948.745.45

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/sec90.0957.0980.96571.5530.9941.9966.19571.55
Avg SQL Compilations/sec2.892.962.523.070.350.613.32.24

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/sec6.615.96.3126.293.43.45.826.29
Avg SQL Re-Compilations/sec0.270.30.230.240.040.070.330.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/sec576.88592.85499.97722.24292.57367.04686.32722.24
Avg SQL Batch Req/sec32.4228.3928.1424.784.034.8634.4322.44

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 Flushes265.31101.57293.83383.59585.551234.237.991234.2
Avg SQL Log Flushes1.741.491.952.421.3121.111.594.52

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 Writes000319.820407.70407.7
Avg SQL Lazy Writes0000.3600.2900.09

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 Splits532.28736.31121.37710.1295.862583.93615.532583.93
Avg SQL Page Splits11.864.553.764.90.3928.594.628.38

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 Ratio77.7890.9191.1979.7950.4679.5579.0850.46
Max SQL Buffer Cache Hit Ratio100100100100100100100100
Avg SQL Buffer Cache Hit Ratio99.9999.9910099.9899.9999.9999.9799.99

SQL Cache Memory (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Cache Memory65.7766.3577.331.5513.41.7811.051.55
Max SQL Cache Memory78.0578.3687.3688.7918.7518.9971.188.79
Avg SQL Cache Memory68.572.3683.1456.2816.047.0544.9949.77

SQL Total Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Total Mem54.6854.6754.670.513.4319.4154.680.5
Max SQL Total Mem54.6954.6954.6954.7119.4155.3154.6955.31
Avg SQL Total Mem54.6954.6954.6837.9717.2451.3254.6946.47

SQL Target Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Target Mem54.6954.6954.6954.6954.6954.6954.6954.69
Max SQL Target Mem54.6954.6954.6954.6954.6954.6954.6954.69
Avg SQL Target Mem54.6954.6954.6954.6954.6954.6954.6954.69

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 Blocked11000101
Avg SQL Processes Blocked00000000

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/sec00000000
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 Wait6469501515448520.721207825012078
Avg SQL Locks Avg Wait1.830.600.8901.790.030.73

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 Wait10.2598.5226.1713.2515.7581.8521.1798.52
Avg SQL Latches Avg Wait0.090.090.070.160.040.190.180.12