sql_response probe query

Products

• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)

Issue/Introduction

what value will sql_response probe update in the table_id corresponding to QOS_SQL_RESPONSE qos:-

1) If there is query timeout

2) DB or connectivity is not available

 

 

Environment

Release : 20.3

Component : UIM - SQL_RESPONSE

Resolution

The QOS_SQL_RESPONSE  Response time from the database, as returned from the executed query.

You can run the below command at your environment :-

select * from s_qos_data where probe ='sql_response'
select * from s_qos_data where probe ='sql_response'and target like  '%railtool%'
select * from <select RN_QOS_DATA_0311 as per the o/p from above command > ;
select * from <RN_QOS_DATA_0311> where sampletime >= yyyy-mm-dd( set the date of today)