- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- ProLiant Servers (ML,DL,SL)
- >
- XEON HyperThreading Vs. MSSQL Enterprise
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-24-2003 02:08 PM
тАО03-24-2003 02:08 PM
Installed: MSSQL Enterprise Edition (25 CAL) on Win2k Advanced Server (8 CPU/25 CAL).
Due to HyperThreading, Win2k sees four processors instead of two.
When under load MSSQL causes ONE of the processor graphs to show more activity than the others in Task Manager -> Performance tab.
Question:
a.
Is MSSQL running at its peak processor performance, even though it "appears" that it is only using half a processor?
b.
Would it behoove me to disable HyperThreading?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-24-2003 08:07 PM
тАО03-24-2003 08:07 PM
Re: XEON HyperThreading Vs. MSSQL Enterprise
Yes you can disable HyperThreading by going into system properties(F9) and then go to advanced options/features. Highlight the HyperThreading and hit enter. Here you will see Enable/Disable.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 03:22 AM
тАО03-25-2003 03:22 AM
SolutionDid you configure MSSQL to make use of all processors? (Start menu-Enterprise Manager-right click on your server-properties-CPU)
b.
According to Intel, W2K does not (yet) support Hyperthreading, i.e. W2K does not know that the extra processors are not "real". Intel recommends disabling Hyperthreading when using W2K. So far, only Win XP supports Hyperthreading:
http://www.intel.com/support/platform/ht/os.htm
There's another thread around here (read it yesterday) with a link to a Microsoft whitepaper about Hyperthreading.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 09:55 AM
тАО03-25-2003 09:55 AM
Re: XEON HyperThreading Vs. MSSQL Enterprise
Jens:
a.) Yes. CPU0 through 3 are enabled. Which is part of my puzzlement. Why am I seeing only one "processor" loaded? *shrugs*
b. Yes. I'm now researching the effects of disabling it so that I can run some performance benchmarks. My concern is that Win2k A.S. and SQL both think they were installed on a "four processor" system.
Do you perchance remember the subject of the thread you saw the whitepaper link in? I must've missed it. I've performed searches on MSDN, the MSSQL K-base, Win2k K-base, etc, but haven't found anything really relevant.
Thanks for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 11:34 PM
тАО03-25-2003 11:34 PM
Re: XEON HyperThreading Vs. MSSQL Enterprise
http://www.microsoft.com/windows2000/docs/hyperthreading.doc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 11:11 AM
тАО03-26-2003 11:11 AM