Visibility into the Publishing Queue

[AriWeissman]

• The Session Performance Report
• How to interpret the report

The Session Performance Report

The Session Performance report provides visibility of all publishing jobs for an organization. This lets you know which jobs are ahead of your requests and helps you get a sense of timing for when your jobs will be complete.

You can find the report under the ‘Publishing’ section in the Reports area of the CMS. 
https://cms.crownpeak.net/[YourInstance]/DXM/#/reports/publishing/session-performance

If you have questions or suggestions on how to continue to improve this report, add a comment at the bottom of the page.  

How to interpret the report

Value	Description
<maxrows>	An integer value for the maximum number of rows of session summary data you wish to have returned. There is a hardcoded internal limit if 2000 rows.  You can enter any value between 1 and 2000
<days>	An integer value for the number of days of history for which you are interested.  There isn’t a hard-coded limit for this but the results would be limited by the maximum of 2000 rows anyway.
activeSessionCount	Number of active sessions (e.g. not “Initializing …” or “Starving”)
pendingSessionCount	Number of sessions that are either “Initializing …” or “Starving”)
activeSessionThreadCount	Number of unique session and pub server groups that are active.  This is the count of top level session processing threads across all pub servers.
activePubThreadCount	Number of PublishQueue records whose “totalDependencies state” shows active but less than 80 and are associated with an individual pub server. (This item is intended more for New Publishing when multiple threads per session per server are active).
activePubServerCount	Number of distinct publishing servers currently processing active PublishQueue records.
activeSessionActiveAssetCount	Count of all assets across all session that are actively processing.
activeSessionPendingAssetCount	Count of all assets across all session that are waiting to be processed.
sessionId	The id of the session
userId	The id of the user who initiated the publishing session
userName	The name of the user who initiated the publishing session
pqPriorityTotal	The total number of “priority” assets for the session based on the count of records in the PublishQueue table.
pqPriorityPending	The number of “priority” assets for the session in the PublishQueue table whose “state” value is less than 80.
pqDepTotal	The total number of “dependency” assets for the session based on the count of records in the PublishQueue table.
pqDepPending	The number of “dependency” assets for the session in the PublishQueue table whose “state” value is less than 80.
activeStage	The current “active_stage” value for the publishing session.
activeAction	The current “active_action” value for the publishing session.
activeMessage	The current “active_message” value for the publishing session.
startDate	The “start_date” value of the publishing session.
endDate	The “end_date” value of the publishing session. (May be null if not yet set)
timeDur	The current duration of the publishing session. (May be null if “end_date” not yet set)
assetsPerSecondRate	Calculated rate based on current number of processes assets and the current duration (May be 0 of “end_date” is not yet set or nothing yet processed).
estimatedTimeToFinish	Calculated rate based on current assetsPerSecondRate and the total number of pending assets (May be null of “end_date” is not yet set).
files	The current number of files for the publishing session.
processedPriority	The current “ProcessedPriority” value for the publishing session.
totalPriority	The current “TotalPriority” value for the publishing session.
processedDependencies	The current “ProcessedDependencies” value for the publishing session.
totalDependencies	The current “TotalDependencies” value for the publishing session.