Get IO Statistics by database
dm_io_virtual_file_stats
dm_io_virtual_file_stats
Returns virtual log file (VLF) information of the transaction log. Query determines the databases with more than xx VLFs in the log files, which can affect the database startup, restore, and recovery time. dm_db_log_info
Table design best practice Avoid using special characters and space in table name column name and another object name like view, procedures, etc. Avoid using binary data in the table. Should avoid files store as binary data. Always define Primary key Avoid using data types NTEXT, TEXT, and IMAGE. Avoid using the primary key on …