I have databse size of 500 gb and 2000 reports upon it, what hardaware configuration do i required for SSRS 2005 and SSRS 2008. and how many cooncurrent users can access it with out affect with that configuration. Regards, Navin Navin.D http://navind.spaces.live.com/

Hi Navin, SQL Server Reporting Services(SSRS) does not cost many disk capacity. SSRS stores the report definition in the report server catalog database. Usually, the report definition is small(e.g. only a few KBs). The major cost is CPU resource and memory resource, as the SSRS engine need to retrieving data, processing, and rendering the report. It will load the report into memory buffer. "how many cooncurrent users can access it with out affect with that configuration.", this is based on the report the users access. If the report contains many data, and there is a lot of aggregate cacluation(or other similar actions, e.g. group, sort) in the report , the performance will be weak. To determine the hareware requirement for SSRS, please see: http://technet.microsoft.com/en-us/library/ms143506.aspx If there is anything unclear, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

I have databse size of 500 gb and 2000 reports upon it, what hardaware configuration do i required for SSRS 2005 and SSRS 2008. and how many cooncurrent users can access it with out affect with that configuration. Regards, Navin Navin.D http://navind.spaces.live.com/

It depends, too little info provided. We have RAID10 for data file and RAID(1) Mirroring for LOG files.... Tempdb is also located on separate array.Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/