We are running SQL 2000 on an 8 processor system, and performance is very slow. By looking at the CPUs with the taskmanager it seems only one processor is being used by SQL. Is there a switch within SQL to allow it to use the available processing power.