Hello All,

A 2 part post this month, i guess i finally removed head from arse and got around to posting updates. First a super useful query for IO stats of log and data files. Please note these are at file level. This may exist already and im sure there are better ways to do this, but since i have been going through a ton of logs and data files at work recently, i figured it was worth a post.

[code]
SELECT
DB_NAME(tblFileStat.database_id) AS databaseName ,
tblFileStat.file_id ,tblMasterFile.phy...
Continue reading ...