We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

SQL CPU limit/function question.

Medium Priority
1,030 Views
Last Modified: 2012-08-13
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?
Comment
Watch Question

QA Product Specialist
CERTIFIED EXPERT
Commented:
All I can answer is

 msftefd.exe (PKM executable) is the equalivant of the SQL Server 2000 mssdmn.exe (Microsoft PKM Search Filter Daemon). The SQL 2005 msftefd daemon is launched by the msftesql service when it is necessary to read or "crack" specific file types via IFilters files for example: MS Word (.doc), Adobe PDF (.pdf), etc.


i will look other things, but i am sure other experts will beat me

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
James MurrellQA Product Specialist
CERTIFIED EXPERT

Commented:

Author

Commented:
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.
 
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.