Cisco Cisco Process Orchestrator 3.0

Pagina di 106
 
4-49
Cisco TEO Adapter Guide for Microsoft SQL Server Database
OL-24576-02
Chapter 4      Using Microsoft SQL Server Database Activities
  Viewing Activity Instance Information
Step 4
Click the Instance tab to view the display-only properties of the database instance. 
Step 5
Click the Message tab to display any warnings or general messages associated with the output of the 
query. 
Step 6
Click the Paged Output tab to display the results of the SQL statement in a data grid.
If there is no data generated, the tab displays "No data displayed." Use the navigation arrows along the 
bottom of the tab to navigate multiple pages of results. 
Viewing Check SQL Server Buffer HitRate Activity Results
When the Check SQL Server Buffer HitRate activity is launched, results are displayed from the from the 
Operations Workspace activity instance view. The Result display-only tab displays the results of the 
performance metrics query from the SQL server database.
To view Check SQL Server Buffer HitRate 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 Buffer HitRate activity instance, right-click and choose 
Properties.
-or- 
  •
Double-click the appropriate activity instance.
The Check SQL Server Buffer HitRate dialog box displays.
Step 3
Click the Result tab to view the results of the performance metrics query from the SQL server database. 
Field
Description
Number of rows affected
Indicates how many rows were added, modified, or deleted 
in the execution of the SQL statement. A value of zero is 
set if no modifications to the data in the database were 
made.
Warning or informational messages
Displays any messages related to the performance of the 
database instance