Setting and Displaying Database Engines
Two configuration parameters control the number of dataserver processes (engines) which are active
in the server: "max online engines" and "number of engines at startup".
Most shops with 4-cpu servers will set these to 3.
If the number of engines at startup is lower than the max online engines, how do you tell the
number of engines which are active?
There are two ways:
1) select * from master..sysengines
2) at the UNIX prompt, use the ps -ef command to list all running processes. Note the dataserver
processes, each is an engine.
How to start/stop an engine?
-- start engine #4
sp_engine 'online',4
go
-- stop engine #4
sp_engine 'offline',4
go
|
|
