Using SQL Server 2012 Performance Dashboard Reports
In this post I would like to talk about various reports ( SQL Server 2012 Performance Dashboard Reports ) that are available to us (through Microsoft Download) and their purpose is to give us an overview of the overall performance of an SQL Server instance.Basically they can help us identify where bottlenecks (CPU,IO) can be found.These reports identify where blocking occurs (waits-latches).You do not have to install SQL Server Reporting Services in order to use these reports.They retrieve all the data they present us through DMVs. (
read more)