Hi Sidharda,
In our environment, we are looking at is the "splunk_app_db_connect" log in the index _internal to see what connection stats are written. If the DB connection fails, goes into time out or anything else then it is written here. You might check the same in your environment to see the results. From this log, we get the timeout and then we have set an alert that fires emails to us when the time out happens.
Hope this helps.!
... View more