Hyper Threadng with SQL 2000 ?

Is it better to enable Hyper Threading on a DB machine. I am running only SQL 2000 on my machine no other service is running. I have noticed in Task Manager that in peak time when there is some load on DB one Proccesor proccesing goes to 100 % while other reamin idle or maximum go to 20 to 30 %. I want whole peoccesing for database only.

If some one has any tips for improving database performance then please share it.mmmmmmmmm

Heres a good link to HyperThreading if anyones interested

http://www.2cpu.com/articles/42_2.html

But Beware as YOUR SERVER HARDWARE MUST SUPPORT THIS NEW Technology

and as Intel say

Performance will vary depending on the specific hardware and software you use. but could provide a performance increase in the neighborhood of 10-30%, depending on the application and the situation

If your really interested you could set up 2 test machines and try it but IMHO... I think your barking up the wrong tree as far as Twin/Quad CPU Usage balancing is concerned.

As far as tips for improving database performance try

Higher Spec Hardware & more RAM,
Transaction file physically stored on a seperate Hard Disk away from the RAID Array of the Data File,
Tune Indexes & tweak sloppy Querys etc...etc...etc...etc...etc...etc...etc...etc. ..

GW|||The most important thing I've read is to limit the max degreee of parallelism to the number of physical processors when using HT.