Monitoring the Activity of SAS Servers

Using the SAS OLAP Server Monitor

Access the SAS OLAP Server Monitor

The SAS OLAP Server Monitor in SAS Management Console enables you to perform the following tasks:

connect to SAS OLAP Servers
refresh the server list, the connections list, and cube metadata
monitor sessions and queries
close sessions
stop SAS OLAP Servers

Follow these steps to access the SAS OLAP Server Monitor:

Start SAS Management Console. If necessary, choose a metadata profile that has the Administer permission and the Advanced role.
In the navigation tree, expand the Monitoring node and the SAS OLAP Server Monitor node.
Right-click the name of the logical OLAP server, and select Connect. Enter your user ID and password at the prompt.
When you are connected, right-click the logical server name and select an action.
When you are finished using the monitor, right-click the name of the logical OLAP server and select Disconnect.

Note: Online Help becomes available when you select SAS OLAP Server Monitor in the navigation tree. [cautionend]

View OLAP Server Sessions and Queries

To view the active SAS OLAP Server sessions and queries, follow these steps:

Access the SAS OLAP Server Monitor.
Under Monitoring and SAS OLAP Server Monitor, expand the Logical OLAP Server node and double-click the OLAP Server. The right pane displays a list of active OLAP sessions. In the Session Owner column, if the server is not secured, the owner is displayed as <unknown>.
To list the active queries for a session, double-click the session in the tree. For each active query, SAS Management Console displays the type of query (unspecified, multidimensional, or flattened) and the MDX expression.

Refresh the List of OLAP Servers or Server Connections

After you have accessed the SAS OLAP Server Monitor, you can do the following:

To refresh the list of SAS OLAP Servers, right-click SAS OLAP Server Monitor and select Refresh.
To refresh the list of connections to a SAS OLAP Server, expand the Server Manager node, the SAS Application Server node (for example SASMain), and the Logical OLAP Server node in the navigation tree. Then right-click the OLAP server name, and select Refresh.

Note: For information about refreshing the cube metadata for one or more cubes in the SAS OLAP Server's cube cache, see the SAS Intelligence Platform: Application Server Administration Guide. [cautionend]

Top of Page