SQL Query Execution Time

[vijayansundarar]

I am hoping to use DB Connect to perform an SQL query and log the execution time? (As i can do in an sql client with set timing on).

If this is a possible use case for Splunnk DB Connect, is there some document on how to achieve this?

[ziegfried]

DB Connect logs the execution time of the commands by default. You can use the following search for example to see the execution times of dbquery:

index=_internal sourcetype=dbx_debug (logger=DatabaseQueryCommand (action=executing OR "statement executed")) OR (logger=ExecutionContext "Execution finished") 
| eval query_duration=tostring(duration/1000,"duration")
| transaction thread maxpause=30m startswith=(logger=DatabaseQueryCommand action=executing) endswith=(logger=ExecutionContext)
| table _time query database count query_duration