• Google Glenn Berry's diagnostic queries. They have helped me in various situations and give a good insight in the most important aspects of an SQL Server instance. He has sets per version.