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.
If binary mode is specified, there are three rows of output:
A binary “simulated” row
A decimal “simulated” row, commented out
A decimal “actual” row, commented out
If binary mode is not specified, there are two rows:
A “simulated” row
An “actual” row, commented out
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:
Partitioning information for partitioned tables. If a table is partitioned, these two lines appear at the end of the table statistics:
Pages in largest partition: 390.0000000000000000 (simulated)
# Pages in largest partition: 390.0000000000000000 (actual)
Settings for the parallel processing configuration parameters:
Configuration Parameters:
Number of worker processes: 20 (simulated)
# Number of worker processes: 20 (actual)
Max parallel degree: 10 (simulated)
# Max parallel degree: 10 (actual)
Max scan parallel degree: 3 (simulated)
# Max scan parallel degree: 3 (actual)
Cache configuration information for the default data cache and the caches used by the specified database or the specified table and its indexes. If tempdb is bound to a cache, that cache’s configuration is also included. Here is sample output for the cache used by the pubtune database:
Configuration for cache: "pubtune_cache"
Size of 2K pool in Kb: 15360 (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: 0 (simulated)
# Size of 16K pool in Kb: 0 (actual)
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)
