SQL SERVER 2000 Standard and 2 QUAD Processors

Question

SQL SERVER 2000 Standard and 2 QUAD Processors

jbrewer

Default port

Points: 1453
More actions
November 14, 2007 at 5:03 am

#76817

I have a server with Windows 2003 Standard and will have SQL Server 2000 Standard Edition. It has 4 gb of ram and 2 quad processors hyperthreaded so the server sees 16 processors. I know that SQL Server standard edition will only use 2 gb of ram and 4 physical processors. I have not work with a sever before with quad processors. Since there are 2 does it see only 4 processors or does it see all 8 since it is 2 quad processors. I appreciate any help you can give me because I have searched the internet and not found the answer. I am trying to find the person that ordered this configuration to find out why it was ordered this way.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

I believe the SQL 2000 standard sees 2 CPU sockets, but the architecture will spread the SQL 2000 threads on 8 cores. I'll ask around and see.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

I got some conflicting ideas from people at MS. Someone was going to try and dig in (and blog) on this, but they've been out of the 2000 code for so long.

Don't use hyperthreading, no matter what. Everyone agrees there.

They seem to think that there will be 8 schedulers runnings (Which handle the internal SQL threads), but I don't have confirmation.

jbrewer Default port Points: 1453 More actions · Answer 3

Thank you very much for your help. I did not know there was a problem with hyperthreading. Can you point me to a document concerning hyperthreading and SQL Server 2000 that I send to the IS Director?

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 4

jbrewer (11/29/2007)
Thank you very much for your help. I did not know there was a problem with hyperthreading. Can you point me to a document concerning hyperthreading and SQL Server 2000 that I send to the IS Director?

Yeah - just tell him TheSQLGuru said don't do it! 😀

Or you can search the web for hyperthreading sql server performance and wade through the many returns you will get.

If SQL 2000 standard cannot access all 8 cores you have, I would consider using affinity mask and pick an even number of cores on each CPU that it can access. that will ensure the load is spread around as efficiently as possible.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service