• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

MS sql 1433

We use fingbox for network remote discovery as well as to alert our team if a host or service goes down. Recently we've been getting alerted multiple times in a day (20 times) that the mssql 1433 port is going down and coming right back up within a few seconds. I've checked all logs and for some strange reason I cannot find anything. Has anyone experienced this type of behavior with that sql port in particular and what they did to resolve it. Sql 2008r2 has all the latest sp's installed as well as the servers is up to date with all patches etc.

Thanks in advance for your help
0
visionsupport
Asked:
visionsupport
  • 2
1 Solution
 
Mark WillsTopic AdvisorCommented:
Sounds like a network config problem.

You could try setting “TcpMaxDataRetransmissions" to a higher value.

It is explained in : http://blogs.msdn.com/b/sql_protocols/archive/2006/03/09/546852.aspx

Failing that, might want to download netmon and run some traces / diagnostics, the next link is a bit of a walkthrough as to how they found their TCP/IP problem : https://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/06/18/using-network-trace-to-troubleshoot-intermittent-connectivity-issues.aspx

Failing that, last choice (and maybe hardware guys would say first choice) could be a (network) hardware problem...
0
 
TimotiStDatacenter TechnicianCommented:
What do you test? Just the TCP connection, or login, or even run a query?
Intermittent errors can be DNS issues (forward or reverse).

Tamas
0
 
visionsupportAuthor Commented:
The problem was a faulty network adapter. Thank you for your responses...
0
 
visionsupportAuthor Commented:
It had nothing to do with sql
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now