Workaround: SQL 2005 Beta 2 sqlservr.exe hogs CPU

13 Jul 2005 by Serge B. 0 Comments

HogInChinese_XSmall I have SQL Server 2005 Beta 2 on my laptop for few months and every now and then I find my laptop to be very sluggish. In the task manager sqlservr.exe shows 98-99%.

It is only a week ago I found why that might happen and a workaround.

I noticed that SQL only eats up the CPU when I have SQL Server Management Studio loaded with a table open. Even when it is inactive for few days for some reason SQL goes nuts and hogs CPU at 99% for hours.

Workaround for this is to close the Management Studio and then open it again few minutes later.

I now load the Management Studio only when I need it and look forward to the SQL Server 2005 release.

Update: The issue was not resolved in SQL 2005 RTM. Sigh. At least there is a workaround…

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Upsizing MS Access 2007 database to SQL Server 2008 I’ve done quite a bit of MDB upsizing to SQL Server in the past. And it works just like a snap - yo...Tip: How to enter a NULL value in SQL Enterprise Manager table grid This one is very handy and yet not very intuitive - I keep forgetting it and search every time I ...Design Guidelines Book and T-SQL Coding Standards As found via Brad Abrams there is new great book is coming out - Framework Design Guidelines : Co...