Questions tagged [network]
The network tag has no usage guidance.
177
questions
1
vote
2
answers
2k
views
Can't use SQL Server database on a networkpath
I am working on a project for a very long time now. It's a .NET application which works with a SQL Server database (.mdf, LINQ to SQL). Now I am almost finished and wanted to run some tests.
But ...
- 249
2
votes
2
answers
11k
views
How to connect to Oracle 11g using "Navicat for Oracle"?
My Oracle 11g Enterprise Manager runs like this:
I have taken the following screen-shot after my Oracle installation has been completed:
I have the following Oracle-related services running:
I am ...
user16250
7
votes
1
answer
18k
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 ...
- 373
1
vote
1
answer
2k
views
Possible reasons for slow BLOB updates in Oracle?
We have an application that transfers .bmp images as BLOBs to an Oracle table. One of the users of the app has complained that it is taking 2-3 seconds to transfer each image. Each image is ~1.2Mb. I'...
- 433
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. :...
- 159
1
vote
1
answer
2k
views
How does disabling a network protocol affect SQL server performance
The SQL server 2000 process info monitor displays about 100 processes that use a mix of Named Pipes/TCP-IP and (integrated authenticated) users. I was wondering if:
disabling Named pipes - or - TCP-...
- 441
3
votes
1
answer
2k
views
Network issues with sql server
There are two servers on co-location. First is Windows Server Standard 2008 R2 SP1. Second is Windows Server 2012 + Sql Server Standard 2012 SP1.
First server has a task with a report against tables ...
- 131
5
votes
1
answer
16k
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 ...
edw
4
votes
2
answers
826
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 ...
- 181
1
vote
1
answer
2k
views
High Network usage on SQL Server port [duplicate]
Possible Duplicate:
Find out what queries are causing the biggest amount of network traffic
We are getting over 90 Mbps from SQL Server to each web servers on port 1433.
We are using connection ...
- 95
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 ...
- 1,060
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 ...
- 1,187
1
vote
1
answer
90
views
Disabling protocols using SQL Server Configuration Manager or ENDPOINTs
Besides SQL Server Configuration Manager, it's possible to disable access to specific SQL Server protocols by disabling the default ENDPOINTs, but what's the difference between the two options?
Are ...
- 2,323
23
votes
2
answers
48k
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 ...
- 7,250
4
votes
1
answer
12k
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 ...
- 4,238
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 ...
- 151
2
votes
3
answers
9k
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 ...
- 629
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 ...
- 245
2
votes
1
answer
392
views
database connection time expired issue
I have a server machine and four client machine for database connectivity.
I installed sqlexpress 2008 in server and one machine and all remaining systems, they have connected the database through ...
- 179
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 ...
- 14.6k
2
votes
1
answer
729
views
PostgreSQL: Trouble accessing another server's Data via NFS
Background:
I'm working on a 2-node High Availability PostgreSQL database cluster for my company. The system has a master/standby setup where the standby takes over the duties of the master when the ...
- 568
1
vote
1
answer
2k
views
MySQL Cluster over WAN: Best Architecture Options?
My company is looking at a multi-data-centre solution for high-availability, fun, and profit.
We have businesses across the planet, with the need for MySQL database clustering solutions that can keep ...
- 175
4
votes
2
answers
4k
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, ...
- 221
0
votes
2
answers
1k
views
Creating a New Database Across a Network with SQL Server 2008 R2
I appreciate that the above should not be done ('Creating a New Database Across a Network with SQL Server 2008 R2') for all of the reasons outlined here but a client wants to know how to do this and ...
- 357
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 ...
- 1,465
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. ...
- 7,071
12
votes
1
answer
550
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 ...
- 576