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.
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…
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.