Reporting Services Configuration Recommendations.

  • Morning, I’m currently in the process of setting up and configuring our reporting services on our SQL-2k servers. We currently have about 400 user who will be accessing reports and about 50 developers that will be developing reports for them.  Does anyone have any recommendations on the best way to configure reporting services to be able to handle this type of workload?

  • You may want to consider using linked reports and then creating folders based on some method to segment the 400 users.   Linked reports make sense anyways since you have greater flexibility in creating mulitple modifications on an existing report without having to modify the master report.  

    You should also consider hosting on multiple servers (if possible) and segment according to some logical grouping of users.

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

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