| SESSIONID |
Session ID for SQL Server |
INT4 |
10 |
0 |
|
MSSSESSIONID
|
|
| LOGINTIME |
The time at which client process logged into SQL Server. |
CHAR |
24 |
0 |
|
MSQPRLGTME
|
|
| HOSTNAME |
Hostname of the application server logged into SQL Server. |
CHAR |
128 |
0 |
|
MSQHOSTNE
|
|
| PROGNAME |
Name of the application program which owns the connection. |
CHAR |
256 |
0 |
|
MSQAPPPROG
|
|
| HOSTPID |
Process ID on app. server |
INT4 |
10 |
0 |
|
MSSHPID
|
|
| CLIENTINFVER |
MSS Session client interface name |
INT4 |
10 |
0 |
|
MSSSESSINTFVER
|
|
| CLIENTINFNAME |
MSS Session client interface name |
CHAR |
64 |
0 |
|
MSSSESSINTFNAME
|
|
| LOGINNAME |
The user name used to log into the SQL Server database |
CHAR |
128 |
0 |
|
MSQUSRNAME
|
|
| NTDOMAIN |
NT domain for the client connected to SQL Server. |
CHAR |
256 |
0 |
|
MSQNTDOMA
|
|
| NTUNAME |
Windows NT user name for the process connected to SQL Server |
CHAR |
256 |
0 |
|
MSQNTUNAME
|
|
| CPUTIME |
CPU time for a SQL session (ms) |
INT4 |
10 |
0 |
|
MSSSESCPUTIME
|
|
| MEMUSAGE |
The pages allocated by the SQL process in procedure cache. |
INT4 |
10 |
0 |
|
MSQPRMEMUS
|
|
| TTLSCHEDTIME |
SQL Server session scheduled time |
INT4 |
10 |
0 |
|
MSSESSCHTIME
|
|
| TTLELAPSEDTIME |
SQL Server session elapsed time |
INT4 |
10 |
0 |
|
MSSESSELPTIME
|
|
| SESS_NUMREADS |
number of reads performed in a session |
DEC |
20 |
0 |
|
MSSSESNUMREADS
|
|
| SESS_NUMWRITES |
Number of writes performed in a session |
DEC |
20 |
0 |
|
MSSSESNUMWRITES
|
|
| SESS_NUMLOGICALREADS |
number of reads performed by a session |
DEC |
20 |
0 |
|
MSSSESNUMLOGRDS
|
|
| TRXISOLEVEL |
MSS Transaction Isolation level |
CHAR |
12 |
0 |
|
MSSTRXISOLEVEL
|
|
| ORIGLOGINNAME |
Original name used to login to SQL Server |
CHAR |
128 |
0 |
|
MSSORIGUSRNAME
|
|