Link to home
Start Free TrialLog in
Avatar of js479
js479Flag for United States of America

asked on

SQL CPU limit/function question.

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?
ASKER CERTIFIED SOLUTION
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of js479

ASKER

Thank you cs97jjm3. I was able to find alot more on MS's website about what they are and what they do. Here is the link.
http://msdn.microsoft.com/en-us/library/ms142541(SQL.90).aspx

So my main question now is if there is a way to limit it so that they don't max out CPU usage. I read on some forum that there was a way to do just that. I'll keep researching but figured I'd post the question here for some expert feedback.