SQL Server Performance

Reporting Services overhead

Discussion in 'SQL Server Reporting Services' started by Jeffrey_D_York, Sep 14, 2005.

  1. Jeffrey_D_York New Member

    Good Morning-

    I was wondering if anyone has any performance metrics on what kind of additional load that Reporting Services puts on a SQL server. I do realize that this is a broad(vague) request as this depends I would think on whether or not the IIS services are loaded locally and what kind of user load/ad hoc reporting is done. I have next to no experience(I loaded on a test box last year) wit hReporting SServies, but one of our new apps needs to be rolled out with it and I want to make sure I am not going to kill our other apps that are backended by our SQL server. Thanks!!
  2. satya Moderator

    What is the database growth?
    How many users will be connected simultaneously?
    What is the server configuration?

    It is not advised to keep all SQL Server, IIS & Reporting server on same machine as it tends to degrade performance. So you need to seperate IIS & Reporting services to a seperate box and then use SQL Server as a dedicated box by keeping up the schedule of database optimization jobs that will take care of database queries efficiently.

    http://www.sql-server-performance.com/wp_msrs_02.asp for informtaion on performance tuning of RS.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Jeffrey_D_York New Member

    Satya-

    Thanks for the info. It should only be about 20 Concurrent users using reporting Services at any one time, But I did find a separate box to break off the IIS and Reporting Services portion. Shouldn't grow the DB much at all.

Share This Page