One of the best friends of Database Administrators , irrespective of race(read engine) and religion (read edition) are the System Views. System Views have simplified troubleshooting and performance tuning a lot in the past few years. Couple of versions ago DBAs had to write complex scripts and stored procedures to join, extract, transform and compare data to reach performance matrix. But now the database vendors got smarter and created system and dynamic views that does all that behind the scene and give the DBAs the information in a more intelligent fashion.
Lets compare some of the key dynamic views DBAs use on a regular basis :
The above and many more dynamic and systems views and routines can be found for those three databases at
If anyone has any tips and tricks or useful scripts, please post it on the comments