標題: sp_sysmon 如此提示﹐怎樣改參數(shù) [打印本頁] 作者: lqmm 時間: 2004-07-27 09:29 標題: sp_sysmon 如此提示﹐怎樣改參數(shù) 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 時間: 2004-07-27 11:10 標題: sp_sysmon 如此提示﹐怎樣改參數(shù) Consider using Named Caches or Cache partitions or both.
這個這樣就行了; sp_poolconfig 'default data cache','cache_partition = 4'
這個怎么設??﹕Consider increasing the 'wash size' of the 2k pool for this cache.作者: joey 時間: 2004-07-27 11:36 標題: sp_sysmon 如此提示﹐怎樣改參數(shù) sp_poolconfig cache_name, "io_size ", "wash=size[P|K|M|G]"作者: lqmm 時間: 2004-07-27 12:00 標題: sp_sysmon 如此提示﹐怎樣改參數(shù) 謝謝﹗