SQL CPU limit/function question.

Posted on 2009-02-10
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?
Question by:js479
    LVL 31

    Accepted Solution

    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

    LVL 31

    Expert Comment

    by:James Murrell
    LVL 1

    Author Comment

    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.

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now