Hi,<BR> Is there anything i can do to get my sql2000 server to run requests faster? Our server is a quad p4 and when a request comes in the sqlserver process only takes 30% processor for any given thread. i.e. if one user makes a request the processor jumps to 30% and sits there for a few seconds then drops back down.. if two users come in it jumps to 60% etc.. The problem is we want the server to give more processor power to any given request thus returning the result in less time. Obviously if there are several users in the system it should share processor equally between them. Its a win 2K server with tonnes of ram.