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 :-

http://www.idera.com/Products/SQL-Server/SQL-diagnostic-manager/