Multi Processor Allocation for SQL Server Engine

[tsenthil]

Dear Friends,
We have Four processor Win NT system, could any body help me to start more than on instance of the SYBASE
Sql Server Engine, with the Option to allocate each server
for each processor...

Thanks and Regards
T.Senthil Kumar
Ph: 98422 01133

 

[zibi]

You have to configure server. First start it. Next log in as system administrator (inside Sybse Central). Select "Configuration" from popup menu of your server name in left list.
Set "show configuration parameters for:" to "Procesors"
set "max online engines" to number of procesors you want to use (f.e. 4)
select "Paraller Query" in the list above, then set the parameters you like (how many procesors will be use for operations).
I hope this helps.
zibi
Zibi
--
Zbyszek Ogledzki, email:zbyszek@pangea.com.pl