virtualDBA | System Profile

reports.virtualDBA

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

2010-01-23 05:22:35.840