sp_sysmon 如此提示﹐怎樣改參數(shù)

lqmm

Tuning Recommendations for Data cache : default data cache                  
    -------------------------------------                                       
-Consider increasing the 'wash size' of the 2k pool for this cache.  

Consider using Named Caches or Cache partitions or both.

改參數(shù)的命令怎幺打?謝謝﹗

lqmm

Consider using Named Caches or Cache partitions or both.
這個(gè)這樣就行了; sp_poolconfig 'default data cache','cache_partition = 4'


這個(gè)怎么設(shè)??﹕Consider increasing the 'wash size' of the 2k pool for this cache.

joey

sp_poolconfig cache_name, "io_size ", "wash=size[P|K|M|G]"

lqmm

謝謝﹗