Post reply

Memory requirements for SSRS

  • June 17, 2008 at 9:09 am

    #208464

    Hi All,

    I have been looking into the memory requirements of SSRS on top of SQL Server. I beleive that 2gb is seen as the minimum you should add on top of your current config to run SSRS.

    I read an article saying that you cannot limit the memory which SSRS uses, you can only do it at the instance level of SQL which contains the databases. Does this mean that you could feasibly run a seperate instance of SQL containing the reporting services databases that you then limit the memory usage on?? And does the reporting services service look at the maximum amount of memory allocated to the sql instance that stores its databases and cap itself using that limit?

    I guess what im trying to ask is what methods can you use to stop SSRS running off with all the memory allocated to SQL.

  • June 17, 2008 at 9:42 am

    #829896

    You can limit the database engine that the SSRS databases are running on, but that will not limit SSRS for using memory. SSIS runs as a service and within IIS. There is currently no solid way to limit the amount of memory the service and IIS will consume using SSRS (other than virtualization or moving it to it's own hardware).

    Here is the good news - unless you are rendering rediculously large reports, it is not that bad on memory. I have had SSRS alone on a server with 1gb of memory with 50 users and never came close to a memory issue.

  • June 17, 2008 at 9:52 am

    #829903

    Michael Earl (6/17/2008)

    You can limit the database engine that the SSRS databases are running on, but that will not limit SSRS for using memory. SSIS runs as a service and within IIS. There is currently no solid way to limit the amount of memory the service and IIS will consume using SSRS (other than virtualization or moving it to it's own hardware).

    Here is the good news - unless you are rendering rediculously large reports, it is not that bad on memory. I have had SSRS alone on a server with 1gb of memory with 50 users and never came close to a memory issue.

    well that definately is good news!! I will only be potentially developing a reporting solution for 20/30 users which is not heavily used and is not a massive dataset. On top of that they have 32gb RAM in their server which has plenty room for expansion so should easily cover it. Thanks Michael 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply