We have configured Replication from Prod -- Report Server
SQL Report Server is having 40 GB memory. We have set SQL server Max Memory to 24 GB.
The report server configured to fetch the data from Prod server and we are not yet Pointed reports to Report server.
My report server hitting 95% memory some times. Is this because report server is fetching the data from prod and placing the report builder(will use buffer pool on report server) will impact some load on report server?
When we rebuild the indexes on report server , the report server using very less memory.. it is fine one week and after that again we are facing memory issue.
we cant run daily index maintenance task on report server database.