Title: | System Profile - Summary |
Description: | System Profile - Summary |
database_name | db_type | recovery_model | db_lifetime_days | total_data_files | total_data_size_mb | pct_data_used | total_log_files | total_log_size_mb | avg_data_delta_mb_per_day | projected_data_delta_mb_3_months | projected_data_delta_mb_6_months | projected_data_delta_mb_12_months | avg_transaction_per_second | data_avg_number_reads_per_min | data_avg_number_writes_per_min | data_avg_bytes_read_per_min | data_avg_bytes_written_per_min | log_avg_number_reads_per_min | log_avg_number_writes_per_min | log_avg_bytes_read_per_min | log_avg_bytes_written_per_min | data_expansions | total_data_expansion_kb | total_data_expansions_duration_sec | log_expansions | total_log_expansions_kb | total_log_expansions_duration_sec | data_shrinks | total_data_shrinks_kb | total_data_shrinks_duration_sec | log_shrinks | total_log_shrinks_kb | total_log_shrinks_duration_sec | full_backup_count | full_backup_avg_size_mb | full_backup_avg_duration_sec | full_backup_avg_mb_per_sec | diff_backup_count | diff_backup_avg_size_mb | diff_backup_avg_duration_sec | diff_backup_avg_mb_per_sec | log_backup_count | log_backup_avg_size_mb | log_backup_avg_duration_sec | log_backup_avg_mb_per_sec | backup_total_mb | backup_total_mb_deleted |
test1 | usr | simple | 150 | 1 | 50 | 6.000 | 1 | 20 | 0.11342 | 1.20580 | 2.41560 | 4.83120 |   | 0.10 | 0.10 | 2555.85 | 180.25 | 0.10 | 0.10 | 5.05 | 69.64 |   |   |   |   |   |   |   |   |   |   |   |   | 15 | 4.080000 | 0 | 4.080000 | 0 | 0.100000 | 0 | 0.100000 | 0 | 0.100000 | 0 | 0.100000 | 69.36 | 65.28 |
master | sys | simple | 2552 | 1 | 4 | 55.000 | 1 | 3 | 0.10255 | 0.24550 | 0.49500 | 0.99000 | 95 | 0.10 | 0.10 | 2155.99 | 201.09 | 0.10 | 0.12 | 16.18 | 335.29 |   |   |   |   |   |   |   |   |   |   |   |   | 31 | 3.026129 | 1 | 2.528509 | 0 | 0.100000 | 0 | 0.100000 | 0 | 0.100000 | 0 | 0.100000 | 93.81 | 51.36 |
model | sys | full | 2552 | 1 | 1 | 100.100 | 1 | 23 | 0.10000 | 0.10000 | 0.00000 | 0.10000 | 0 | 0.10 | 0.10 | 905.52 | 101.33 | 0.10 | 0.10 | 14.63 | 92.03 |   |   |   |   |   |   |   |   |   |   |   |   | 30 | 1.315000 | 0 | 1.226333 | 1 | 0.420000 | 2 | 0.210000 | 0 | 0.100000 | 0 | 0.100000 | 39.93 | 21.28 |
msdb | sys | simple | 1652 | 1 | 226 | 95.600 | 1 | 40 | 0.39835 | 35.85150 | 51.50300 | 143.40600 | 0 | 0.23 | 0.95 | 120081.55 | 15351.85 | 0.10 | 18.48 | 1526.18 | 80154.99 |   |   |   |   |   |   |   |   |   |   |   |   | 30 | 138.984666 | 5 | 26.885666 | 1 | 12.190000 | 9 | 1.350000 | 0 | 0.100000 | 0 | 0.100000 | 4181.53 | 3355.90 |
reportingDB | usr | full | 649 | 1 | 51 | 45.900 | 1 | 31 | 0.15143 | 6.42850 | 12.85540 | 25.51480 | 0 | 0.19 | 0.12 | 15125.81 | 4150.22 | 0.10 | 0.11 | 1166.51 | 1999.88 |   |   |   |   |   |   |   |   |   |   |   |   | 34 | 20.551564 | 1 | 15.654505 | 1 | 3.100000 | 0 | 3.100000 | 1405 | 0.182320 | 0 | 0.165544 | 958.50 | 4699.85 |
tinyDB | usr | full | 15 | 1 | 500 | 61.400 | 1 | 100 | 19.00000 | 1510.10000 | 3420.10000 | 6840.10000 |   | 1.25 | 0.10 | 102925.81 | 4435.50 | 0.10 | 0.10 | 1313.31 | 1906.50 |   |   |   |   |   |   |   |   |   |   |   |   | 15 | 162.480000 | 13 | 12.325333 | 0 | 0.100000 | 0 | 0.100000 | 685 | 0.185564 | 0 | 0.185564 | 2496.12 | 2008.66 |
metricsDB | usr | full | 52 | 1 | 500 | 0.800 | 1 | 100 | 0.15882 | 5.29380 | 10.58560 | 21.15520 |   | 0.10 | 0.10 | 2505.94 | 1305.92 | 0.10 | 0.64 | 533.32 | 1324.58 |   |   |   |   |   |   |   |   |   |   |   |   | 15 | 4.668235 | 0 | 4.518823 | 0 | 0.100000 | 0 | 0.100000 | 685 | 0.196346 | 0 | 0.196346 | 145.55 | 309.93 |
mainDB | usr | full | 619 | 2 | 9065 | 56.100 | 1 | 1544 | 8.08654 | 525.58860 | 1455.55520 | 2911.15440 | 13 | 9.66 | 42.55 | 1615912.12 | 505515.06 | 0.58 | 280.15 | 886811.95 | 850639.20 |   |   |   |   |   |   |   |   |   |   |   |   | 66 | 3095.326363 | 53 | 54.615909 | 2 | 130.120000 | 5 | 21.800000 | 1360 | 4.086169 | 0 | 2.914551 | 210108.55 | 552289.69 |
tempdb | sys | simple | 30 | 4 | 2000 | 5.500 | 1 | 300 | 0.15143 | 6.42850 | 12.85540 | 25.51480 | 40 | 203.60 | 223.92 | 12304558.38 | 14343330.91 | 0.10 | 69.91 | 6.05 | 4006838.40 |   |   |   |   |   |   |   |   |   |   |   |   | 0 | 0.100000 | 0 | 0.100000 | 0 | 0.100000 | 0 | 0.100000 | 0 | 0.100000 | 0 | 0.000000 | 0.10 | 0.10 |
virtualDBA | usr | simple | 412 | 3 | 2882 | 28.800 | 1 | 612 | 0.10000 | 0.10000 | 0.10000 | 0.10000 | 0 | 0.20 | 2.32 | 209124.60 | 61325.04 | 0.10 | 1.82 | 105.03 | 41156.69 |   |   |   |   |   |   |   |   |   |   |   |   | 33 | 551.408484 | 14 | 35.212121 | 1 | 15.090000 | 1 | 15.090000 | 0 | 0.100000 | 0 | 0.000000 | 18213.55 | 12981.56 |
migrateDB | usr | simple | 189 | 1 | 400 | 1.000 | 1 | 34 | 0.10000 | 0.10000 | 0.10000 | 0.10000 | 0 | 0.10 | 0.12 | 3488.93 | 4491.52 | 0.10 | 0.15 | 515.21 | 863.01 |   |   |   |   |   |   |   |   |   |   |   |   | 130 | 66.645000 | 2 | 22.209538 | 0 | 0.100000 | 0 | 0.100000 | 654 | 1.256409 | 0 | 0.381513 | 9524.15 | 1133.48 |