REPORTSSAS01 SSAS Multi-Dimmensional

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 % Usage86.3378.1681.3590.1283.5581.5592.8692.86
Avg Processor % Usage3.733.553.514.63.613.13.73.69

Available Memory Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Available Memory (MB)74647.5375284.275418.3854499.3474985.4874508.3974109.0154499.34
Max Available Memory (MB)80119.6480123.5479774.8580818.6479948.2680044.9379879.2480818.64
Avg Available Memory (MB)79181.5279279.4379193.8678443.3479409.7579389.3679321.279174.07

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)14822.5215016.315001.3314417.914970.8714912.9515035.7414417.9
Max Working Set (MB)18767.818520.2518291.7135453.0718251.6918739.1418235.0335453.07
Avg Working Set (MB)15653.9915606.9815542.5316445.0215458.8415457.5815554.7715674.24

Cache Bytes Statistics (MB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Cache Bytes (MB)691.37696.61697.58662.26704.13717.52684.36662.26
Max Cache Bytes (MB)1991.011804.152024.641973.231379.641389.291440.942024.64
Avg Cache Bytes (MB)939.52843.75922.42807.41789.31799.7799.85843.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)351.96352.99352.23328.89345.73355.3356.08328.89
Max Non-Paged Pool Bytes (MB)390.73382.48385.61383.62410.98417.12422.04422.04
Avg Non-Paged Pool Bytes (MB)359.62357.61358.25352.61359.59361.69363.46358.98

% 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 Usage13.1613.5214.8321.268.3210.79.5721.26
Avg Priv CPU Usage0.640.640.620.780.620.550.630.64

% 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 Usage82.2973.7177.484.1979.773.9988.8288.82
Avg User CPU Usage3.092.912.893.812.992.553.073.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 Length7020372317112570
Avg Processor Queue Length0.010.010.020.010.010.010.020.01

% Page File Usage Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min PageFile % Usage1.311.311.311.31.31.31.31.3
Max PageFile % Usage1.321.311.311.311.31.31.31.32
Avg PageFile % Usage1.321.311.311.311.31.31.31.31

Pages/second Statistics

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min Pages/sec00000000
Max Pages/sec219888.4150792.24134460.93155787.8790819.4690654.8491357.93219888.4
Avg Pages/sec258.02225.63224.45236.87141.498.52155.57191.49

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/sec14705.549746.558414.0610512.23354.81354.371117.314705.54
Avg Page Reads/sec8.827.027.13.391.361.21.814.39

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

Disk Percent Usage

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 100GB64.864.764.764.864.864.864.8
F - 250GB37.337.337.3505037.437.3
L - 100GB2222222
T - 100GB4.44.44.44.44.44.44.4
U - 200GB9.910.110.122.722.614.210.1

Used Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 100GB64.564.564.564.664.664.664.6
F - 250GB93.193.293.2124.9124.993.393.2
L - 100GB2222222
T - 100GB4.44.44.44.44.44.44.4
U - 200GB19.820.120.345.445.228.320.2

Free Disk Space (GB)

Drive04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019
C - 100GB35.135.135.135.135.135.135.1
F - 250GB156.7156.7156.7125125156.5156.7
L - 100GB97.997.997.997.997.997.997.9
T - 100GB95.695.695.695.695.695.695.6
U - 200GB180.2179.9179.7154.6154.8171.7179.8

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 Latency23.7911.6912.71196.07188.5197.36236.64236.64
Avg Disk Write Latency1.531.61.562.222.492.072.582.01

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 Latency38.2337.6312.922.34116.56130.7357.43130.73
Avg Disk Read Latency0.230.270.240.40.430.370.360.33

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/Os713.68717.31744.51671.06664.93741.84706.05744.51
Avg Disk Split I/Os11.1910.3710.388.9810.117.7210.759.93

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 Length153160171711063230171
Avg Current Disk Queue Length0.10.120.050.110.110.080.10.1

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 Length90.22107.6457.03118.0619.5430.6618.22118.06
Avg Avgerage Disk Queue Length0.090.10.090.10.10.080.110.1

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/sec858.8588.85525.19608.37366.16362.92370.42858.8
Avg Disk Read Mb/sec2.772.532.542.922.221.432.412.4

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/sec139.46116.47126.17418.63139.26168.76152.74418.63
Avg Disk Write Mb/sec2.712.512.53.122.591.772.782.57

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/sec150.38145.92150.08143.85154.46143.43151.85154.46
Avg Net Received Mb/sec3.082.942.892.9532.373.182.92

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/sec354.95358.44356.53501.76359.87355.86357.25501.76
Avg Net Sent Mb/sec2.912.832.73.362.92.363.092.88

SQL User Connections

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL User Connections6864685368686853
Max SQL User Connections110106107110104105108110
Avg SQL User Connections72.2471.0571.8172.3770.8770.7371.6571.53

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/sec9.524.0923.4231.7916.199.79.331.79
Avg SQL Compilations/sec0.590.620.580.570.590.50.580.58

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/sec1.28.78.6126.392.80.81.926.39
Avg SQL Re-Compilations/sec0.020.050.030.020.020.020.020.03

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/sec718.42738.42757.44797.41779.9782.52771.13797.41
Avg SQL Batch Req/sec16.1915.6615.3615.7815.514.4815.5315.5

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 Flushes357.27297.69186.13918.36968.95989.45996.23996.23
Avg SQL Log Flushes2.151.821.762.432.11.582.061.99

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.30.10.70.41.881.6901.88
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 Splits569.151761.47611.88646.54644.23381.07494.321761.47
Avg SQL Page Splits3.672.782.012.381.641.282.42.31

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 Ratio10099.3198.689999.1199.7399.9698.68
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 Memory2.873.113.343.553.94.114.32.87
Max SQL Cache Memory3.113.343.553.914.114.34.524.52
Avg SQL Cache Memory2.993.223.453.74.014.214.413.71

SQL Total Memory (GB)

Counter04/19/201904/20/201904/21/201904/22/201904/23/201904/24/201904/25/2019Total
Min SQL Total Mem9.759.759.759.759.759.759.759.75
Max SQL Total Mem9.779.779.779.779.779.779.779.77
Avg SQL Total Mem9.769.769.779.779.779.769.769.76

SQL Target Memory (GB)

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

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 Blocked11191119
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 Wait843.5922151611545.446470.061547159311545.44
Avg SQL Locks Avg Wait1.011.472.463.334.192.052.142.38

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 Wait7.256.579.512.2925.51111.6725.5
Avg SQL Latches Avg Wait0.020.020.020.030.030.020.030.02