Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
barretld
Starting Member
22 Posts |
 Posted - 2009-03-06 : 11:41:44
|
| How do I know that all 4 processors hyperthreaded to 8 are being used? Another words, did we pay for the license to have all used and are we using all or does it just look like we are using all processors? I think if I can see all 8 processors then we are using all 8 processors, your thoughts? |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-03-06 : 12:55:36
|
| Check your server model number and CPU number and go to vendor website for server and CPU specifictaion. For Windows you pay per socket, no matter CPU is Hyperthreaded or have multi-cores. Yes, all 8 processors can be used. I know limitations are imposed on Windows 2000 standard edition where you cannot use beyond 4 CPU. If you know your Windows edition it is easy to figure out how many CPU it supports. There are some utilities available free on internet like "CPUZ" which gives you CPU information eg, HYPERTHREAD, CORES, L1, L2 cache etc.. The results are accurate for 32-bit and x-64 systems but there are some inaccuracies in output with IA-64 processors. |
 |
|
|
|
|
|
Processors being utilized?