I've got an AWS server with Windows 2008 R2, SQL Server 2012, and Tomcat 7. When I run netstat -ano
the screen is flooded with TIME_WAIT
. I posted the output in a Gist.
When I run CurrPorts, filter on port 1433, and turn on Auto Refresh, I can see sqlserver.exe making connections from port 1433 to an ephemeral port and vice versa over and over again.
I've tried researching why this is happening, but it's always a dead end. Does anyone know why?
PS
An answer regarding an AWS bug seemed to be promising, but it's from 2011, and they were experiencing a different issue. The connections on my sever are eventually closing. I just don't know why they're getting opened so frequently.