SQLservr.exe 100% CPU, why?

Question

Happy new year and merry xmas to everyone

I got SQL 2005 Express edition with Sharepoint Server 2007 installed and its running 100% CPU all the time

there are plenty threads like this out there but none have an answer

anyone got ideas?

Answer 1

Hi,

Check the processes running in SQL server for maximum CPU consuming query using "Select * from sys.dm_exec_requests". I'm not sure Performance dashboard is supported in SQL Server Expres, if its supported you can get the list of query which is consuming high cpu.

Answer 2

thank you for the reply, looking at the screenshot below, sharedservices1_search is using all CPU, what do i do with it?

Answer 3

Is your full text search enabled at set up as a configuration? Do you need it? Perhaps it is the culprit? The disclaimer: I am not an expert, it may be a long shot.

Answer 4

Just a minor correction to Vidhya's good response the query is select * from sys.dm_exec_requests.

 

- Deepak

 

Answer 5

ok i got 19 rows of data, which mean nothing to me, what am I actually looking at?

 

i got enough problems with sharepoint, could do without the SQL ones

Answer 6

sercan wrote:

ok i got 19 rows of data, which mean nothing to me, what am I actually looking at?   i got enough problems with sharepoint, could do without the SQL ones

 

Just an observation. It seems the "knowledgeable" moderators in this forum touch your post, ask a question or two and drop the ball like a hot potato. Truly amazing. I am sure they do get credits for "answering" your questions and pretty soon you will see 4 stars against their names instead of three. Great company! A totally disgusting behavior.

 

I think you should file a complaint with MS and I am planning to do it as well.

Answer 7

 

if i stop the SQLserver CPU goes back to normal

 

Dashboard confirms that sharedservices_search_db is using 99% CPU, what do i do with the database? delete it?

EDIT: fixed, stoped the SQL server restarted the machine, CPu back to normal

Answer 8

sercan wrote:

if i stop the SQLserver CPU goes back to normal   Dashboard confirms that sharedservices_search_db is using 99% CPU, what do i do with the database? delete it? EDIT: fixed, stoped the SQL server restarted the machine, CPu back to normal

 

I guess it is a "solution." If there is no database, sql server has nothing to worry about. There will be nothing to share.

Answer 9

 

sorry what i mean was, when i restarted the machine, SQLserver went back to normal, no 100% CPU. Problem now is, no idea what the problem was and how to solve it properly =/

Answer 10

sercan wrote:

sorry what i mean was, when i restarted the machine, SQLserver went back to normal, no 100% CPU. Problem now is, no idea what the problem was and how to solve it properly =/

 

Well this tool should be remembered. Perhaps next time I see a post with SQL Server problems I'll just say: turn your machine off, the problem will be gone. And get a credit for the "solution"

Answer 11

The data from your session is stored in the sqlservr.exe cache, which is why the memory usage grows. You can configure the maximum amount of memory allocated to SQL Server so it doesn't use up all of your RAM.