August 17, 2015 at 1:31 pm
Hello,
I'm new to SSRS and had a question(s) regarding timing out.
First, I changed the Memory MaxSettings to 20GB.
I left the Query Time-out Setting and Report Execution Time-out setting both at their defaults.
Is it recommended to change or adjust anything else for better performance?
SSRS is on a Server with 128 GB of Memory, SSMS has 60GB allocated to it and like previously mentioned SSRS is maxed out @ 20GB.
The biggest data pull is about 600,000 rows from a table and every other report is much smaller like 80,000 rows.
Thanks for any insight!
August 27, 2015 at 9:45 am
Server Memory just limits the memory consumed by SQL Server Buffer Pool. Memory consumed by Non-buffer pool portion of SQL Server and memory consumed by external dll's loaded into SQL Server memory space is not controlled using Max.
You can take a look at timeout settings in SSRS
Then you can optimize the report to cost less time render
https://technet.microsoft.com/en-us/library/bb522806(v=sql.105).aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply