cpu problem

hello all

ok this is the issue , i have a one sqlserver 2005 instalation in two hardwares and one of those hardware work perfectly but the other one are consuming a lot of cpu and ram memory .

anyone know what is happen why the sql server ar conming a lot of cpu and memory.

regards

kofmaster

do you run Reporting Services on this server? this can consume a lot of CPU.

|||

The problem was a bad query that load the tables in memory every time that it 's executed