histogram tuning factor  New sort orders

Chapter 12: Changes to Global Variables, Commands, and Stored Procedures

number of dump threads

Summary information

Default value

Disabled

Range of values

1 (disabled, no parallelism) – 8 (fully parallel)

Status

Dynamic

Display level

Intermediate

Required role

System Administrator

number of dump threads controls the number of threads that Adaptive Server spawns to perform a memory dump. Using the appropriate value for number of dump threads can reduce the amount of time the engines are halted during the memory dump.

Consider the following when you are determining the number of threads for memory dumps:





Copyright © 2004. Sybase Inc. All rights reserved. New sort orders

View this book as PDF