The latest version of Ideras’ SQL Diagnositc Manager offers some pretty nifty predictive analysis capability. Offering at present, a 12 hour forecast.
This gives you the likelihood of what might happen – a powerful trait for any DBA surely ?
Also the reports “database growth forecast” and “disk space usage forecast” can give use some idea on database trends.
Idera’s SQL Diagnostic Manager v6.6 also has a useful ‘File activity’ tab which shows I/O activity on the file level, very useful for consolidated SQL servers !
Check it out – free trial versions available too :-