The Database Collector History screens provide information gathered by a SQL Server Agent job which collects performance information on SQL Server every 20 minutes. Most of the data is collected using SQL Server Performance Monitor counters. Use transaction DBACOCKPIT, and choose .
To view and control the state of the database collector job, use
.The main screen shows a Time Series grid. When you select a set of columns on the Time Series grid and then click on Display Chartthis will graph the selected columns. The Select Category dropdown list allows you to choose categories of data, which appear on the grid. You can also adjust a time period and grid unit. To run a new query, choose the Refresh button.