In March 2012 (precisely 6th March 2012), Microsoft made available SQL Server 2012 Performance Dashboard Reports which can be used to identify whether there is a current bottleneck on the system, and if so, capture additional diagnostic data that may be required to resolve it.
More information on this can be read from the download page: Microsoft SQL Server 2012 Performance Dashboard Reports.
One point worth to be highlighted is that this doesn’t require Reporting Services to be installed.
It’s a very crucial and important tool for any database administrator.
VAIDY
*This post is locked for comments