SQL Management Studio causes services.exe pegs my CPU

Jaxidian

Platinum Member
Oct 22, 2001
2,230
0
71
twitter.com
This is my development box at work. It's setup as such:

Core 2 Duo Laptop
Vista Premium
SQL Server 2k5 Developer (fully patched)

Re-statement of the problem with updates:
Services.exe pegs my CPU approximately a third of the time (i.e. if I go 100 hours of uptime, about 33 hours will be inside Services.exe). I have isolated this to only happening when SQL Management Studio is running. I have SQL Server 2005 Dev Ed. and Express Ed. both installed but all services are set to manual and are not running. I can have a bajillion things open or nothing and if I fire up SQL Management Studio, then the problem pops up

Googling hasn't helped. Everybody says the problem is malware-related, this is not the case. I've confirmed in every way I know how, plus learned some new ways, to verify that services.exe is really Microsoft's exe. Process Explorer even says so. On top of that, this is only about a 1-month-old install of Windows (was one-week when I began having this problem) and I'm pretty anal when it comes to what I install and open on my dev pc.

Thanks!
-Jax
 

Jaxidian

Platinum Member
Oct 22, 2001
2,230
0
71
twitter.com
Still got this problem. I've gotten to the point where I no longer have SQL Server running or anything. Just my CPU starts to get eaten alive by services.exe and only when I have SQL Management Studio open (not even connected to anything).

HELP!!
 

Jaxidian

Platinum Member
Oct 22, 2001
2,230
0
71
twitter.com
Originally posted by: WannaFly
do you have SQL SP2?
http://www.microsoft.com/downloads/deta...-49c8-8f0c-63fa18f26d3a&DisplayLang=en

from site:
Note: SQL Server 2005 Service Pack 2 (SP2) is designed to run on Windows Vista and Windows Server "Longhorn." For more information about installing and running SQL Server 2005 on Windows Vista and Windows Server "Longhorn," see this Microsoft Web site.

Yep, I sure do! Got every routine patch I could find from MS for SQL Server.
 

Jaxidian

Platinum Member
Oct 22, 2001
2,230
0
71
twitter.com
I'm running Vista - isn't that a core component of the OS? I don't see .NET 2.0 listed in there and I know that's what SQL Server 2005 uses.
 

Markbnj

Elite Member <br>Moderator Emeritus
Moderator
Sep 16, 2005
15,682
14
81
www.markbetz.net
Yep, sorry, disregard. Missed the Vista part. Maybe there's a compatibility issue between Vista and SQL Server.
 

Jaxidian

Platinum Member
Oct 22, 2001
2,230
0
71
twitter.com
I've still not gotten any help of significance. Anybody have any idea what this might be? Just FYI, I've taken another machine, running Vista, installed SQL Mgmt Studio w/SP2 on it and have it hit the SQL Server box and neither of these two machines peg the CPU.