Cisco Cisco Process Orchestrator 3.0
4-51
Cisco TEO Adapter Guide for Microsoft SQL Server Database
OL-24576-02
Chapter 4 Using Microsoft SQL Server Database Activities
Viewing Activity Instance Information
Figure 4-35
Check SQL Server Database Space Properties—Results Tab
The following information is displayed:
Viewing Check SQL Server Disk Space Activity Results
When the Check SQL Server Disk Space 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 disk space the database is currently consuming.
Operations Workspace activity instance view. The Result display-only page displays the results of the
query for the total amount of disk space the database is currently consuming.
To view Check SQL Server Disk Space 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 Disk Space activity instance, right-click and choose Properties.
-or-
•
Double-click the appropriate activity instance.
The Check SQL Server Disk Space dialog box displays.
Column
Description
File name
Name of the database file
File Type
Type of transaction file (e.g., Log, Data)
Size MB
Amount of available database memory
Used MB
Amount of used database memory
Used percentage
Percentage of used database memory
Autogrow
Yes or No indicates whether the database space grows the
database size beyond the limits of the available disk space
on the drives for which files are defined
database size beyond the limits of the available disk space
on the drives for which files are defined