Kbase P108286: How to find out what database does _sqlsrv2 connect to knowing the PID of the _sqlsrv2 process ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/08/2005 |
|
Status: Unverified
GOAL:
How to find out what database does _sqlsrv2 connect to knowing the PID of the _sqlsrv2 process ?
FIX:
There is not a Progress tool which allows to gather this info.
On Windows it's possible to use FileMon and ProcessExplorer from http://www.sysinternals.com to find out a file handle of _sqlsrv2 pointing to a database.
On Unix/Linux "lsof -p <PID>" will show a file handle to a database _sqlsrv2 is connected to.