Cisco Cisco Process Orchestrator 3.0
4-54
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 Memory Activity Results
When the Check SQL Server Memory 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 total amount of dynamic memory the server is currently consuming.
Operations Workspace activity instance view. The Result display-only page displays the results of the
query for the total amount of dynamic memory the server is currently consuming.
To view Check SQL Server Total Server Memory output results:
Step 1
On the Operations workspace, click the Activity Views folder.
Step 2
Use one of the following methods:
•
Highlight the Check SQL Server Memory activity instance, right-click and choose Properties.
-or-
•
Double-click the appropriate activity instance.
The Check SQL Server Memory dialog box displays.
Step 3
Click the Result tab to view the results of the query for the total amount of dynamic memory the server
is currently consuming.
is currently consuming.
Figure 4-38
Check SQL Server Memory Properties—Results Tab
The following information is displayed:
Column
Description
Target Server Memory
Indicates how much memory SQL Server would like to
have in order to operate efficiently
have in order to operate efficiently
Total Server Memory
Indicates how much the mssqlserver service is currently
using
using