Database maintenance and repair
Edition: 1.1 03/08/2007
317
Multi-processor mode
If the Sybase database server is running on a computer with more than one processor, multiple processors
can be configured to increase the performance of Sybase. This enables parallel processing of database
queries.
Processors in this context include both virtual (hyperthreading) and physical CPUs. It is best to use the
display on the Performance tab of Windows Task Manager as a basis for the number of CPUs.
Note that you must never assign all available CPUs to Sybase, as enough processor power must also be
reserved for the operating system and additional applications (db_srv, lna_srv, etc.).
Formula
The following formula applies for a computer on which only the components of the database setup are
installed.
Max. number = CPUs-1
Settings
The following example shows the configuration of a computer with four CPUs.
1. Start ISQL in a command prompt (DOS box). Enter the following commands.
isql -U sa -P password
2. Enter the number of CPUs minus one. Enter the following commands.
sp_configure "max online engines", 3
go
sp_configure "number of engines at startup", 3
go
3. You must restart the Sybase SQLServer_servername service.
Parallel processing
1. If you would like to configure parallel processing (number of CPUs*3+1), enter the following
commands.
sp_configure "number of worker processes", 10
go
sp_configure "max parallel degree", 3
go
sp_configure "max scan parallel degree", 3
go
Содержание Customer Interaction Express 1.0
Страница 3: ......
Страница 4: ......
Страница 22: ...22 User Manual CIE 1 0 System Administration...
Страница 84: ...84 User Manual CIE 1 0 System Administration...
Страница 131: ...Connecting to ACM Avaya Communication Manager Edition 1 1 03 08 2007 131...
Страница 154: ...154 User Manual CIE 1 0 System Administration...
Страница 174: ...174 User Manual CIE 1 0 System Administration...
Страница 216: ...216 User Manual CIE 1 0 System Administration...
Страница 226: ...226 User Manual CIE 1 0 System Administration...
Страница 318: ...318 User Manual CIE 1 0 System Administration...
Страница 322: ...322 User Manual CIE 1 0 System Administration...