Hanging application SqlWb.exe in SQL Server 2005

Question

Post reply

Hanging application SqlWb.exe in SQL Server 2005

keenma

SSC Enthusiast

Points: 187
More actions
March 18, 2008 at 6:51 pm

#188324

I am using SQL Server 2005 in x64 platform, when I trace back the event log, I found the following error,
Description:
Hanging application SqlWb.exe, version 2005.90.1399.0, hang module hungapp, version 0.0.0.0, hang address 0x00000000.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Does anyone meet this before and what is the cause of the error?

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Adam Bean One Orange Chip Points: 26631 More actions · Answer 1

Sounds like management studio simply got hung ...

Did it only happen once? If so, I wouldn't worry ...

Steve Jones - SSC Editor SSC Guru Points: 734564 More actions · Answer 2

sqlwb is Management Studio.

As Adam mentioned, unless this happens often, I wouldn't worry.

David Taylor-327123 Grasshopper Points: 11 More actions · Answer 3

I get this often, the 2005 management studio either at startup or when asked to open a table will hang with typically 80-90% system resources consumed by sqlwb.exe. Though this seems to be a new problem, I used MS for many months before this started. There is a discussion here https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=496262&SiteID=17 but remedies like rebuilding the OS then sql are unattractive. Video drivers are not it for me.

this problem wastes a lot of time shutting down the process and starting MgtStudio again. I recently went to Office2007 to get Access2007 and use adp to connect to a db which I have found quick and easy at least for viewing data, and better than firing up MS let alone with all this hanging problem. THen I find that I need to remove all extended properties from sql2005 tables in order for the adp to be able to read them. All very annoying.

koifishguru Grasshopper Points: 17 More actions · Answer 4

any luck with your question, I am getting the same thing repeatedly

david.taylor-598378 Valued Member Points: 51 More actions · Answer 5

yes, solved it. Bought a new PC. Sorry cant be more helpful.

email2laks SSC Enthusiast Points: 166 More actions · Answer 6

Sorry any solutions same issue here, I have started a new thread as well, without seeing this one, buying a new PC will not help as it a Itanium Server with around 800 Gigs of data.

Thanks

Regards

laksUK

jim-305168 SSC Enthusiast Points: 120 More actions · Answer 7

I ran into this problem too but I might have some advice:

When you run the query that is hanging SQL Server Management Studio (sqlwb.exe), take a look at the swirling "Executing" status at the bottom-left of the sqlwb.exe window. If that's still running--then you've got a runaway query going or one that is working hard to generate results.

Stop the query using the red icon at the top of the sqlwb.exe window and re-examine your query WHERE clause, etc. See if you can reduce the number of rows.

If you try to scroll a resultset window (especially results in a grid) while results are still being generated, CPU usage will spike to 100%.

But don't do anything like uninstall SQL Server and reinstall it. It is probably unnecessary and will take a lot of time. Also, you may mess-up add-ins or your configuration unintentionally, causing you more headaches.

I hope this helps someone out there...

email2laks SSC Enthusiast Points: 166 More actions · Answer 8

I raised this issue with Microsoft and the issue was fixed by applying the hotfix, this is only for an Itanium Server running on Windows 2003 with .NET Framework 2.0. Installed.

http://support.microsoft.com/kb/945766

Thanks

Regards

laks

jim-305168 SSC Enthusiast Points: 120 More actions · Answer 9

This guy (previous message) has no idea what he's talking about. The hotfix he cites has nothing at all to do with a stalled sqlwb.exe process.

email2laks SSC Enthusiast Points: 166 More actions · Answer 10

Jim

If this is your opinon I am fine with that. Did you go through the hotfix and what is issue is as well...

Quote from the Hotfix

SYMPTOMS

On a computer that is running an Itanium-based version of Windows Server 2003 with Service Pack 2, you may experience issues that are related to the IA-32 emulation layer.

Back to the top

Issue 1

An application may close unexpectedly. For example, Microsoft SQL Server 2005 Management Studio may close unexpectedly when you click the New Query button on the toolbar.

and by applying this hotfix it solved my problem...:)

Regards

Laks

Miz Zahan SSC Veteran Points: 222 More actions · Answer 11

email2laks,

did you receive this error?

Hanging application SqlWb.exe, version 2005.90.xxxx.0, hang module hungapp, version 0.0.0.0, hang address 0x00000000.

email2laks SSC Enthusiast Points: 166 More actions · Answer 12

Miz

Yes, by applying the patch it was solved.

Regards

Laks

michele_toscano Grasshopper Points: 13 More actions · Answer 13

I've run into this problem even post reboot and before processing any SQL queries at all. It begins as soon as SQL mgmt studio is opened. Any other thoughts? Thanks!