js479
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
re: MSFTESQL some else had a problem http://groups.google.com/group/microsoft.public.exchange.admin/browse_thread/thread/d7a68b68d74583b3?pli=1
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.
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.