AriWeissman
Director of UX
Director of UX

Visibility into the Publishing Queue

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.

 

 

 

Labels (1)

Can't find what you are looking for?

Find Answers

Search our DXM Forum to find answers to questions asked by other DXM users.

Ask a Question

No luck? Ask a question. Our Product and Support teams are monitoring the Forum and typically respond within 48 hours.

Ask a Question