More in this section
Forums / General Discussions / Best SQL Server settings

Best SQL Server settings

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
1 posts, 0 answered
  1. Foodsleuth
    Foodsleuth avatar
    46 posts
    21 May 2008
    25 Jul 2016
    Link to this post

    We host with Rackspace on an 8gb cloud server.   We've been running pretty well since 2014 but Rackspace had suggested some SQL server tweaks.  I'm hesitant because "if it ain't broken don't fix it" but we do tend to live on the edge, memory wise.  Here is what they suggested.  Does anyone have any thoughts, comments?

    Here are their suggestions:

    I also took a look at SQL and saw that you are utilizing 8 proc's, but
    only have 1 tempdb. You are allowed to have 1 tempdb per core for up to

    I also see that your instance doesn't have a memory cap***. The memory cap
    should be set to about 80% of your overall memory, otherwise SQL will
    attempt to utilize all the memory on the server and won't leave any for
    the OS.

    Lastly I see that your D:, which contains your SQL data,
    isn't configured with the 64k allocation unit setting. This is
    necessary because your current setting is 4k and SQL writes it's data in
    8 byte chunks, so it currently had to write to the disk 16x. This
    setting can only be set during the format stage of a drive. In order for this to occur, you would need to find a place to park your data on your D:.


    **I believe I read that we should NOT cap SQL memory because SF wants to maximize that to enhance site speed.

    Any comments would be appreciated.


    Thank you,


1 posts, 0 answered