Cisco Cisco Process Orchestrator 3.0
4-55
Cisco TEO Adapter Guide for Microsoft SQL Server Database
OL-24576-02
Chapter 4 Using Microsoft SQL Server Database Activities
Viewing Activity Instance Information
Viewing Check SQL Server Page Life Expectancy Activity Results
When the Check SQL Server Page Life Expectancy activity is launched, results are displayed from the
from the Operations Workspace activity instance view. The Result display-only page displays the results
of the query for the number of seconds a page will stay in the buffer pool without references.
from the Operations Workspace activity instance view. The Result display-only page displays the results
of the query for the number of seconds a page will stay in the buffer pool without references.
To view Check SQL Server Page Life Expectancy output results:
Step 1
In the Operations workspace, click the Activity Views folder.
Step 2
Use one of the following methods:
•
Highlight the Check SQL Server Page Life Expectancy activity instance, right-click and choose
Properties.
Properties.
-or-
•
Double-click the appropriate activity instance.
The Check SQL Server Page Life Expectancy dialog box displays.
Step 3
Click the Result tab to view the results of the query for the number of seconds a page will stay in the
buffer pool without references.
buffer pool without references.
Figure 4-39
Check SQL Server Page Life Expectancy Properties—Results Tab
The following information is displayed:
Column
Description
Counter Name
Page life expectancy
Counter Value
Number of seconds a page will stay in the buffer pool
without references
without references