Questions tagged [session]
The session tag has no summary.
65 questions
0 votes
0 answers
45 views
Some of our backup jobs have begun to hang, and quietly cause some issues
We’ve been using SQL Server Maintenance Solutions for decades, but recently I’ve started encountering issues with missing log backups. There are no error messages, and the jobs are still scheduled, ...
4 votes
1 answer
724 views
What are the ramifications of long open sessions?
I'm looking after a SQL server having long open sessions. There is no open transaction, or actively running query (requests) for this session. What is the reason why a session may remain open? Is it ...
- 3,602
1 vote
1 answer
313 views
Understanding last_request_start_time and last_request_end_time in sys.dm_exec_sessions
I've been working with the sys.dm_exec_sessions dynamic management view and I'm hoping to gain a better understanding of the last_request_start_time and last_request_end_time columns. From the ...
- 1,239
0 votes
0 answers
130 views
Mismatch Between Transactions and Sessions in DMVs sys.dm_tran_session_transactions and sys.dm_tran_database_transactions
I've been working with several Dynamic Management Views (DMVs) in SQL Server to monitor transactions, specifically sys.dm_tran_session_transactions, sys.dm_tran_database_transactions, and sys....
- 1,239
0 votes
1 answer
195 views
Indexing of hash-value column vs INT IDs for session tokens
Let's say: your application should use session IDs generated with a CSPRNG, which shall authenticate your user sessions your system uses PHP 8.2 and MariaDB 10.6 Which of the approaches below ...
- 163
0 votes
1 answer
1k views
PG Admin Sessions
I have a frontend written in MS Access that connects to a Postgres backend through ODBC. Sometimes the number of sessions reaches 100 and at that point I get an "ODBC call failed" error. I ...
0 votes
1 answer
1k views
Best approach for basic PHP DB session data storage
I've decided to switch from PHP's native session management based on $_SESSION to use my own, due to many different issues I've had so far with PHP's possibilities, and also because I'm building an ...
- 163
0 votes
1 answer
139 views
Valid characters for PostgreSQL session parameters
Where can I find the list of characters which are valid for PostgreSQL configuration parameter names? By trial and error I found that '.' and '_' are valid, but ':' isn't. Quoting doesn't seem to help....
- 173
0 votes
0 answers
482 views
See Max Simultaneous Sessions Per User
In an effort to set a reasonable sessions_per_user profile setting for shared database accounts or other non-unique account (ie. an account an application uses to log into the database for all app ...
- 335
1 vote
0 answers
4k views
Many sessions AWAITING COMMAND
I need some guidance please. An application is going through migration and the processes seem to be quite cpu intensive. CPU utilisation on the server is very high - in the 90's. The headblocker ...
- 447
0 votes
0 answers
123 views
What establish a session?
As an analyst I'm running multiple queries on our Oracle ERP via Power Query (Power BI). Now, I hit some form of session limit on my default profile's session limit. How do you evaluate how many ...
3 votes
1 answer
1k views
Function in same Session become increasingly slow when run multiple times concurrently
PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit Client is Data Grip and same behavior from my report server which uses ...
- 33
0 votes
2 answers
690 views
How to connect to specific session id & serial# ? Blocked sessions
I have blocked sessions and see which session is blocking them, having session_id and serial#. Is it possible to connect to such session? How? Background: using V$SESSION_BLOCKERS I see sessions are ...
- 167
-1 votes
1 answer
119 views
Using session variables to generate GROUP information
We want to know whether the given approach is correct or not. I understand that there might other and presumably better and more optimized ways of accomplishing the task. But it is a curiosity that I ...
- 438
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,345