Monthly Archives: January 2012
If you don’t know much about SQL Server internals and its performance tuning techniques, but still need your SQL Server performance, right upto the mark, then you must try SQL Doctor, a really helpful tool by Idera.
SQL doctor is a revolutionary technology that analyzes the performance of SQL Server and provides recommendations for improving performance.
To get recent size of all databases on an instance, I have found following simple query very useful.
ROUND(SUM(mf.size) * 8 / 1024, 0) Size_MBs
FROM sys.master_files mf
INNER JOIN sys.databases d ON d.database_id = mf.database_id
WHERE d.database_id> 4 — Skip systemdatabases
GROUP BY d.name
ORDER BY d.name