Show TOC

Database Collector HistoryLocate this document in the navigation structure

Use

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 Start of the navigation path Performance Next navigation step History  Next navigation step DB Collector History End of the navigation path.

To view and control the state of the database collector job, use Start of the navigation path GoTo Next navigation step Collector state End of the navigation path.

Features

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.