I'm relatively new to the MSSQL world, and we have a newly installed reporting server that is in an availability group. The first time any report is executed, it seems to take about 30-40 seconds to bring the results back. I know this is some sort of connection issue because subsequent execution of the reports are quick. If the connection is idle for some time, it seems to try and make the connection again and takes the 30-40 seconds.
Is this normal behavior and is there a work around?