Solved

MS sql 1433

Posted on 2014-03-27
4
228 Views
Last Modified: 2014-08-06
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
Comment
Question by:visionsupport
  • 2
4 Comments
 
LVL 51

Expert Comment

by:Mark Wills
ID: 39961118
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
 
LVL 17

Expert Comment

by:TimotiSt
ID: 39962415
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
 

Accepted Solution

by:
visionsupport earned 0 total points
ID: 40234326
The problem was a faulty network adapter. Thank you for your responses...
0
 

Author Closing Comment

by:visionsupport
ID: 40243168
It had nothing to do with sql
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to set-up an On Demand, IPSec, Site to SIte, VPN from a Draytek Vigor Router to a Cyberoam UTM Appliance. A concise guide to the settings required on both devices
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question