The computer that is running SQL Server 2008 R2 indicates 100% CPU utilization

  • Article

This issue occurs because the Ghost Cleanup task uses 100% of the CPU on an idle system in SQL Server 2008. To resolve this issue, apply the following update that is most appropriate for you.

Cumulative Update package 1 for SQL Server 2008 R2

Cumulative update package 7 for SQL Server 2008 Service Pack 1