Ayende @ Rahien

Hi!
My name is Oren Eini
Founder of Hibernating Rhinos LTD and RavenDB.
You can reach me by phone or email:

ayende@ayende.com

+972 52-548-6969

, @ Q c

Posts: 6,124 | Comments: 45,482

filter by tags archive

Required: Debugging / Crash recovery assistance in NJ / NY

time to read 2 min | 205 words

A client of mine has run into a production problem, and we need to dig into the application to understand what is going on. Unfortunately, I am not on site, so the level of help that I can contribute currently is not that great.

We are looking for someone that can come onboard and help us figure out what the exact problem is.

I don't have all the details about the production issue yet, but the symptom is very high connection count to the database, and the OS refusing connections with TIME_WAIT. We are pretty sure that there is a connection leak somewhere, but so far we have no been able to identify it.

The application in question compromise of classic ASP, ASP.Net and .Net Window Services talking to a Sql Server 2000 database.

My client is interested in someone who can come onsite and diagnose the issue. They are located in Fort Lee, NJ, near the GWB. Obviously we would like to get to the root of the issue ASAP. If you think that you can help, please contact me and I will put you in touch with my client.

And yes, this does seems like a scenario right out of Release It!


Comments

Chris Patterson

Oren,

There are two things we had to set on some of our higher utilized SQL servers that were refusing connections.

For WinsockListenBacklog you can find the registry key at http://support.microsoft.com/kb/154628/EN-US/. Please note that you will need to restart the SQL Server service for this setting to take effect.

For SynAttackProtect you can find the registry key at technet2.microsoft.com/.../...0242504d8ba1033.mspx. Please note that you will need to reboot the server for this setting to take effect.

Check those out and see if they are an easy tweak you can use to get out of the mud until you can more closely troubleshoot the issue.

liviu

Did you try to modify the connection string and set a higher value to MaxPoolSize...

configurator

Why can't you debug remotely?

Kalpesh

Oren,

If you/anyone is able to solve this problem, please post the steps as to how it was fixed (if that is not a problem).

Your blog is widely read & I think it will help a lot of people.

Also, try posting this question on stackoverflow :)

Comment preview

Comments have been closed on this topic.

FUTURE POSTS

  1. RavenDB 3.5 whirl wind tour: I’ll find who is taking my I/O bandwidth and they SHALL pay - 11 hours from now
  2. The design of RavenDB 4.0: Physically segregating collections - about one day from now
  3. RavenDB 3.5 Whirlwind tour: I need to be free to explore my data - 2 days from now
  4. RavenDB 3.5 whirl wind tour: I'll have the 3+1 goodies to go, please - 5 days from now
  5. The design of RavenDB 4.0: Voron has a one track mind - 6 days from now

And 12 more posts are pending...

There are posts all the way to May 30, 2016

RECENT SERIES

  1. RavenDB 3.5 whirl wind tour (14):
    02 May 2016 - You want all the data, you can’t handle all the data
  2. The design of RavenDB 4.0 (13):
    03 May 2016 - Making Lucene reliable
  3. Tasks for the new comer (2):
    15 Apr 2016 - Quartz.NET with RavenDB
  4. Code through the looking glass (5):
    18 Mar 2016 - And a linear search to rule them
  5. Find the bug (8):
    29 Feb 2016 - When you can't rely on your own identity
View all series

Syndication

Main feed Feed Stats
Comments feed   Comments Feed Stats