CRM Servers Design RRS feed

  • General discussion

  • Hi all,

    Says I have about 100 over custom CRM reports in my next deployment which involve amount of data. Which server design is best for above senario? 

    a. 2 servers - Front end server, Back end server(included report server)
    b. 3 servers - Front end server, Back end server, Report server

    Friday, August 20, 2010 7:44 AM

All replies

  • If you are going to be running the 100 custom reports frequently than the best performance improvement you can get is to put SRS onto its own server from the SQL server.

    Jerry http://www.crminnovation.com
    Friday, August 20, 2010 2:24 PM
  • Jerry's advice is solid and good.  If you have a heavy BI implementation then you might want to consider seperating reports from the CRM SQL server.  If you really want to optimize the environment, consider setting up a data warehouse and replicate the data needed for reports to that environment.

    Having said that, the fact that you have 100 custom reports does not necessarily mean that you need additional hardware or other.  Standard hardware configurations can handle the load if the reports are optimized for performance.  Items for consideration that will drive your infrastructure decisions include but are not limited to, number of users, number of organizations, workflows, customization, usage, etc. 

    Regards, Donna

    Monday, August 23, 2010 2:24 PM
  • My simple answer is based on the limited information you provided. And as Donna pointed out the number of reports doesn't really matter, what is of concern should be the frequency of reports being run during business hours and the complexity of the reports.
    Jerry http://www.crminnovation.com
    Monday, August 23, 2010 2:44 PM