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 |
|
clement.store
Starting Member
25 Posts |
 Posted - 2011-04-07 : 05:24:59
|
| Dear all,I wonder if I m working on some heavy calculation with TSQL. Would SQL server be automatically leverage all the 12 cores in the server? Or some changes need to be done...? Has anyone written TSQL on a 12 core SQL server?Config:Windows SQL server 2008 Standard 64bit.Windows 2008R2 64 bitCPU: Xeon : X5650 / E5649 / E5645thanksClement |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-07 : 08:55:39
|
| SQL Server is multi-processor aware, it can parallel when it feels that a query will benefit from it.I've written code on a 64-core SQL Server, 12 is low these days--Gail ShawSQL Server MVP |
 |
|
|
clement.store
Starting Member
25 Posts |
Posted - 2011-04-07 : 10:02:21
|
| Thanks Gail. But I just wonder if the six-core would fit SQL server 2008...? Not sure if multiple cores from quad CPUs rather than 6 core CPUs would make any difference...could find doc. to support this... |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-07 : 10:38:26
|
| No major difference. Cores = CPUs on one chip. Makes a difference in licensing...--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Dual six-core processors TSQL