There are four configuration parameters that set the query metrics threshold for capture into the catalog. These parameters are useful if you want to filter out trivial metrics before writing metrics information to the catalog. The syntax is:
sp_configure ‘metrics lio max’ | ‘metrics pio max’ | ‘metrics elap max’ | ‘metrics exec max’ , <value>
For example, the following will not capture those query plans for which lio is less than 10:
sp_configure ‘metrics lio max’, 10
