Post reply

Will SQL-08 accepts extra processor ???

  • January 18, 2010 at 7:29 am

    #141815

    Hi Everybody,

    We are building a new VM box for one of our application which is going to run on SQL Server 2008.

    We are going for Windows 2008-64 bit virtual server and SQL Server 2008-64 bit.

    As per the application vendor recommendation, the server team wants to go for single CPU at this point.But, in future if we have any performance issues, we are planning to add another processor to it.

    Now, my question is will SQL accepts or detects the new processor when it is added ?? or do we need to do any other configuration changes ????

    Will the restart of the server automatically makes SQL to detect the new processor ???

    Please, help me in explaining this to my project members about the issues we can have by this in future.

    Thanks in Advance,

    Sree

  • January 18, 2010 at 9:12 am

    #1104991

    Please anyone help me in understanding this.

  • January 18, 2010 at 9:15 am

    #1104993

    SQL Server will "see" the new processor upon restart.

    You will though, have to make sure you are in compliance with the SQL Licensing in place. If it is per CAL, no change would occur, but if you have a per CPU license, you would need to take care of that.

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • January 18, 2010 at 9:18 am

    #1104998

    Patience, this isn't a chatroom, it's a forum. No need to bump your post after 2 hours. Give it time.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 18, 2010 at 9:26 am

    #1105005

    Thank You Richard,

    I think I got the answer.

    Thanks,

    Sree

  • January 19, 2010 at 1:17 am

    #1105260

    If you want a faster response to your questions, you can try Brent Ozar recommendation, check http://www.brentozar.com/archive/2009/12/i-need-sqlhelp/



    My blog

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

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