I have a DB which is used by multiple software/apps.
The number of connections on my DB spiked from 1000 to 1500 yesterday for 30 mins and then came back to 1000. The average no. of connections remain around 1000 at any given day. Same happened today at same time as yesterday.
How may I know now the details of connections that were established at that time yesterday and today so that I may know which software/app caused the spike?