none
Recommended SQL Server settings for Project Server 2013 RRS feed

  • Question

  • Hello,

    I am wondering if all the recommended SQL Server settings for Project Server 2010 (e.g. as described here http://pwmather.wordpress.com/2012/09/14/projectserver-optimisations-for-sql-server-and-ps2010-databases-sp2010-msproject/ ) still apply for Project Server 2013. Are there any changes?

    Cheers,
    Axel

    Tuesday, April 23, 2013 8:21 AM

Answers

All replies

  • Hi Axel,

    All these performance optimization configurations, thanks to Paul for compiling them in one place, are well applicable to Project Server 2010 environment.

    however if i were you, i wouldn't go for these configuration until they have been reflected on subsequent technet articles. and so far none of these configuration are mentioned for Project Server 2013 relevant documentation on technet.

    http://technet.microsoft.com/en-us/library/ee662108(v=office.15).aspx

    Also other then CLR configuration, common langauge runtime, most of the configurations are not applicable due to DB architectural change of Project server 2013.

    hope this helps.


    Khurram Jamshed - MBA, PMP, MCTS, MCITP ( Blog, Twitter, Linkedin )

    Tuesday, April 23, 2013 9:29 AM
  • Nice thing about Project Sever 2013 is that all of the best practice SQL maintenance, except for backups, are built in to the database. Think about all these databases running in Microsoft Datacenters for Project Online. If they needed a lot of manual attention, that would be a nightmare! So on-premises installations benefit from the re-engineering effort for Project Online.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG


    Tuesday, April 23, 2013 3:46 PM
    Moderator