Informatica Administrator for Enterprise Data Catalog > Monitoring > Monitor SQL Data Services
  

Monitor SQL Data Services

You can monitor SQL data services on the Execution Statistics view on the Monitor tab. An SQL data service is a virtual database that you can query. It contains a schema and other objects that represent underlying physical data.
You can view information about the SQL data services included in an application. To monitor an SQL data service, expand an application in the Navigator and select the SQL Data Services folder. A list of SQL data services appears in the contents panel. The contents panel shows properties about each SQL data service, such as the name, description, and state.
When you select an SQL data service in the contents panel, the contents panel shows the following views:

Properties View for an SQL Data Service

The Properties view shows general properties and run-time statistics for an SQL data service.
When you select an SQL data service in the contents panel of the Properties view, you can view the general properties and run-time statistics.
General Properties for an SQL Data Service
You can view general properties, such as the SQL data service name and the description.
Statistics for an SQL Data Service
You can view run-time statistics about connections and requests for the SQL data service. Sample statistics include the number of connections to the SQL data service, the number of requests, and the number of aborted connections.

Connections View for an SQL Data Service

The Connections view displays properties about connections from third-party clients. The view shows properties such as the connection ID, state of the connection, connect time, elapsed time, and disconnect time.
When you select a connection in the contents panel, you can abort the connection or access the Properties view and Requests view in the details panel.
Properties View
The Properties view in the details panel shows the user who is using the connection, the state of the connection, and the connect time.
Requests View
The Requests view in the details panel shows information about the requests for the SQL connection. Each connection can have more than one request. The view shows request properties such as request ID, user name, state of the request, start time, elapsed time, and end time.

Aborting a Connection

You can abort a connection to prevent it from sending more requests to the SQL data service.
    1. Click the Execution Statistics view.
    2. In the Domain Navigator, expand a Data Integration Service.
    3. Expand an application and select SQL Data Services.
    The contents panel lists the SQL data services in the application.
    4. Select an SQL data service.
    The contents panel displays multiple views for the SQL data service.
    5. Click the Connections view.
    The contents panel lists connections to the SQL data service.
    6. Select a connection.
    7. Click Actions > Abort Selected Connection.

Requests View for an SQL Data Service

The Requests view displays properties for requests for each SQL connection.
The Requests view shows properties about the requests for the SQL connection. Each connection can have more than one request. The view shows request properties such as request ID, connection ID, user name, state of the request, start time, elapsed time, and end time.
Select a request in the contents panel to view additional information about the request in the details panel.

Aborting an SQL Data Service Connection Request

You can abort an SQL Data Service connection request. You might want to abort a connection request that hangs or that is taking an excessive amount of time to complete.
    1. Click the Execution Statistics view.
    2. In the Domain Navigator, expand a Data Integration Service.
    3. Expand an application and select SQL Data Services.
    The contents panel displays a list of SQL data services.
    4. Select an SQL data service.
    5. Click the Requests view.
    A list of connection requests for the SQL data service appears.
    6. Select a request row.
    7. Click Actions > Abort Selected Request.

Viewing Logs for an SQL Data Service Request

You can download the logs for an SQL data service request to view the request details.
    1. Click the Execution Statistics view.
    2. In the Domain Navigator, expand a Data Integration Service.
    3. Expand an application and select SQL Data Services.
    The contents panel displays a list of SQL data services.
    4. Select an SQL data service.
    5. Click the Requests view.
    A list of requests for the SQL data service appears.
    6. Select a request row.
    7. Click Actions > View Logs for Selected Object.

Virtual Tables View for an SQL Data Service

The Virtual Tables view displays properties about the virtual tables in the SQL data service.
The view shows properties about the virtual tables, such as the name and description. When you select a virtual table in the contents panel, you can view the Properties view and Cache Refresh Runs view in the details panel.
Properties View
The Properties view displays general information and run-time statistics about the selected virtual table. General properties include the virtual table name and the schema name. Monitoring statistics include the number of request, the number of rows cached, and the last cache refresh time.
Cache Refresh Runs View
The Cache Refresh Runs view displays cache information for the selected virtual table. The view includes the cache run ID, the request count, row count, and the cache hit rate. The cache hit rate is the total number of requests on the cache divided by the total number of requests for the data object.

Viewing Logs for an SQL Data Service Table Cache

You can download the logs for an SQL data service table cache to view the table cache details.
    1. Click the Execution Statistics view.
    2. In the Domain Navigator, expand a Data Integration Service.
    3. Expand an application and select SQL Data Services.
    The contents panel displays a list of SQL data services.
    4. Select an SQL data service.
    5. Click the Virtual Tables view.
    A list of virtual tables for the SQL data service appears.
    6. Select a table row.
    Details about the selected table appear in the details panel.
    7. Select the Cache Refresh Runs view.
    8. Click View Logs for Selected Object.

Reports View for an SQL Data Service

The Reports view shows monitoring reports about the selected SQL data service.
When you monitor an SQL data service, the Reports view shows reports about the SQL data service. For example, you can view the Most Active SQL Connections report to determine the SQL connections that received the most connection requests during a specific time period.