Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL CPU limit/function question.

Posted on 2009-02-10
3
Medium Priority
?
968 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?
0
Comment
Question by:js479
  • 2
3 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 1500 total points
ID: 23605208
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

0
 
LVL 31

Expert Comment

by:James Murrell
ID: 23605222
0
 
LVL 1

Author Comment

by:js479
ID: 23612214
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.
 
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

564 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