Questions tagged [network]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
247 views

Cluster Validation on Remote Node

I have a 3 Node always availability group: 2 Nodes are In house – Synchronous Mode. 1 Node is remote - Asynchronous Mode. Every now and then the Remote Node loses connectivity and goes offline ...
0
votes
1answer
414 views

Hostname configuration for oracle12c on OL7 VM

I am trying to install Oracle 12c (for learning/studying purposes)on a VirtualBox VM. i have set up a VM with Oracle Linux 7.4 and when I setup the wireless/networking aspects during installation I ...
0
votes
0answers
491 views

Eliminating PostgreSQL/database network latency: PL/Java stored procedure VS. Java code running on localhost

A couple years ago, I learned the hard way that having my Java application sitting on one server, with the database sitting on another, and having complex transactions that issue lots of queries each, ...
1
vote
1answer
2k views

Server Local Connection Provider has stopped listening on local pipe due to a failure

All, I'm looking at a database where every so often, connections to it will fail. The event viewer and SQL Logs have the following error in them: Server local connection provider has stopped ...
2
votes
1answer
819 views

MariaDB Galera stop working without network connectivity

I am running MariaDB Galera cluster whose using mariaDB and 3 nodes(node A, node B, node C). My nodes are placed locally in our office. My problem is if node A/B/C lost network connection, it also ...
1
vote
1answer
2k views

SQL Server Error - The connection is broken and recovery is not possible [closed]

I have a .NET application that connects from A Windows 10 client to an SQL Server 2016 Express database running on Windows Server 2012 R2. Whilst a connection is successfully established, it is ...
10
votes
2answers
4k 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 ...
0
votes
1answer
82 views

Find ClientHost using ClientIP - SQL Server 2014

Recently we started getting alerts as below : EventID 18456 - Login failed for user 'abc'. Reason: Could not find a login matching the name provided. [CLIENT: xx.xx.xx.xxx] EventID 17828 - The ...
2
votes
1answer
2k 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 ...
2
votes
1answer
303 views

How to verify (CHECKSUM or MD5) dataset you received over a network?

I will remotely query mysql database and I want to check that the received dataset matches the table in the host computer. How do you do that? I am fairly new to sql database. I know of Checksum and ...
0
votes
1answer
1k views

How to configure port for listening to traffic meant for PostgreSQL

When setting up postgreSQL with a webserver (all on the same machine), is it critical to have 0.0.0.0:5432 open, or is just 127.0.0.1:5432 enough? Why or why not? Overall, I'm trying to understand ...
0
votes
1answer
3k views

MongoDB Replication - “Failed with No route to host”

Hi, Running MongoDB version 3.4.9 on two separate servers running Centos 7. Trying to add a create a replica set but when ever I try to add a second server I get this error: devshardcfgrs:PRIMARY> ...
1
vote
0answers
186 views

How can I forward odbc/oledbc connection through DMZ

I have an Oracle database separated from our BI system by two network zones (different sides of a DMZ). Company policy dictates that firewall openings may only pass to an adjacent zone. Therefore it ...
0
votes
2answers
3k views

Permission denied with Copy command when using network share

I am running the following Copy command via npgsql (.Net) from a client on the network: COPY work_narcra00_2017_q2.a2_aevent FROM '//BRAHMA//EnvironProcessing//dbprocessfixedasciiimport.tmp' WITH ...
5
votes
1answer
967 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) ...
8
votes
2answers
2k 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 ...
9
votes
2answers
411 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 ...
0
votes
1answer
51 views

Availability groups taking time to change states

I created a 2 node AG setup as a POC today and when I tried to do an automatic failover by stopping the sql server service on the primary node, the one in the secondary went into resolving state and ...
4
votes
1answer
341 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 ...
4
votes
1answer
15k 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 ...
0
votes
1answer
160 views

IP configuration for MultiSubnet AAG setup

Is it a good practice to have all the ip's in a different subnet for an AAG setup as mentioned in the link below? When I wanted to setup a 2 node AAG, the windows team in my office built the cluster ...
3
votes
1answer
405 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 ...
0
votes
1answer
706 views

Availability groups NIC best practices

I am planning to build a new AG setup in my QA environment with the following configuration. What I want to know is, can I have 2 heartbeat networks between the nodes for redundancy also, how many NIC'...
1
vote
2answers
2k views

SQL Server - login failure every day at same time with the service account

I have dozens of SQL Servers, on many different versions. Many of them have an error in the SQL Server error log EVERY DAY at just about 2 am. Login failed for user 'TheDomain\...
0
votes
1answer
627 views

Adding secondary replica from different subnet for AlwaysON

If I understood the configuration of setting up a multi subnet AG setup where 2 nodes are in one datacenter and the 3rd node in another, I was under the assumption that we require 2 listner ip's - 1 ...
1
vote
2answers
2k views

If shared memory, named pipes, TCP/IP network protocols are all enabled which has priority?

If you have all 3 protocols enabled in SQL Server 2016, which protocols are prioritized on the server instance? Couldn't find any specific documentation on this and don't really understand how it ...
0
votes
1answer
413 views

Lots of small SQL statements in SQL Server and measuring network time between DB and Client

I am load testing an application and it appears from New Relic that each transaction executes a significant number SQL statements (approx 250). As we scale up, the service that makes these calls ...
4
votes
1answer
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 ...
1
vote
0answers
133 views

SQL Server and Network considerations to transfer backup file to a shared folder

I'm facing with a situation where backups are being transferred manually to a Shared Folder and my goal is to optimize all of this. What I have to deal with is: 8 Windows 2008 R2 Servers 2 Windows ...
0
votes
1answer
29 views

Problem remotely connecting to MySQL database

Good afternoon everyone. I have 3 servers on 2 different networks, all of which run MySQL. I can use mysql -u<user> -p -h<ip-addr> from server 1 to server 2 and back without a problem. ...
1
vote
2answers
130 views

How to link different databases? [closed]

We are a company doing surveys with different kind of questionnaires. There is a company in Mumbai (MySQL) specialized in Type 1 questionnaire and one in Peru (SQL-Server) specialized in Type 2. I ...
2
votes
1answer
5k views

Attaching / creating database on network drive - Access is denied

I have two computers, computer A is with SQL Server but has no space left, the other is computer B which has free space. I'd like to create a new database on computer B. This is what I've done so far:...
2
votes
1answer
2k views

Is there any impact to changing IP address of MySQL Server?

We are changing the network and the IP addresses will be changing. Will there be any impact to MySQL running on the server? I don't use the IP address to reference the server. Instead I use the ...
2
votes
2answers
4k views

SQL Server Express 2014: Network Access

I have SQL Server Express running on one (virtual) machine running Windows 8.1, but I cannot connect to it from another. I have followed the instructions on https://msdn.microsoft.com/en-us/library/...
3
votes
2answers
2k views

Connecting to MySQL VM remotely (Azure Resource Manager)

I have a VM setup in Azure (running Windows Server 2012 R2) with MySQL 5.7 installed. I am trying to access this using MySQL Workbench - which when running on the server works perfectly. However, ...
1
vote
2answers
207 views

MySQL Replication issues on server placed in different continents

I am running 2 cpanel servers with MySQL Replication set on them, one in france the other in US. Running a database hungary site. Replication was setup to load balance as well as for failover reason ...
6
votes
3answers
21k 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, ...
0
votes
1answer
31 views

Allow access to RackSpace database from Vagrant box

we have two developers using Vagrant (which has it's own internal ip like: 10.0.2.0/24). On RackSpace we have a percona database instance. We would like to allow read/write access to that database ...
1
vote
0answers
89 views

Slow query speed using workstation processed joins with 100 Mbps connection speed?

In a department where they were complaining that a report was being run slowly, I jumped on one of the empty machines there and tried it out. It took a good 6 and 15 seconds to run. Run from a ...
1
vote
0answers
31 views

Sync job issue, maybe network related?

I have a job that syncs rows in a table between a production server and four other servers. The problem is the job runs perfect on three servers, taking less than 2 seconds. On the fourth server, it ...
1
vote
1answer
826 views

High data traffic from MySQL server to web server [closed]

I have one webserver running Magento : Community Edition 1.7.0.2 and a separate machine with MySQL 5.5.42 on it. Both machines are EC2 instances. I am seeing huge unexpected data traffic from the ...
2
votes
0answers
259 views

How to avoid Network issues for SQL Server 2012 AlwaysOn

I have SQL Server 2012 and have setup AlwaysOn for High Availability. The infrastructure is on Azure VM's. After moving to this setup, we are frequently observing Network issues which either causes ...
3
votes
1answer
2k views

SQL Bulk Insert Impersonation issue

I am running Microsoft SQL Server 2012 SP on a Windows Server 2008 R2 Standard SP1 box. The SQL Server service is running as a simple windows domain user (nothing special, no admin rights, etc.) I am ...
2
votes
1answer
656 views

SQL Native Client and network disconnects

Does the SQL Native Client provide support for maintaining a persistent connection over the network at the driver level if there is a momentary network disconnect like a 999 error? Our applications ...
2
votes
1answer
797 views

Fast local backup - Very slow backup via Network

Since last week, i'm having this problem. Backups are taking forever to be done if I make them via Network. If I backup the database to a local disk ( or N'nul' ) it's very fast. It's strange ...
0
votes
0answers
268 views

Startup Oracle Database with an NFS mount on the control file

I currently have an Oracle Database which works just fine on 1 server. I want to share the folder which contains its' control file to another server via an NFS mount. However when mounted I get ...
1
vote
0answers
88 views

SQL AlwaysOn Availability Groups network performance [closed]

Our customers are asking to implement our products while configuring AlwaysOn Availability Groups ( between two FCI with Asynchronic commit ). The DR server is geographically far from the Production ...
8
votes
1answer
2k 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 ...
2
votes
0answers
441 views

Networking (classmate like) website database model

I am working on a project that consists in building a networking website like the Classmate web site. I have proposed a database model based on the social media database model presented on the ...
1
vote
0answers
26 views

Postgres with no clients still chatty on network

This may be a non-issue but I was doing some network monitoring on my Mac and noticed that PostgreSQL (9.4.4) was still sending and receiving packets even when I'm not aware of any clients (localhost ...