From: Les on
We have started seeing the same issue with 100% CPU usage when we attach a particular db of 30GB size. Detaching the this db gets rid of the problem.
Did you find any resolution to your issue?




MariaGuzman wrote:

ghost cleanup task
10-Mar-10

I have a server running win2003, sql server 2005 sp3. Yesterday appears
the ghost cleanup task on the server. I see that this task increese in
cpu time and it cause that the cpu has 100% used.

I reboot the server and the task appears again. I read on Internet many
options and apply it but it doesn?t work.

Do someone know why the process appears even after the server was
shootdown?
Do you know a way to avoid this task use a lot of cpu?
How can I identify the process that is causing this task.

Thanks a lot for your help.




*** Sent via Developersdex http://www.developersdex.com ***

Previous Posts In This Thread:

On Wednesday, March 10, 2010 7:11 PM
MariaGuzman wrote:

ghost cleanup task
I have a server running win2003, sql server 2005 sp3. Yesterday appears
the ghost cleanup task on the server. I see that this task increese in
cpu time and it cause that the cpu has 100% used.

I reboot the server and the task appears again. I read on Internet many
options and apply it but it doesn?t work.

Do someone know why the process appears even after the server was
shootdown?
Do you know a way to avoid this task use a lot of cpu?
How can I identify the process that is causing this task.

Thanks a lot for your help.




*** Sent via Developersdex http://www.developersdex.com ***

On Thursday, March 11, 2010 5:17 AM
Uri Dimant wrote:

MariaGo to www.sqlblog.
Maria
Go to www.sqlblog.com and look for Adam's utility named
who_is_active_v8_82.sql


Submitted via EggHeadCafe - Software Developer Portal of Choice
Measuring SharePoint Page Rendering
http://www.eggheadcafe.com/tutorials/aspnet/c0a9ac9e-53cd-442f-8981-9d5f236c2be5/measuring-sharepoint-page.aspx