Threading affects performance?
2 January 2006 Kamran Khan Uncategorized, 4
This post was viewed (17) times.
IT Consultancy Is the picture appropriate?
4 thoughts on “Threading affects performance?”
Leave a Reply Cancel reply
Registered Users
Categories
- Announcement (1)
- Announcements (4)
- Application Server (7)
- Apache Tomcat (2)
- EA Server (4)
- IIS 6.0 -7.5 (2)
- Jaguar Server (1)
- JBoss (1)
- Artificial Intelligence (2)
- Browsers (1)
- Buy / Sell (5)
- Chemistry (1)
- Circles (1)
- Databases (11)
- MSSQL 2000 (2)
- MSSQL 2005 (2)
- MSSQL 2008 (2)
- MySQL 4.x and 5.x (1)
- Optimization of Query/SP/DB (10)
- Oracle 10G (1)
- Oracle 11G (1)
- Oracle 9i (1)
- Domains Sales (2)
- Front End Dev. (3)
- Java (3)
- Human Capital Division (5)
- Internet (8)
- NEC – NetSol Entertainment Committee (1)
- New Launch (10)
- Parenting (1)
- Philosophy (2)
- Physics (4)
- Platforms (1)
- Ubuntu / Linux (1)
- Quality Management System (1)
- Restaurants (2)
- Search Engine (1)
- Social Media (4)
- SQA (11)
- Audits (1)
- LoadRunner (9)
- Neo Load (1)
- QTP – QuickTest Professional (1)
- Test Automation (Concepts) (1)
- Testing Techniquies / Approaches (1)
- WCF Storm (2)
- winRunner (1)
- Technology (1)
- Test (1)
- Theology (1)
- Travelling the Globe (3)
- Travel China (1)
- Travel Malaysia (1)
- Travel Pakistan (1)
- Uncategorized (28)
- Weekend Read (11)
- Whitebox Testing (1)
Archives
- December 2022 (1)
- March 2020 (1)
- December 2017 (1)
- March 2015 (1)
- October 2014 (1)
- March 2014 (1)
- December 2012 (16)
- October 2012 (16)
- September 2012 (12)
- August 2012 (8)
- July 2012 (13)
- June 2012 (4)
- May 2012 (3)
- April 2012 (3)
- September 2011 (2)
- November 2009 (1)
- October 2009 (1)
- January 2009 (1)
- June 2008 (1)
- December 2007 (2)
- June 2007 (1)
- December 2006 (1)
- November 2006 (1)
- October 2006 (1)
- August 2006 (1)
- June 2006 (1)
- May 2006 (1)
- April 2006 (1)
- March 2006 (3)
- February 2006 (1)
- January 2006 (5)
- December 2005 (1)
- November 2005 (1)
- October 2005 (3)
- August 2005 (1)
- June 2005 (4)
- May 2005 (6)
- March 2005 (1)
Categories
Announcement
Announcements
Apache Tomcat
Application Server
Browsers
Buy / Sell
By External Speakers
Chemistry
Circles
Databases
Domains Sales
EA Server
Front End Dev.
IIS 6.0 -7.5
Internet
Jaguar Server
Java
JBoss
LoadRunner
Mc Cabe
MSSQL 2000
MSSQL 2005
MSSQL 2008
N Cover
NEC - NetSol Entertainment Committee
New Launch
Optimization of Query/SP/DB
Oracle 9i
Oracle 10G
Oracle 11G
Parenting
Physics
Platforms
Quality Management System
Restaurants
Social Media
Soft Skills for Tech Gurus
SQA
Travel Pakistan
Ubuntu / Linux
Uncategorized
WCF Storm
Weekend Read
winRunner
Work, Life and Personal Finances
Threading affects performance ?
Hey friends,
How a Hyper threaded processor can affect the performance of the SQL Server ? It is a hot issue for Microsoft.
What is hyper threading? I have heard of it. Let me tell you what I know. Its a process by which with one microprocessor itself we can simulate two or more microprocessor i.e we can process two threads simultaneously.
But I have also heard that this leaves a huge vulnerability in the system. It actually allows the threads of one virtual processor to interact with the other virtual processor thus causing systems to crash.
@Joe
Yes, Joe you are quite right but plz mind to this also,
Slava Oks, one of the SQL Server developers had a theory on why hyperthreading can be deterimental to performance. What item is part of his theory why hyperthreading can slowdown performance.
So the answer is Lazywriter impacting L1 and L2 cache
Explanation
His theory was that the lazywriter would kick in and scan large blocks of memory. This results in lots of L1 and L2 cache reads. Since the hyperthreaded processors share L1 and L2 cache, this can quickly disrupt the caches and result in L1 and L2 misses for the worker threads. And potentially problems in acquiring spinlocks.
Ref: To Hyper or Not to Hyper – http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
Interesting. This only talks about databases. Can any other applications be affected by hyperthreading?
And one more doubt. Right now, who all are using hyperthreading? I mean the machines.