Questions tagged [network]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
31 views

PostgreSQL: Save roundtrips / Network performance

For my work I often have to to large selects loading a lot of data. The connection happens with JDBC driver and high fetch size. This is not a problem when working directly on the server of the ...
0
votes
0answers
16 views

Is Mysql faster if on separate VPS (with cores dedicated to it) or on the same but faster VPS [closed]

Note: This is not a question about capacity planning The problem: Lately traffic on my wordpress site grew and so did my cpu usage. mainly by mysql (roughly 2/3 of the cpu is used by mysql and the ...
1
vote
0answers
41 views

DNS CNAME for a SQL Managed Instance (Azure)

I currently have an on Prem SQL Instance that has a DNS CNAME set up against it via our On Prem DNS Server. I am looking to move this server to an Azure Managed Instance and I want to point the DNS ...
1
vote
1answer
74 views

Why changing the order of network protocols does not make any sense?

All I want to do is to connect to SQL Server though Named Pipes without using an explicit way like NP:ServerName because mentioned approach works. I want to connect through Named Pipes using just ...
0
votes
0answers
19 views

Mysql 8. Event call Stored Procedure with Transaction to Federated tables never finish ESTABLISHED connection until timeout

We have a Mysql server which connect to remote Mysql Federated tables and copy data to local tables. For several databases it works fine, but the new one did not close connection after Transaction ...
0
votes
0answers
31 views

SQL Server: Logging for SQLNCLI10

I have a 3rd-party application that uses SQLNCLI10 to connect to our SQL Server. Every once in a while, it will throw an error complaining that it can't connect to the database. Personally, I think ...
0
votes
0answers
30 views

Adding login of a pc on the network - Microsoft SQL Server Management Studio 2014

I have a small office network and I am trying to add new logins for the other PCs on Microsoft SQL Server Management Studio 2014 (all computers are Windows 7). I cannot seem to find the other ...
-1
votes
1answer
35 views

Connecting database from another network [closed]

We have a database in our server at work, and we can connect the database if we are connected to same network with server. I want to connect from my home. How can I do this? I have tried couple of ...
0
votes
0answers
30 views

Oracle - Dispatchers parameter overwrite shared_servers and max_dispatchers?

I'm not understanding how to use these parameters. For example, when I set dispatchers parameter with (PROTOCOL=TCP) (dispatchers = 4) don't matter if shared_servers parameters is 0, the oracle ...
2
votes
1answer
39 views

Troubleshooting high network traffic between primary and secondary replicas

We have two SQL server hosts. There are about 12 availability groups, where the primary replica is on the "primary" host and the secondary replicas are on the "secondary" host. Now, for one reason or ...
0
votes
2answers
44 views

ASM - How the asm search the disks and where is this parameter from?

I'm a begginer in Oracle ASM and when I will create a diskgroup the ASM shows me this parameter: Where is this parameter from? I don't remember set any parameter with this name. I know that usually ...
0
votes
1answer
78 views

Oracle - Why create several service_name in service_names parameter?

SERVICE_NAMES specifies one or more names by which clients can connect to the instance. The instance registers its service names with the listener. When a client requests a service, the listener ...
2
votes
1answer
122 views

Need SQL Server VLAN advice.. is it best practice to have all SQL Servers under 1 VLAN/network zone? [closed]

Looking at the network placement of my SQL Servers. Looking for answers: Is it a best practice to have all SQL Servers in 1 or 2 VLANs within your businesses network? however, if so, wont there ...
0
votes
1answer
55 views

Two physical servers with sql server on same network

IS there a way I can remotely access sql server DB having two different servers in the same network/public IP? The first Server is configured to listen to 1433 port but we make the connections using ...
3
votes
0answers
99 views

TCP Resets when using psycopg2

I'm trying to do a simple health check for keepalived and other services via a python script and psycopg2 library. All seems to be alright, until I close the connection, at which point a packet with ...
0
votes
2answers
450 views

How to connect to sql server with dynamic IP Address

I have installed sql server express edition 2014 on my machine. And I am connecting to it with CRM using my local machine's IP address. The problem here is my IP address allocated to my machine is ...
0
votes
0answers
805 views

Help with Connecting to SQL Server using Oracle SQL Developer

I am trying to connect to SQL Server using Oracle SQL Developer. I was able to get the SQL Server JDBC installed on SQL Developer and am able to see the SQL server Tab on the Connections page. I have ...
1
vote
1answer
47 views

Multi-Subnet AlwaysOn: Is Routing and Remote Access always required?

Context I'm setting up a 2-node AlwaysOn Availability Group (SQL Server 2017 Enterprise) with the following setup: Existing DC+DNS (One NIC: 10.20.11.1/255.255.254.0) New AG-Node1 (One NIC: 10.20....
6
votes
2answers
562 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 ...
-1
votes
1answer
77 views

How to use mariadb instead of sqlplus using sqlnet configuration files

currently I can access a database on a remote server using Oracle's instant client "sqlplus" The connection is dependent on a couple of configuration files in: $ORACLE_HOME/network/admin which are ...
0
votes
1answer
23 views

Domain Controller on Multi Subnet Always on Availability Group

This is will be my first big project. We have 4 Replica Always on availability group with 3 Replica on site and another replica offsite (different subnet) the File share witness will be placed on ...
1
vote
1answer
348 views

Cluster IP's under Access Point for Administering the Cluster

When adding the cluster IPs under Access Point for Administering the Cluster, do we only include IPs for the public subnets, or do we also need to include an IP for the private subnet(s)? This ...
1
vote
1answer
45 views

Why does a query on a local instance with local database files cause NETWORK_IO waits?

I have followed this tutorial to get the wait stats of a particular query while it is 'in flight' using extended events. Whilst the tutorial refers to an index rebuild, I just did a select statement ...
3
votes
1answer
1k 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.
1
vote
1answer
610 views

Disabling IPV6 on Always on availability group

In our environment we only have one network adapters for the Replicas and IPV4 is being used. By default the IPV6 is also enabled. My question is will there be any problems if I unchecked IPV6 from ...
1
vote
1answer
42 views

One instance, four clients, one is slow

We have a small office setup with one Windows Server 2012 running SQL Server 2016 Express. The database is hosting files for our accountant software. This is a multi module software that runs ...
2
votes
1answer
262 views

How to access a shared folder from Windows Cluster IP [closed]

This is a very strange question, but I am trying to access a Windows file share from a SQL server cluster IP, that resides on that server. In the past and on other servers I have, I get connected to ...
0
votes
1answer
562 views

Cannot connect to SQL server through SSMS from other machine after IP change [closed]

There was an ip change on the sql server and after that I cannot connect from other machines ssms but can connect locally . The firewall is disabled on the server and moreover its listening on port ...
0
votes
1answer
308 views

Difference between an endpoint and a port in SQL Server

While I know why are ports used in SQL Server, I wonder what is the difference between an endpoint and a port. Ports can be managed using Configuration Manager, is it also possible to manage endpoints ...
1
vote
1answer
423 views

Which TCP port to choose for SQL Server to listen to for security reasons? [closed]

I know that the default TCP port for MS SQL Server is 1433 and it is better to change that for some security reasons. But I want to know which port is better to choose instead of 1433 for SQL Server ...
1
vote
0answers
19 views

Problem about listing network instances on SSMS

I have a problem about listing network instances on SSMS. When I look at the Network Instances on SSMS, it shows only local server instances. By the way, it shows all the instances on the network ...
3
votes
2answers
1k 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 ...
7
votes
1answer
130 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 ...
1
vote
1answer
549 views

Connection's MAC address randomly changes on Windows 10, then stops

Because reasons (tm), we want to identify the client's MAC address on SQL Server side (local network, not about security, enables a very convenient feature in way transparent for applications). We do ...
5
votes
1answer
462 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 ...
2
votes
1answer
166 views

Dynamic Ports are being set to different ports

On one of our instances of SQL Server (12.0.5571.0 if you really need to know) we use multiple IP addresses to connect. 127.0.0.1 - Dynamic Port set to 0. No static port set 172.16.0.5 - IP Address ...
0
votes
2answers
328 views

Is it possible to redirect queries to another server?

I want to set up a server that redirects queries. It would receive incoming SQL Server traffic, redirect to the actual SQL Server, and return results back to the client. Is this possible? What are ...
4
votes
2answers
4k 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 ...
2
votes
0answers
57 views

How to set up SQL Server online with public Wi-Fi

I am doing a school project where I have to set up a SQL Server database for my teammates to work on. Currently, I am able to host the server online with my home router, but I am facing problems ...
1
vote
1answer
200 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
319 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
416 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
1k 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
657 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 ...
0
votes
1answer
1k 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
3k 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
64 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
241 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
944 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 ...