Questions tagged [connections]
One or more connections to a database or database server. For questions about *establishing* a connection, use the **connectivity** tag instead.
20
questions
5
votes
3
answers
5k
views
MySQL general log
Is there away to have MySQL dump its log to a remote MySQL server?
I would like to audit MySQL connections but I don't want the server to store all the information local on its own hardware.
- 53
39
votes
3
answers
34k
views
Is a Postgres long-running query aborted if the connection is lost/broken?
If I open a connection to Postgres and issue a long-running query, and then break the connection (e.g., kill the client process that opened the connection), will the long-running query continue to run,...
- 2,203
25
votes
2
answers
65k
views
Max number of user connections
In SQL Server 2012 Standard edition, I know that the max number of user connections is 32,767. What should I do as a DBA if I am heading towards this number?
Currently there are 30,000 user ...
- 1,401
6
votes
2
answers
9k
views
sys.sp_reset_connection. Why theres a lot of them ?
Theres a lot of questions here on DBA EXCHANGE. But none of them can help me.
I have 2 problems:
1) Using sp_whoisactive, I found lots of sys.sp_reset_connection;1( I know they are ...
- 7,436
5
votes
1
answer
6k
views
Proxy authentication for PostgeSQL
The following seems likely to be a fairly common situation, but I haven't seen any solutions.
I have a PostgreSQL database containing views that are specific to the $user, in order to restrict data ...
- 1,720
94
votes
4
answers
253k
views
How to drop all connections to a specific database without stopping the server?
I want to drop all connections (sessions) that are currently opened to a specific PostgreSQL database but without restarting the server or disconnecting connections to other databases.
How can I do ...
- 1,242
78
votes
3
answers
68k
views
What is the difference between a connection and a session?
What is the difference between a connection and a session and how they are related?
- 5,353
21
votes
5
answers
45k
views
Azure SQL Database "Login failed for user" in application, but works fine in SSMS
I wanted to try out the contained database users feature on Azure SQL Database V12, but I'm having a problem authenticating that seems odd to me.
I created a database called Classifier. I added my ...
- 313
19
votes
4
answers
51k
views
How can I check if connection to Sql Server is encrypted?
In SQL Server I can "Force Encryption" in protocols settings. If I leave that set to "No" any client can still require encryption.
Can I somehow see what connections to the ...
- 305
5
votes
1
answer
5k
views
Find source of spids that show no hostname
I have a busy SQL 2012 server where connections to one particular database (using the same SQL login) don't show a "hostname", and I need to find out which box (of several) these connections are ...
- 10k
4
votes
1
answer
11k
views
PostgreSQL: Using the .pgpass file
I have been reading up on the .pgpass file, but I can’t get it working for me.
My .pgpass file looks something like this:
127.0.0.1:5432:accounts:fred:p@55w0rd
I set the privilege to 0600 (this is on ...
- 2,869
3
votes
0
answers
698
views
SQL Server Management Studio creates 18456 login error using registered server group
I have been using "Local Server Groups" registration for quite a while now with SQL Server 2008 Management Studio.
I have created a group with 5 registered servers. They are registered using ...
- 4,797
2
votes
2
answers
3k
views
DAC connection error
I'm having a problem connecting using my dedicated admin connection in SQL Server 2014. I just wanted to test it out.
I have DAC enabled in sp_configure. I have performed RECONFIGURE.
I have ...
- 671
1
vote
1
answer
445
views
What database name should I use to connect Tomcat with my database
I have a dump file in Oracle and I should use Oracle 12c.
I installed it, created a database and imported the dump into a tablespace,
but I can't connect it with my application on Tomcat.
I'm lost ...
- 21
1
vote
1
answer
2k
views
Multi-thread Informatica connections to use different processors on target database server
See this question for reference.
Can data streams from Informatica to SQL Server be multi-threaded?
I've got most of my problem figured out. I've split up the one large table into four smaller ...
- 2,092
1
vote
1
answer
681
views
SQL Server Error "Database 'mssqlsystemresource' does not exist."
On Linux, whenever I run use mssqlsystemresource to get access to Resource Database, I get an error. How do I resolve this.
1> use mssqlsystemresource
2> go
Msg 911, Level 16, State 1, Server ...
- 64.2k
1
vote
2
answers
4k
views
Connect to remote EC2 Postgresql database
I want to setup a connection between a webserver and a PostgreSQL 9.3 server. Both are hosted on Amazon EC2 servers and are part of the same security group. I can't get the connection working. The ...
- 138
0
votes
0
answers
62
views
Can't connect to database - The specific error code is 1006
Yesterday I entered data into databases - it was several million records. Everything went ok, I was happy. But today, when I want to connect to the database, I get this error.
The problem now is that ...
- 45
0
votes
2
answers
2k
views
MySQL performance tuning related connection
I am running openstack cloud and it use mysql database which is MariaDB 10.1.30
I am sometime seeing connection reset from multiple clients, to trying to find out what is going on in database, I am ...
- 231
0
votes
1
answer
3k
views
Same session ID(with same SQL text) but 3 different connection ids
I was listing out all sessions open in my sql server 2016 production server.
I have issues with slow performance and i have been investigating it.
I see that i have several same sessions(session_id) ...
- 1,335