The SQL Server 2012 Performance Dashboard is a free tool from Microsoft and assists in viewing the health and status of your SQL Server instance. It even works on SQL Server 2008. You can download it from (here).

Here’s a quick tour from the SQL Server Central site (here). Note registration is free for the site.