Solved

VB.NET Windows Application Crash/Hang Issue

Posted on 2010-09-14
3
717 Views
Last Modified: 2012-05-10
I have a Windows application built using vb.net 2008 and SQL server 2008.The Application (multiple clients) access a server machine for database and shared documents. The application also has a background worker process which updates few data grids using timer control.

The applications Tends to hang/crash at random. Not able to figure out why this is happening. The application also tends to consume more network bandwidth then it should, going up to 800 mbps (80% on 1 GB pipe at the server).I have checked the maximum query data size which is about 14 MB which is extremely rarely used. Queries in 200-400 kb are frequent.

Can anyone suggest possible areas to look at or any tools that would trace network traffic to the data being transferred?
0
Comment
Question by:SoftDesignServices
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 28

Expert Comment

by:Ark
ID: 33670281
>>VB.NET Windows Application Crash<<
Exception text can give more information. Is it "Out of stack?" - according your description it seems you have circular execution - for example 1 client update DB, others received notification and update them selfs etc.  
0
 

Author Comment

by:SoftDesignServices
ID: 33670937
I don't get any Exceptions.The application just hangs while in process,sometimes even when users lock their computer for 15-20 min.they have to END-TASK.There is also no logs in the event viewer related to this issue.This is why i wanted to find out what is the data transferred when the application hangs or when their is huge network traffic.
0
 
LVL 5

Accepted Solution

by:
andr_gin earned 250 total points
ID: 33680507
1.) You can use a network sniffer like Wireshark (www.wireshark.org) to look which packets are sent on the network and in which direction.

2.) Can you log every SQL statement sent to the database. The last statement will maybe be the one that causes the problem.

3.) Do you have multiple instances of the program running at the same time that could influence each other.

4.) You could use Windows Performance Counters to check how many transactions are made. Then you can see, if the problem is one big statement or many small statements.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question