SQL Server Performance

.......Replication.......

Discussion in 'SQL Server Clustering' started by barozai, Apr 16, 2004.

  1. barozai New Member

    We have running ACCPAC on our 2node clustered machine. 100-130 concurrent users access the database (SQL Server 2000).
    Hardware configuration
    Users who make entries have no complaints but the users who work with reports, have complaint for slow reponse, even when they search some an item they claim it takes long time to response.

    Now I want to split reports from our production server. Let me know what should I do?
    Do I need replication if answer is yes then what kind of? or other possible solution.

    Thanks
    Aman
    DBA
    Chenab Ltd

  2. satya Moderator

    How about log shipping, its easy, reliable and ideal to setup.

    I will not recommend Replication setup on above of cluster, not that it will not work but more hassle to maintain.

    Refer to books online andhttp://www.sql-server-performance.com/sql_server_log_shipping.asp link about setting up LS. And this linkhttp://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/en/wc021501/wct021501.asp too.

    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. bradmcgehee New Member

    Another good option (although it will take a lot of work) is to create a cube using Analysis Services and have users report off of it.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  4. barozai New Member

    Thanks Satya...I go through those topic then will discuss with you.

    Aman
    DBA
    Chenab Ltd.
  5. satya Moderator

Share This Page