Skip to main content

Questions tagged [network]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
31 votes
2 answers
14k views

I/O requests taking longer than 15 seconds

Usually our weekly full backups finish in about 35 minutes, with daily diff backups finishing in ~5 minutes. Since tuesday the dailies have taken almost 4 hours to complete, way more than should be ...
Mark S. Rasmussen's user avatar
23 votes
2 answers
53k views

SQL Server: Should we use TCP or Named Pipes or use the default?

When connecting to a SQL Server 2008 R2 from a .NET 4 client application on a different server in the same LAN, one can set three different network protocols: TCP Named Pipes Don't set anything in ...
usr's user avatar
  • 7,340
16 votes
3 answers
24k views

Does disconnecting the network stop a query?

I recently executed an update query against 100,000 records. I realized I'd made a mistake while the query was running and quickly unplugged the network cable. Does the update query stop processing ...
robocop's user avatar
  • 169
16 votes
3 answers
5k views

Will increased network latency cause table locks in MS SQL Server?

If I'm making a single call to a SQL Server database over a high-latency network, will table locks occur due to that latency? Say I query table A for some records, and SQL Server has to return that ...
Evan M's user avatar
  • 353
13 votes
3 answers
5k views

Disconnect from network without stopping the query

I have an opposite problem to Does disconnecting the network stop a query?. I would like to launch a query and disconnect without waiting for results but I don't want the query to stop. Is it possible?...
YuseqYaseq's user avatar
12 votes
1 answer
569 views

Best practices for connecting DBs that are in different geographical regions

We are about to set up SQL Servers in different countries. We need to link them, but we don't have to have a direct link (as in linked server). In other words, they can be loosely coupled. Is it ...
IamIC's user avatar
  • 576
10 votes
2 answers
6k views

Does taking transaction log backups every 15 minutes consume more disk space than log backups every 6 hours?

In our environment the network storage is low on space. At the same time I would like to make sure that we take transaction log backups every 15 minutes instead of current every 6 hours. My question ...
SqlNovice's user avatar
  • 644
9 votes
2 answers
482 views

Is network traffic encrypted when writing remote backups using SQL Server TDE?

They do say there is no such thing as a “stupid question”, so here goes: I understand that SQL Server Transparent Data Encryption (TDE) encrypts data at rest, so that your database files (.mdf) and ...
SQLServerVillain's user avatar
9 votes
2 answers
4k views

PostgreSQL network compression for result set?

I was reading about network compression with PostgreSQL to see if there was anything that offered that which would permit big result sets to transfer over the wire to remote web servers. It seems ...
Evan Carroll's user avatar
  • 63.9k
8 votes
1 answer
3k views

Does RSS Profile have an effect on SQL Server with NUMA setup?

I'm curious whether the RSS Profile which is default NUMAStatic on Windows 2012 R2 could/should be changed for SQL Server with a NUMA setup. Has anyone done performance benchmarks on high load SQL ...
Jens D.'s user avatar
  • 1,229
8 votes
1 answer
1k views

Can SQL Server be configured to backup to a network share through a separate NIC?

We're in the process having our SQL Server instances backup to a network share, but our network admins want to try and divert the bandwidth from the backups through a different network segment. I was ...
JohnS's user avatar
  • 83
7 votes
4 answers
39k views

Changing IP address of SQL Server 2008 R2

I would like to know if there are any dangers or relevant precautions before changing the IP address of a SQL Server 2008 R2 box. We have built a virtual PC with Windows Server 2008 R2 and SQL Server ...
Paul's user avatar
  • 1,453
7 votes
3 answers
36k views

Does UDP Port 1434 need to be open for named instances with static TCP?

I have built a named instance which is running on a static port, 50101. The network guys have opened the port on the firewall to allow incoming connections. I have asked them open UDP port 1434 too, ...
Molenpad's user avatar
  • 1,784
7 votes
2 answers
28k views

Client application disconnects from database/s it is connected to after 10 minutes of inactivity

When working with pgAdmin 4 (and actually, several other programs that act as clients to the database), the connection to the server disconnects after some 10 or 15 minutes of inactivity. One coffee ...
joanolo's user avatar
  • 13.5k
7 votes
1 answer
4k views

Network design considerations for Oracle Database Appliance

With the introduction of Oracle Engineered Systems the DBA is moved somewhat closer to infrastructure design decisions, and expected to at least have some opinions of the network design requirements ...
Roy's user avatar
  • 1,060
7 votes
1 answer
272 views

Multi-homed SQL Server with High Availability Groups

We have two servers (SQL-ATL01, SQL-ATL02) that make up a Failover Cluster, each running as part of a SQL Server High Availability Group (HAG). Each server has two network cards. One is a 10Gbit card ...
Josef's user avatar
  • 201
7 votes
1 answer
19k views

Communication link failure for some queries to linked server

I am seeing the following error in SSMS (server has Windows Server 2008 and Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 installed) when running some queries against the linked server, in ...
slachterman's user avatar
6 votes
2 answers
3k views

Are CNAME aliases for connection strings a good idea?

To be very flexible and move database to different servers more easily, we came up with the idea of using an alias per database. So by simply changing a DNS entry, we can route all queries to a ...
SwissCoder's user avatar
5 votes
3 answers
14k views

Full Back up over to Network failed due to unknown network error 59

I am recently seeing the Unknown Netowrk Error 59 which saves the full back ups to a file share on some of the servers . The back ups happens at different times. Ola Halengren scripts are being used ...
SQL_NoExpert's user avatar
  • 1,061
5 votes
2 answers
11k views

What happens to a transaction if the network connection fails?

What happens to a transaction when the client connection is lost. Example the client is a web application code that starts a transaction to a remote server instance. The client sends the sql code to ...
Jim's user avatar
  • 771
5 votes
1 answer
13k views

What are the ports and directionality of the TCP connections used in MySQL replication?

I wanted to know how replication works in mysql. Both slave and master have mysql server running say on port 3306. Slave acts like a client and master acts like a server. Does slave always bind to ...
Android_enthusiast's user avatar
5 votes
1 answer
1k views

Static DAC ports for named instances

Using SQL 2016 Enterprise Edition The default instance will listen on 1433 and the DAC port will listen on TCP 1434. SQL Browser will listen on UDP 1434. Any subsequent named instances will get a ...
Gavin Harris's user avatar
5 votes
1 answer
27k views

How to configure SQL Server Port on multiple instances?

I have a server called SQLDWDEV01, with 2 instances: default and UAT. To the default instance that uses port 1433, everything works fine. However, the UAT instace, which I configured according to ...
Marcello Miorelli's user avatar
5 votes
1 answer
4k views

Where do I find the meaning of TdsInputBufferError numbers?

We are having some sporadic connection errors on some of our SQL servers. I did some searching and found out about the Ring Buffer in SQL 2008 R2 and found some information, but I am not entirely sure ...
Jim's user avatar
  • 245
5 votes
3 answers
2k views

Using SQL Server on separate networks

I have a bunch of SQL Servers installed on Windows2008R2. Currently, each windows server has two NIC's, each connecting to separate networks. In other words, each server appears on each network. ...
datagod's user avatar
  • 7,101
5 votes
2 answers
7k views

Will matching SQL Server network packet size to mtu increase performance

We have recently upgraded our production facility to sql server 2017, and moved to clusterless availability groups. There is a primary, a secondary on site, and a remote secondary. We were ...
JohnH's user avatar
  • 433
5 votes
1 answer
17k views

command or query to ping SQL server

I have 2 windows 7 machines on a very high security domain one acting as a server, the other as a client. Each box has a SQL Server Express 2005 database and application "A", however I'm only using ...
user avatar
5 votes
1 answer
2k views

SQL Server 2014/2016 (Win2K12R2) and Winsock limits - how to cope?

We're experiencing a problem with connections to SQL Server and after a week of digging through I was able to pinpoint it to Winsock limits. Here's the description: We have SQL Server 2014 (and 2016) ...
Philip P.'s user avatar
  • 151
5 votes
2 answers
5k views

Storing IPv4 and IPv6 hosts and networks

I have to store the IPv4/v6 address and networks(CIDR notation) in a MySQL database. Unfortunately, I am constrained to use Mysql. So, I'm looking for the equivalent of the inet type of PostgreSql. :...
Yohann's user avatar
  • 159
5 votes
1 answer
4k views

Ports necessary for Oracle 11g Replication across a firewall?

We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
Letholdrus's user avatar
5 votes
0 answers
3k views

Once more about SQL Server virtual accounts

Let me reboot my question on SQL Server virtual accounts permissions The (same) MSDN article on the same version 2012 of SQL Server "Configure Windows Service Accounts and Permissions" ...
Gennady Vanin Геннадий Ванин's user avatar
4 votes
3 answers
8k views

How do I monitor bandwidth used by SQL Server on port 1433?

I have a single server running a .NET web application and a SQL Server database (2008 Standard). I'm planning to move the database onto a separate server but in order to provision the network hardware ...
QFDev's user avatar
  • 789
4 votes
2 answers
846 views

Backup SQL DataBase to C$

Another simple SQL backup question from me.... I've got a SQL Server database running on SSMS 2008 and am trying to configure some backup jobs. I am now seemingly fine with backing up and restoring ...
cprlkleg's user avatar
  • 281
4 votes
2 answers
12k views

Cannot give NT SERVICE\MSSQLSERVER permissions on network drive

I have an SSIS package that I would like to run as a job. The flat file source sits on Server A while the package and job sit on Server B. When I run the job that executes the SSIS package I get an ...
Cody Francis's user avatar
4 votes
1 answer
455 views

Always On Availability Groups Network Configuration in AWS

I have set up a 3-node, multi-subnet Always On Availability group in AWS, which seems to be working well. However, each node only has a single network adaptor with 3 IP addresses assigned to it (1 ...
Matt's user avatar
  • 53
4 votes
2 answers
17k views

Best practices for service name / aliases in tnsnames

I have this idea that service names / aliases given to connections descriptors in a tnsnames.ora (not the one in the server that dblinks use, but the one for the public) file should in no way be ...
Tulains Córdova's user avatar
4 votes
1 answer
13k views

Analysing SQL Server Network I/O

A frequent request I get from clients is to help figure out what queries or clients are making the largest contribution to SQL Server saturating an Ethernet link. Ideally I'd look at some counters ...
James Lupolt's user avatar
  • 4,268
4 votes
2 answers
5k views

TdsInputBufferError not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers

I've got an issue with SQL Server. The value of TdsInputBufferError is not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers. This happens randomly, once or twice a week, ...
Softlion's user avatar
  • 221
4 votes
1 answer
6k views

What ports does SQL Server use on Linux?

What ports does SQL Server use on Linux? I want to be sure I'm forwarding the ports required when I run it in a container.
Evan Carroll's user avatar
  • 63.9k
4 votes
1 answer
576 views

How fast can I pull data through a SQL Server client connection?

What is the highest throughput possible? Has anyone seen anything above 25MB/sec? I've been trying to figure out what is even possible. I know there are tuning parameters like packet size, and rows ...
Steve Durham's user avatar
4 votes
2 answers
700 views

How to backup MS SQL Server databases off-site?

Microsoft SQL Server supports backing up to remote network locations only by means of UNC names the SQL Server (and user account it's running under) has access to. Is it possible to create backups ...
Paul-Sebastian Manole's user avatar
4 votes
1 answer
7k views

Does Oracle run queries to completion after SQLdeveloper disconnects?

The query is a CREATE TABLE t as SELECT .....; statement. Can I reliably count on Oracle to complete this after I disconnect? After I re-connect, how can I check on the status of this query?
Ming K's user avatar
  • 175
4 votes
1 answer
3k views

MSSQL Mirror Configuration Troubleshooting: Witness server forcibly disconnecting every 100 seconds

I recently set up a three servers running MSSQL Server 2016 in a high safety synchronous mirroring configuration. Right now, everything is working normally. Any changes made in the principal are ...
Rick's user avatar
  • 41
4 votes
1 answer
491 views

Is this a sane model for a network provisioning system?

I'm sketching out a model for a network setup, where I have the following conditions: There are multiple nodes which contains a number of switches each. Each switch has multiple services, which may ...
ChristianF's user avatar
3 votes
3 answers
10k views

Connection to localhost dramatically slower than to network server

I have an Excel VBA application that connects to a SQL Server 2008 R2 database through ADODB. When I'm on the network at work, the connection is almost instantaneous. When I am at home working with ...
Head of Catering's user avatar
3 votes
2 answers
2k views

SQL Server Configuration Manager 2012 - unable to set IP All = No

I have a 4-node SQL Server 2012 SP1 cluster, and under Network Configuration -> TCP/IP -> Protocol (tab), I am able to switch Listen All from Yes to No. However, when I hit OK (or Apply), I get the ...
user avatar
3 votes
2 answers
7k views

How do I limit Oracle to use specific ports?

I've built a new Oracle 9iR2 instance on a Windows 2003 32-bit cluster. Of course, it's version 9i for reasons out of my control. Several application servers connect to this instance, and each opens ...
Nick Chammas's user avatar
  • 14.7k
3 votes
1 answer
7k views

Remove an IP address from server config

What is the safe way to remove an old IP address from SQL Server configuration? The scenario is, I have a server with 2 NIC's that should have been configured for teaming but weren't at the time SQL ...
squillman's user avatar
  • 1,207
3 votes
1 answer
3k views

Difference between Session Timeout and Heartbeat in always on

What is the difference between Session Timeout and Heartbeat in always on... My Network is laggy and i get frequent connection timeout error on error logs and also at the I see missed heartbeat errors ...
SqlNovice's user avatar
  • 644
3 votes
1 answer
2k views

SQL Server connection fails over VPN

I have an OpenVPN network consisting of VPN server (Linux), client (win8) and SQL Server (win 2008 server, SQL Server 2005), I'm trying to (of course) connect client to server. When I try to connect ...
Sasa B's user avatar
  • 31