WEBAPPBSQL01 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 % Usage99.3699.0499.4410010099.9899.22100
Avg Processor % Usage40.2839.8339.8737.7335.6634.6434.6637.52

Available Memory Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Available Memory (MB)7704.797934.488005.527859.117966.538114.188162.287704.79
Max Available Memory (MB)9966.3610155.159980.7210121.0510004.999988.6610184.0810184.08
Avg Available Memory (MB)9107.39104.579203.759159.89181.069211.879294.829180.45

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)85268.8585314.4485320.5785302.5885314.1885345.6885159.5985159.59
Max Working Set (MB)87090.1787026.5486877.6487461.3987496.5587113.2387094.9387496.55
Avg Working Set (MB)85792.4785819.5885820.1685900.8185876.5385877.5285782.1985838.47

Cache Bytes Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Cache Bytes (MB)1203.57961.961071.53953.73989.11970.34988.62953.73
Max Cache Bytes (MB)1653.051474.621315.831341.971328.011301.281322.611653.05
Avg Cache Bytes (MB)1308.231253.681186.061129.041136.771103.161116.061176.14

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)683.97682.85682.83682.68683.06683.25683.51682.68
Max Non-Paged Pool Bytes (MB)827.52732.94735.59735.771270.51956.67733.371270.51
Avg Non-Paged Pool Bytes (MB)684.67684.04683.46683.48684.38684.36684.5684.13

% 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 Usage51.9257.6351.8439.6744.5251.8161.3961.39
Avg Priv CPU Usage14.9314.2815.0811.2210.3815.8510.7513.21

% 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 Usage90.2385.9591.0595.6498.0189.0892.6198.01
Avg User CPU Usage25.3625.5624.7926.5125.2918.7923.9224.32

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 Length3228273531302435
Avg Processor Queue Length0.680.660.690.930.850.70.610.73

% Page File Usage Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min PageFile % Usage1.581.581.581.581.581.581.581.58
Max PageFile % Usage2.611.581.581.581.581.581.582.61
Avg PageFile % Usage1.861.581.581.581.581.581.581.62

Pages/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Pages/sec00000000
Max Pages/sec7017.445324.684260.936422.093573.414816.913796.737017.44
Avg Pages/sec38.0242.4142.9551.8145.0147.3640.2443.97

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/sec645.76902.151438.631736.7756.6415191616.811736.7
Avg Page Reads/sec1.582.512.293.882.383.42.412.64

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/sec10000001
Avg Page Writes/sec00000000

Disk Percent Usage

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 50GB77.376.876.976.976.976.876.9
F - 1800GB81.281.281.281.381.681.581.5
G - 2052GB79.879.879.579.579.879.579.5
L - 450GB27.927.828.127.838.82928.1
Q - 1GB5.35.45.45.45.45.45.4
T - 201GB3.43.41.91.93.31.92.3
U - 1536GB78.878.97979.17579.179.2

Used Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 50GB38.738.438.438.438.438.438.4
F - 1800GB1460.51461.51460.51462.51469.61466.71466.7
G - 2052GB1636.51636.51630.61630.61636.51630.61630.6
L - 450GB125.6125.1126.6125.2174.5130.6126.5
Q - 1GB00.10.10.10.10.10.1
T - 201GB6.86.83.83.86.73.74.7
U - 1536GB1210.31211.61213.31214.91151.91214.61215.9

Free Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 50GB11.311.611.611.611.611.611.6
F - 1800GB339.4338.4339.3337.4330.3333.2333.2
G - 2052GB415.4415.4421.2421.2415.4421.2421.2
L - 450GB324.2324.8323.3324.7275.4319.2323.4
Q - 1GB0.90.90.90.90.90.90.9
T - 201GB194.1194.1197.1197.1194.2197.1196.2
U - 1536GB325.5324.2322.6320.9384321.3320

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 Latency4552.542484.992421.773596.213016.292317.352692.624552.54
Avg Disk Write Latency44.3946.1344.5549.9346.0957.3155.1549.08

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 Latency265.07137.71152.8699.08567.59126.59192.95567.59
Avg Disk Read Latency5.75.535.985.258.745.675.576.06

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/Os91.29107.3283.48273.3871.4244.49243.26283.48
Avg Disk Split I/Os2.122.332.372.812.432.372.342.4

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 Length252258261259263256263263
Avg Current Disk Queue Length3.924.394.414.425.784.394.524.55

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 Length2781.531411.61764.242566.022198.852019.542954.242954.24
Avg Avgerage Disk Queue Length32.9131.5631.0735.8337.7143.0443.3236.49

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/sec627.15643.07666.16845.97706.27627.88719.8845.97
Avg Disk Read Mb/sec43.3143.2943.5552.2457.2944.4543.3446.78

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/sec227.55264.96292.18286.81584.58220.88210.88584.58
Avg Disk Write Mb/sec25.2224.9525.0925.241.0924.9925.5927.45

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.725.85.57.832.136.275.277.83
Avg Net Received Mb/sec0.020.010.020.020.010.010.010.01

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/sec115.43151.47118.29103.21183.43141.44139.32183.43
Avg Net Sent Mb/sec0.240.240.240.460.340.250.270.29

SQL User Connections

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL User Connections93.8390.8892.3589.5873.6572.6292.2172.62
Max SQL User Connections311.46308.88312.09307.12286.22289.58308.12312.09
Avg SQL User Connections93.8390.8892.3589.5873.6572.6292.2186.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/sec47.5347.4645.6245.8242.341.8548.9548.95
Avg SQL Compilations/sec10.23108.998.283.52.910.177.72

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/sec15.7515.3714.313.749.168.3115.7415.75
Avg SQL Re-Compilations/sec8.718.537.556.912.391.968.686.39

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/sec1697.4311061530.361398.32397.011020.1912291697.43
Avg SQL Batch Req/sec160.3145.18154.59141.3374.5677.25159.92130.45

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 Flushes187.62129.45153.21140.03470.01175.92200.06470.01
Avg SQL Log Flushes13.2611.4713.2311.0651.2414.614.518.48

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 Writes0.760.9411.270.4432.070.324.2932.07
Avg SQL Lazy Writes00.010.200.3500.040.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 Splits190.81467.77476.06459.13167.31175.93349.86476.06
Avg SQL Page Splits34.7735.6234.8335.9534.1932.2635.134.67

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 Ratio99.599.8596.8898.1898.1795.8397.0495.83
Max SQL Buffer Cache Hit Ratio100100100100100100100100
Avg SQL Buffer Cache Hit Ratio99.599.8596.8898.1898.1795.8397.0497.92

SQL Cache Memory (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Cache Memory51.7668.8484.3464.0260.7460.6261.8251.76
Max SQL Cache Memory52.3769.5185.664.6160.7960.6261.9685.6
Avg SQL Cache Memory52.0569.1684.8964.1960.7660.6261.8764.79

SQL Total Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Total Mem73.2473.2473.2473.2473.2473.2473.2473.24
Max SQL Total Mem73.2473.2473.2473.2473.2473.2473.2473.24
Avg SQL Total Mem73.2473.2473.2473.2473.2473.2473.2473.24

SQL Target Memory (GB)

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

SQL Processes Blocked

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Processes Blocked0.040.080.040.040.130.080.080.04
Max SQL Processes Blocked3.290.331.481.121.960.171.123.29
Avg SQL Processes Blocked0.040.080.040.040.130.080.080.07

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/sec1.4200.240.21000.261.42
Avg SQL DeadLocks/sec0.040000000.01

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 Wait333618.45385789.98343270.18301463.34635518.9761194.1647382.53635518.97
Avg SQL Locks Avg Wait1060.971215.41068.76930.682074.76191.1149.8955.92

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 Wait1086.22588.551006.87533.79284.191165.761239.321239.32
Avg SQL Latches Avg Wait5.623.634.983.873.345.896.074.77