REPORTSQL02 SSRS Database 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 % Usage71.3853.0256.8554.1548.2652.4497.1297.12
Avg Processor % Usage4.063.923.713.953.43.895.044

Available Memory Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Available Memory (MB)749.651092.491081.451068.451099.99456.82609.36456.82
Max Available Memory (MB)1615.191730.921809.81801.231894.568404.797748.528404.79
Avg Available Memory (MB)1363.891481.2315341555.331623.25067.265491.912588.12

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)13829.913746.6313652.713659.213593.897074.287775.347074.28
Max Working Set (MB)14873.7514543.2114518.8914541.8414467.7315020.5410836.6115020.54
Avg Working Set (MB)14168.6914065.7514010.4313986.8713927.9810401.629853.4812916.4

Cache Bytes Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Cache Bytes (MB)341.12319.05327.72333.14329.38328.57313.68313.68
Max Cache Bytes (MB)407.32395.38446.78443.14450.49413.62435.93450.49
Avg Cache Bytes (MB)369.71355.63356.7360.93360.41357.26366360.95

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)86.986.8886.8886.7586.7786.386.1686.16
Max Non-Paged Pool Bytes (MB)93.1992.0396.9187.9587.55104.05100.91104.05
Avg Non-Paged Pool Bytes (MB)90.2188.9790.0186.9186.8786.786.788.05

% 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 Usage21.223.272323.1624.0129.9147.3947.39
Avg Priv CPU Usage1.411.431.321.431.221.5621.48

% 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 Usage55.5643.4643.274140.2641.3559.3859.38
Avg User CPU Usage2.652.492.392.522.182.323.032.51

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 Length1316132724261527
Avg Processor Queue Length0.020.020.030.030.020.040.030.03

% Page File Usage Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min PageFile % Usage26.631.3631.0434.7134.49.567.617.61
Max PageFile % Usage42.6647.7752.7153.2857.5257.6734.357.67
Avg PageFile % Usage32.8539.1741.8345.3346.3925.3618.435.62

Pages/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Pages/sec00000000
Max Pages/sec8860.338573.1924360.769236.9122372.069468.89546.6224360.76
Avg Pages/sec26.9325.1626.9426.1325.4517.5315.4623.37

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/sec288.49312.421351.56220.31218.01844.651101.121351.56
Avg Page Reads/sec1.190.981.041.140.971.951.961.32

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/sec409.71432.44464.98439.18430.69463.66518.37518.37
Avg Page Writes/sec1.181.141.131.171.240.550.330.96

Disk Percent Usage

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 100GB30.530.530.530.530.530.630.6
F - 20GB62.762.762.762.762.762.762.7
L - 80GB58.658.658.658.658.658.658.6
T - 10GB3333333
U - 10GB10.712.59.8109.99.29.1

Used Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 100GB30.430.430.430.430.430.430.5
F - 20GB12.512.512.512.512.512.512.5
L - 80GB46.946.946.946.946.946.946.9
T - 10GB0.30.30.30.30.30.30.3
U - 10GB1.11.21110.90.9

Free Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 100GB69.269.269.269.269.269.269.2
F - 20GB7.47.47.47.47.47.47.4
L - 80GB33.133.133.133.133.133.133.1
T - 10GB9.79.79.79.79.79.79.7
U - 10GB8.98.799999.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 Latency97.6553.2526.4443.111193.4493.564.671193.44
Avg Disk Write Latency1.61.521.511.51.461.611.81.57

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 Latency80.5650.0763.1534.5652.5689.171.5889.1
Avg Disk Read Latency0.940.940.90.980.940.831.070.94

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/Os112.3573.3845.7933.5972.372.0874.38112.35
Avg Disk Split I/Os1.271.271.211.291.261.271.281.26

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 Length10877179128821158179
Avg Current Disk Queue Length0.060.050.070.070.020.020.080.05

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 Length5.715.3811.536.586.115.926.911.53
Avg Avgerage Disk Queue Length0.060.050.050.040.020.020.060.04

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/sec98.5883.4695.16122.1287.3964.0183.82122.12
Avg Disk Read Mb/sec0.120.090.110.130.110.120.080.11

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/sec34.6833.5151.4636.1638.6337.0937.6351.46
Avg Disk Write Mb/sec0.450.370.420.340.20.150.440.34

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/sec4.673.514.762.31.030.85.465.46
Avg Net Received Mb/sec0.140.110.120.080.020.020.170.09

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/sec99.284.5795.4967.3987.749.7985.0499.2
Avg Net Sent Mb/sec0.70.550.540.390.160.130.70.45

SQL User Connections

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL User Connections10121111911119
Max SQL User Connections1731781171498783199199
Avg SQL User Connections39.9939.7634.636.3623.3223.0153.4235.78

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/sec8.624.2913.615.26.8142.8944.6844.68
Avg SQL Compilations/sec0.090.090.080.090.060.120.180.1

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/sec2.42.93.32.631.86.36.3
Avg SQL Re-Compilations/sec0.020.020.020.020.010.010.020.02

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/sec469.88754.5713.61787.99305.02192.15421.32787.99
Avg SQL Batch Req/sec39.1631.3431.6124.877.366.341.8326.07

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 Flushes211.15115.14216.94162.56171.74111.37127.37216.94
Avg SQL Log Flushes5.514.234.633.291.010.936.23.69

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 Writes000002.3102.31
Avg SQL Lazy Writes00000000

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 Splits172.66122.37198.75104.87187.8583.01163.84198.75
Avg SQL Page Splits3.622.734.472.861.010.523.622.69

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 Ratio98.5199.6899.0497.9295.7996.2297.7995.79
Max SQL Buffer Cache Hit Ratio100100100100100100100100
Avg SQL Buffer Cache Hit Ratio100100100100100100100100

SQL Cache Memory (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Cache Memory7.558.058.669.079.531.611.591.59
Max SQL Cache Memory8.058.669.079.539.779.812.589.81
Avg SQL Cache Memory7.828.398.899.329.664.812.147.29

SQL Total Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Total Mem12.7812.7812.7812.7812.795.646.515.64
Max SQL Total Mem12.812.8212.8212.8112.8213.368.6713.36
Avg SQL Total Mem12.7912.812.8112.8112.818.948.2311.6

SQL Target Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Target Mem12.7812.7812.7812.7812.85.646.515.64
Max SQL Target Mem13.5713.6913.7813.7713.8513.8513.2813.85
Avg SQL Target Mem13.3913.5113.5513.5613.613.0812.7813.35

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 Blocked1313916451818
Avg SQL Processes Blocked1.010.860.770.970.140.172.360.9

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/sec0000000.010.01
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 Wait600016600000607797600000600016600016600406607797
Avg SQL Locks Avg Wait4176.264055.733790.685436.321076.861469.6410916.364417.41

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 Wait6.393.257.258.1747.758.6831.547.75
Avg SQL Latches Avg Wait0.040.040.040.040.020.030.060.04