Solved

Limiting SQL Server 2008 R2 CPU useage

Posted on 2014-03-13
4
759 Views
Last Modified: 2014-03-15
Hello Experts. I am a SQL Server novice in need of assistance. We have an HP DL585 G7 server with 4 AMD Opteron 6276 processors, 16 cores a piece. The server has 384GB of memory. Windows Server 2008 R2 Enterprise SP1 and MS SQL Server 2008 R2 Enterprise are installed. Right now SQL Server is using all 64 cores. As many of you know, paying for 64 cores is outrageous, almost $700,000! Is there away to tell SQL Server to only use 16 cores? I've glanced through the server configuration. In the Processor section, I see 8 NumaNodes (0-7) with 8 CPUs listed under each. Do I simply select 2 NumaNodes and check all 8 CPUs underneath them to get 16 cores? Does it matter which 2 I choose? How do I determine which affinity to use? I'm new at this so please be gentle. I appreciate your time!
0
Comment
Question by:CMWinters
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
arnold earned 500 total points
ID: 39928034
Within the configuration of the database server, you can set affinity which means you can specify how many processors can be used.

Which licensing model are you going for? If you are buying individual user/device cals, you should not care about how many processors are being used.
If you are buying a per processor license, then the affinity is the way to restrict.
note per processor means per processor no matter the number of cores:
download.microsoft.com/download/2/7/0/270B6380-8B38-4268-8AD0-F480A139AB19/SQL2008R2_LicensingQuickReference-updated.pdf
 
You would select the processor/ and the cores within.
0
 

Author Comment

by:CMWinters
ID: 39930433
Thanks for your information. I didn't know we could still buy box product. We had a MS select agreement quote for 2012 that forced core pricing. I've found a couple of places I can still buy the per processor version.
0
 
LVL 77

Expert Comment

by:arnold
ID: 39930447
Double check with your select vendor, or go through the MS Licensing site.  I believe you can buy a per processor from them as well.   not sure what per core pricing you went through. You may have instead of 4 processors, counted the individual cores instead.
The select license is better as the cumulative license offers additional discounts within the select that an external purchase will not be counted towards.  

You might want to consider buying the 2012 SQL R2 version check with MS/vendor whether it would provide licensing for the older versions (2008).
0
 
LVL 6

Expert Comment

by:chlebi
ID: 39930978
Just wanted to add: be careful as with certain licenses it is calculated per physical core - that means even if you limit via CPU affinity it is calculated on all cores.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Creating Alerts in sql sever 2 25
Restrict result set 1 33
Benefits of SMB Fileshare 3 62
T SQL Update Table from another table 5 42
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now