Solved

VB.NET Windows Application Crash/Hang Issue

Posted on 2010-09-14
3
710 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
3 Comments
 
LVL 27

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 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