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 |
|
S_Lakshmi
Starting Member
22 Posts |
 Posted - 2008-06-05 : 15:24:17
|
| Dear all,Is it possible to say sql server 2005 to use this much number of CPU..?For Example I have 1 CPU License of SQL 2005, but I have 2 sockets in my physical box. One socket is having 2 cores. So I want to say the SQL server (2005) to use the 2 cpu's only( i.e Any of one socket)Please advise me to do this. I have one more question,Is there any CPU limitation for SQL 2005 and 2008? If Yes how much cpu we can allot for the SQL 2005 and 2008ThanksLakshmi.S |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-05 : 15:46:11
|
| Yes you can do this either via sp_configure or in the GUI by right clicking on the server and going to properties.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
S_Lakshmi
Starting Member
22 Posts |
Posted - 2008-06-05 : 15:51:16
|
| Perfect!!! Thanks Tara, I come to know the value of SQL Team,Members and Gurus!!!!Thanks againLakshmi.S |
|
|
|
|
|
|
SQL2005 CPU