The IN_DB_UTIL_SP_SESSIONS_DISPLAY stored procedure is used to fetch and print the current session attributes for the specified identifier(s).
It can be used to display the current session details for each of the three supported identifiers, IN_DB_UTIL, SYNC, and UPGRADE.
The session attributes for each identifier is stored in the IN_DB_UTIL_SESSION_ATTRIBUTES table.
| Parameter | Description | |
|---|---|---|
| IDENTIFIER | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | Specifies the identifier for which to display the session attributes. | |
| Options |
IN_DB_UTIL SYNC UPGRADE ALL (SYNC and UPGRADE) |
|
| DEBUG | Type: | INPUT |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display the procedure name during execution. | |
| Options | YES NO |
|
| V_RETURN_VAL | Type: | RETURN |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description | Specifies whether the execution of the procedure was successful or
not. 0 = SUCCESS 1 = ERROR |
|
Examples
EXEC IN_SESSIONS_DISPLAY @V_IDENTIFIER, @V_DEBUG; EXEC IN_SESSIONS_DISPLAY 'ALL' EXEC IN_SESSIONS_DISPLAY 'SYNC' EXEC IN_SESSIONS_DISPLAY 'UPGRADE' EXEC IN_SESSIONS_DISPLAY 'IN_DB_UTIL'
Example Output
Example output from the IN_DB_UTIL_SP_INDEX_MAINTENANCE procedure.
Procedure Name: IN_DB_UTIL_SP_SESSIONS_DISPLAY Current Database Time: 2022-05-02 16:14:40.9266667 Current Activity for the IN_DB_UTIL identifier: IN_DB_UTIL STATUS: EXECUTING IN_DB_UTIL OPERATION: IN_DB_UTIL_SP_INDEX_MAINTENANCE IN_DB_UTIL START TIME: 2022-05-02 16:14:40.6400000 IN_DB_UTIL MAX TIME: 2022-05-02 17:14:36.6133333 IN_DB_UTIL MAX_MINUTES: 60 IN_DB_UTIL BATCH SIZE: 50000 IN_DB_UTIL OBJECT: inuser.IN_AUDIT_OBJ IN_DB_UTIL SUBOJECT: AUDIT_OBJ_IDX03 IN_DB_UTIL FILEGROUP: SECONDARY IN_DB_UTIL MAX_DOP: 4 IN_DB_UTIL FILLFACTOR: 95 IN_DB_UTIL SPID: 129
Example output from a database schema upgrade using the IN_DB_UPGRADE_SP_UPTIME_STEPS procedure.
Procedure Name: IN_DB_UTIL_SP_SESSIONS_DISPLAY Current Database Time: 2022-05-02 18:08:18.6870000 Current Activity for the UPGRADE identifier: UPGRADE STATUS: EXECUTING UPGRADE OPERATION: IN_DB_UPGRADE_SP_SCHEMA_UPGRADE_7230_7403 UPGRADE CALLED BY: IN_DB_UPGRADE_SP_UPTIME_STEPS UPGRADE START TIME: 2022-05-02 18:08:18.6500000 UPGRADE MAX TIME: 2022-05-02 19:08:18.0870000 UPGRADE MAX_MINUTES: 60 UPGRADE OBJECT: inuser.IN_INSTANCE_PROP UPGRADE SUBOJECT: INSTANCE_PROP_IDX_04 UPGRADE FILEGROUP: SECONDARY UPGRADE MAX_DOP: 0 UPGRADE FILLFACTOR: 95 UPGRADE SCHEMA_TARGET: 7.9.0.0 UPGRADE SCHEMA_BASE: 7.1.5.2 UPGRADE SCHEMA_VERSION: 7.1.5.2u UPGRADE IS_SYNC_UPGRADE: YES UPGRADE SPID: 125