none
Project Server in SharePoint Farm - Database settings and Best Practices RRS feed

  • Question

  • Hi,


    On our Project Server instance, we noticed that Database Server is taking a lot of load even when there are no users accessing the server i.e., even on weekends and holidays.


    Is there any particular reason for the DB server to behave in this way? (we see the server is using 90% of memory all the time)
    We use the instance only for Project Server application.
    Are there any best practices specific to Project Server to improve the performance of the server?


    Thanks in advance.

    Regards Prasad

    Tuesday, October 9, 2012 7:53 AM

Answers

  • Hi Prasad--

    Please see below technet article for Minimum requirement for SQl server for database server in a farm :
    http://technet.microsoft.com/en-us/library/ee683978.aspx

    Database maintenance plan:
    http://technet.microsoft.com/en-us/library/cc973097.aspx

    Recommended database maintenance tasks for Project Server 2010 databases include the following:

    • Checking database integrity

    • Defragmenting indexes by either reorganizing them or rebuilding them

    • Setting the fill factor for a server

    • Monitoring database size to determine whether to grow or shrink databases

    You can have your database administrator to find the jobs that are using the database transactions.

    Please download the white paper that describes recommended database maintenance tasks for SharePoint 2010 products.:
    http://www.microsoft.com/en-us/download/details.aspx?id=24282

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Tuesday, October 9, 2012 8:02 AM

All replies

  • Hi Prasad--

    Please see below technet article for Minimum requirement for SQl server for database server in a farm :
    http://technet.microsoft.com/en-us/library/ee683978.aspx

    Database maintenance plan:
    http://technet.microsoft.com/en-us/library/cc973097.aspx

    Recommended database maintenance tasks for Project Server 2010 databases include the following:

    • Checking database integrity

    • Defragmenting indexes by either reorganizing them or rebuilding them

    • Setting the fill factor for a server

    • Monitoring database size to determine whether to grow or shrink databases

    You can have your database administrator to find the jobs that are using the database transactions.

    Please download the white paper that describes recommended database maintenance tasks for SharePoint 2010 products.:
    http://www.microsoft.com/en-us/download/details.aspx?id=24282

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Tuesday, October 9, 2012 8:02 AM
  • Thank you Amit.


    I will go through the links.


    As per the link, we may experience Reporting database adhoc burst load.


    ---> Off-hours burst load because of subscription push reporting

    Could you please explain what is meant by "load due to subscription push reporting"?


    Regards Prasad

    Tuesday, October 9, 2012 10:12 AM
  • Hi Prasad,

    You may need to have your database administrator to find if any subscription push reporting is created. For more information, Please see below article:
    http://technet.microsoft.com/en-us/library/ms152503(v=sql.105).aspx
    http://technet.microsoft.com/en-us/library/ms151741(v=sql.105).aspx

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, October 10, 2012 6:09 AM