SQL Server Performance

Is the Need to be a Replicate DB for Reporting ??

Discussion in 'Performance-Related Article Discussions' started by Nilesh_Deshmukh, Jun 8, 2007.

  1. Nilesh_Deshmukh New Member

    Hello ,

    In Large Project , How u can generate the Report from DB. Lots of user access same DB, reporting also based on the same DB. whether we get the fast access of report?? is It Possible ? or What u think abt it ? Or it may be a separate DB fr only REporting??


    Welcome for u'r valuable reply's

    Thanks

  2. ndinakar Member

    generally there is a reporting db against which the dev team can run queries and on which reporting queries are also run. and the reporting db is refreshed every night or however your schedule permits. so you are only looking a day's old copy.

    ***********************
    Dinakar Nethi
    SQL Server MVP
    ***********************
    http://weblogs.sqlteam.com/dinakar/

Share This Page