vbfeeds.com/Post

The content of the postings is owned by the respective author. vbfeeds.com is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on vbfeeds.com, please contact us at abuse@vbfeeds.com and we will remove it. Designated trademarks and brands are the property of their respective owners. vbfeeds.com Copyright © 2005 Serge Baranovsky. All rights reserved.

Wednesday, July 13, 2005

Workaround: SQL 2005 Beta 2 sqlservr.exe hogs CPU

by via SergeB (Serge Baranovsky) on 7/13/2005 5:42:00 PM

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.

Original Post: http://blogs.vbcity.com/sergeb/archive/2005/07/13/4645.aspx

© 2005 Serge Baranovsky. All rights reserved.
All feed content is property of original publisher. Designated trademarks and brands are the property of their respective owners.

This site is maintained by SubMain(), a division of vbCity.com, LLC