We have been unable to change the parameters SP_QUE_POST_SHMSIZE, SP_QUE_Q_SHMSIZE in some instances. The event log records the parameter change, but list param modified does not show the change. We examined the data/paramdb file and found that it contained several entries for the parameter. I edited the paramdb file and restarted cop and the parameter was applied.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.