September 1, 2008 at 11:42 pm
Hi Folks,
I found on SQL feature comparison on microsoft website, the number of CPU that it can run is 4 CPUs. I have an 8 CPU 64 bit machine and am running SQL server 2005 Standard 64 bit. When I go into the server options on the CPU tab it tells me SQL is running 8 processors. How can this be when SQL 2005 Standard is only suppose to run 4.
the article I refer to is http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Also I thought the maximum worker threads for sql was 255. In the server options my option says 0. Why would that be -it is a new instance and I have not changed the setting.
September 2, 2008 at 7:40 am
You must have dual-core CPU's and SQL Server recognizes each core as a processor, while the max processors allowed is based on sockets not cores.
Normally in SQL Server settings 0 means use the max, which is why max worker threads is set to 0.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 3, 2008 at 7:19 am
Dual Core (as above) or hyperthreading is enabled. Check the BIOS/CMOS settings of the server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply