Hello all, I am relatively intermediate when it comes to SQL. I have a Dual Xeon 3.0 GHZ (HT so Windows shows 4 processors). with 9 GB or RAM. Hard drive confirguraiton is 10K 300 GB SCIS RAID1. W2k3 Ent SP1 and SQL 2k SP4. The drive is fragmented and the AWE is not enabled. But I don't have a memory problem. I have a processor usage problem. The system is constantly using more than 50 % processor and when I import a lot of Access databases and run queries the processor usage spikes to 100%. I did not originally configure this system but I am tasked with manageing it now. I really need to improve performance on the system. The database that is used is 100 GB (approximately). I run database maintenance daily. Any ideas would be greatly appreciated.