This is a 2 part question.
First I have a windows 2003 server running SQL 2005. Every once in a while i notice the CPU usage jump from 30-40% up to 95-100%. When I check the processes it's always MSFTEFD.exe taking the majority of the CPU cycles followed closely by MSFTESQL.exe and SQLSERVR.exe.
Now I assume that SQLSERVR.exe is SQL itself and not much can be done with that but what we're trying to find out is what exactly are the first 2 processes doing? From my research I think they are related to full text functions but I'm not a SQL guy so it's not clear to me.
The other part of my question is in doing my research I read that there is a way to limit the amount or number of CPUs that the SQL processes use during full text functions or possible full time.
Can anyone clarify if and how this works?