Frequently asked questions for the SQL adapter

Does the SQL adapter automatically close down its connection?

Explanation: The SQL monitor adapter does not close a connection because it has to keep monitoring the target database.

Does TrueSight Orchestration use the SQL adapter to update the metrics table?

Explanation: No, the SQL adapter does not need to be installed or active to communicate with the metrics database.

How can you log connections to Oracle using the adapter and connections made to the metrics table?

Explanation: You can track connections via the adapter by turning the adapter to debug logging. You can track connections to the metrics database by turning the metrics to debug logging. Logging metrics is one of the many components of a peer and can be logged in Grid Manager. Logging depends on exactly what and how you need to track.

Are there any housekeeping tasks that you need to do to clean up dead connections from TrueSight Orchestration?

Explanation: Connections need to be cleaned if something goes wrong, like connectivity issues or a system failure. Normally, no manual cleanup is required.

Related Knowledge Base Articles

SQL Monitor Adapter errors when data type is
:Knowledge Article ID: 000054260 (Legacy ID:KA313710)

How do I configure the SQL Actor Adapter for MS SQL Server 2005?: Knowledge Article ID:000027323 (Legacy ID:KA309333)

Can the SQL Actor adapter handle stored procedures?:

Knowledge Article ID:000014957 (Legacy ID:KA310588)

Atrium Orchestrator: SQL Actor Adapter Configuration: Knowledge Article ID:000067377 (Legacy ID:KA309496)

Domain login fails for SQL Actor adapter: Knowledge Article ID:000060565 (Legacy ID:KA347629)

Was this page helpful? Yes No Submitting... Thank you