Post reply

How or Steps to Allocate a dedicated processors to SQL Server instance

  • March 22, 2012 at 12:03 am

    #391837

    Hi,

    I would like to know the Steps to Allocate a dedicated processors to SQL Server instance.

    For Example i have 8 Cores CPU, in that i would like to have two SQL instances like sysname\sql2008a and sysname\sql2008b. In this i would like to allot sysname\sql2008a with 3 Cores CPU like (2,3,4) and sysname\sql2008b with 3 Cores CPU like (6, 7, 8).

    I would also like to know if my pc has 132 GB RAM, then how two divide the RAM for the two instances.

    Please provide the steps if any otherwise any links to try the same.

    Regards

    Dakshina Murthy

  • March 22, 2012 at 12:55 am

    #1462527

    Before making any changes to the CPU settings, read the following.

    http://msdn.microsoft.com/en-us/library/ms187104.aspx

    http://msdn.microsoft.com/en-us/library/ms186255(v=sql.90).aspx

    To set max and min memory for SQL Instances, read below documentation:

    http://msdn.microsoft.com/en-us/library/ms191144.aspx

    http://msdn.microsoft.com/en-us/library/ms178067.aspx

    Keep in mind, there are other considerations when altering these values, especially the CPU assignments.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • March 22, 2012 at 1:23 am

    #1462534

    Hi,

    thanks a lot for the response, 1 more request is to know is it good or bad to acheieve the same. Or pros and cons on the same

    With Regards

    Dakshina Murthy

  • March 22, 2012 at 1:43 am

    #1462538

    1 more request is to know is it good or bad to acheieve the same. Or pros and cons on the same

    It depends. On the CPU allocation you will need to be 100% sure it is needed. Wrong configuration can have negative effects as well.

    Read more into CPU Affinity on SQL Server.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • March 22, 2012 at 2:06 am

    #1462540

    Ok Thanks, i will read on this.

  • March 23, 2012 at 11:37 pm

    #1463888

    Hi,

    Sorry i have one more query, assuming i have 16 Cores of CPU with 2 SQL instances. For 1 SQL Instance i have alloted 4 Cores and for other i have assinged 8 Cores, if by chance or any ways is it possible to increase the assigning of cores or to extend the cores to either of the instances dynamically (for ex from 4 to 6 and 8 to 10) whenever the request is more.

    With REgards

    Dakshina Murthy

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply