Generate SQL Server performance report using `system_tools`

Use a system_tools command option to generate a SQL Server performance report.

Before you begin

Ensure that there is a running PolicyCenter server before starting this procedure and that you can access it as an administrative user.

Open a command prompt on the running PolicyCenter server.
Navigate to the following location in your PolicyCenter installation:
- admin/bin

Enter the following command at the command prompt:

system_tools -password password -mssqlPerfRpt firstID secondID collectstatistics

The option parameters have the following meanings.

`password`	Required password for an administrative user.
`firstID`, `secondID`	Setting a single ID indicates a single time period. Setting two interval IDs indicates a time range. If you do not supply an interval ID, PolicyCenter does not generate Query Store statistics.
collectstatistics	Boolean value that indicates whether to include database statistics (`true`) in the report.

For a discussion of the option parameters, see About SQL Server reports and system tools.

To view the generated report, do one of the following:

Download the report in the Server Tools SQL Server Performance Report screen.
View the report in the Server Tools SQL Server Performance Report screen (development mode only).
Download the report for viewing using the -getPerfReport option on the system_tools command.