Created
April 1, 2026 13:36
-
-
Save khigashi/37a01b768e48ffd1162f0c7abc348dea to your computer and use it in GitHub Desktop.
SGE
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT COUNT(*) AS ConexoesAtivas | |
| FROM sys.dm_exec_sessions | |
| WHERE is_user_process = 1; | |
| SELECT | |
| session_id, | |
| login_name, | |
| host_name, | |
| program_name, | |
| status | |
| FROM sys.dm_exec_sessions | |
| WHERE is_user_process = 1; | |
| SELECT | |
| s.program_name, | |
| s.host_name, | |
| s.login_name, | |
| COUNT(*) AS total_conexoes | |
| FROM sys.dm_exec_sessions s | |
| WHERE s.is_user_process = 1 | |
| GROUP BY | |
| s.program_name, | |
| s.host_name, | |
| s.login_name | |
| ORDER BY total_conexoes DESC; | |
| -- Conexões “presas” (sleeping há muito tempo) | |
| SELECT | |
| s.session_id, | |
| s.login_name, | |
| s.host_name, | |
| s.program_name, | |
| s.status, | |
| s.last_request_end_time, | |
| DATEDIFF(MINUTE, s.last_request_end_time, GETDATE()) AS minutos_parado | |
| FROM sys.dm_exec_sessions s | |
| WHERE | |
| s.is_user_process = 1 | |
| AND s.status = 'sleeping' | |
| AND s.last_request_end_time IS NOT NULL | |
| ORDER BY minutos_parado DESC; | |
| SELECT | |
| session_id, | |
| login_name, | |
| status, | |
| open_transaction_count | |
| FROM sys.dm_exec_sessions | |
| WHERE is_user_process = 1; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment