
Sometimes these symptoms can actually be caused by a completely different problem such as a memory pressure or a handle leak. The difficulty with diagnosing port exhaustion is that it can have a variety of symptoms. But what happens when so many connections are opened that all these ephemeral ports become used up? Well that’s when the fun, games and ephemeral port exhaustion begins!

When the communication is complete the connection will enter a TIME_WAIT state and after a default delay of 4 minutes it will be able to be reused. However, the local machine we're connecting from uses a random available port from its ephemeral port range to make the connection. When we connect to a server, we typically know the port we're connecting to. Understanding what port exhaustion is and why it can occur can make your job considerably easier if you should run into this problem.Įphemeral, or dynamic ports are a port range used for short lived communications.

It is rare enough that is not often considered, not widely understood and can cause extreme confusion when it does pop up. During my years as a DBA I’ve come across ephemeral port exhaustion just a handful of times.
