Simulated statistics output

Output for the simulate option to optdiag prints a row labeled “simulated” for each row of statistics, except histograms. You can modify and load the simulated values, while retaining the file as a record of the actual values.

Here is a sample of the table-level statistics for the titles table in the pubtune database:

Table owner:                           "dbo"
Table name:                            "titles"

Statistics for table:                  "titles"

     Data page count:                  731.0000000000000000 (simulated)
#    Data page count:                  731.0000000000000000 (actual)
     Empty data page count:            1.0000000000000000 (simulated)
#    Empty data page count:            1.0000000000000000 (actual)
     Data row count:                   5000.0000000000000000 (simulated)
#    Data row count:                   5000.0000000000000000 (actual)
     Forwarded row count:              0.0000000000000000 (simulated)
#    Forwarded row count:              0.0000000000000000 (actual)
     Deleted row count:                0.0000000000000000 (simulated)
#    Deleted row count:                0.0000000000000000 (actual)
     Data page CR count:               0.0000000000000000 (simulated)
#    Data page CR count:               0.0000000000000000 (actual)
     OAM + allocation page count:      6.0000000000000000 (simulated)
#    OAM + allocation page count:      6.0000000000000000 (actual)
     First extent data pages:          0.0000000000000000 (simulated)
#    First extent data pages:          0.0000000000000000 (actual)
     Data row size:                    190.0000000000000000 (simulated)
#    Data row size:                    190.0000000000000000 (actual)

In addition to table and index statistics, the simulate option to optdiag copies out:

If you want to test how queries use a 16K pool, you could alter the simulated statistics values above to read:

Configuration for cache:               "pubtune_cache"

     Size of 2K pool in Kb:            10240 (simulated)
#    Size of 2K pool in Kb:            15360 (actual)
     Size of 4K pool in Kb:            0 (simulated)
#    Size of 4K pool in Kb:            0 (actual)
     Size of 8K pool in Kb:            0 (simulated)
#    Size of 8K pool in Kb:            0 (actual)
     Size of 16K pool in Kb:           5120 (simulated)
#    Size of 16K pool in Kb:           0 (actual)