How to avoid hanging of windows service alongside other services in c# .net in production server used for processing of lot of files and insertion,updation,select process to same tables?

Question

2.00/5 (1 vote)

See more:

How to avoid hanging of windows service alongside other services in c# .net in production server used for processing of lot of files and insertion,updation,select process to same tables? I am running a continuous service which is installed in the system and if any other services run at the same time service hangs where sql server db size is around 50 GB . Also fetching of data is occuring from the same tables and insertion or updation with same tables for these services. Indexing is given for them but still the issue persists. On restarting IIS server then the processing of files works fine.I am using IIS 7.5 version.

Posted 9-May-14 1:21am

Rahul 105

Updated 9-May-14 2:03am

v2

Add a Solution

Comments

[no name] 9-May-14 7:24am

You need to debug your service and find the actual problem before you can fix it.

Sanket Saxena 9-May-14 7:34am

If i understand then you are trying to access the same table at the same time by 2 or more windows services is this what you are doing?

Rahul 105 9-May-14 7:59am

Yes fetching of data is from same tables for multiple windows services.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2014-05-09T01:37:00

Solution 1

With the complete lack of information you've given about your code and what it's doing when it hangs, it's IMPOSSIBLE for anyone to tell you what you did wrong.

Posted 9-May-14 1:37am

Dave Kreskowiak

Comments

José Amílcar Casimiro 9-May-14 9:15am

This is not a solution.

Dave Kreskowiak 9-May-14 9:38am

That's OK. The OP didn't really ask a question.