question

In order to have this report, you need to set up the data collection to get the data points needed in the report. You can use [Performance Monitor][1] counters to capture server metrics for both the operating system and SQL Server. Then, you can capture query metrics and other internals using [dynamic management views][2] or, for really detailed metrics, [extended events][3]. But, you have to set all these mechanisms up yourself. There's no automatic report built into the system for all this. This why many people, maybe even most, look to third party software as a solution. Pay someone else to do all the work. My preferred tools are SQL Sentry and [Red Gate SQL Monitor][4] (I work for Red Gate). [1]: http://technet.microsoft.com/en-us/library/cc749249.aspx [2]: http://msdn.microsoft.com/en-us/library/ms188754.aspx [3]: http://technet.microsoft.com/en-us/library/bb630354(v=SQL.105).aspx [4]: http://www.red-gate.com/products/dba/sql-monitor/