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
Continue reading →