optdiag header information

After printing version information, optdiag prints the server name and summarizes the arguments used to display the statistics.

The header of the optdiag report lists the objects described in the report:

Server name:                       "test_server"

Specified database:                "pubtune"
Specified table owner:              not specified
Specified table:                   "titles"
Specified column:                    not specified

Table 2-1 describes the output.

Table 2-1: Table and column information

Row Label

Information Provided

Server name

The name of the server, as stored in the @@servername variable. You must use sp_addserver, and restart the server for the server name to be available in the variable.

Specified database

Database name given on the optdiag command line.

Specified table owner

Table owner given on the optdiag command line.

Specified table

Table name given on the optdiag command line.

Specified column

Column name given on the optdiag command line.