Cisco Cisco Process Orchestrator 3.0

When defining an activity in the process workflow, the properties pane contains property pages that are 
specific to the selected activity. The following table displays the activities that are provided by the 
Microsoft SQL Server Database adapter. 

Bulk Insert SQL Server

Provides source table for data inserted into SQL Server 
database

See 

.

Check SQL Server Buffer HitRate

Queries the percentage of pages that were found in the 
buffer pool without having to incur a read from disk

See 

Check SQL Server Database Space

Queries the total amount of dynamic memory the server is 
currently consuming

See 

.

Check SQL Server Disk Space

Queries the total amount of disk space the database is 
currently consuming

See 

Check SQL Server Locks

Queries the locks performed in the SQL Server database

See 

Check SQL Server Memory

Queries the total amount of dynamic memory the server is 
currently consuming

See 

Check SQL Server Page Life 
Expectancy

Queries the number of seconds a page will stay in the buffer 
pool without references

See 

.

Delete from SQL Server

Deletes data from the SQL Server database using SQL 
command lines

See 

Execute SQL Server SQL Script

Executes SQL script against a SQL Server database