Malaysia Forum | Technology  | Property | Web Hosting & Domain | Online Marketing forum

 Register with Mamakcafe
!search!  Free Website Builder dear user, mamakcafe is a free service, please do not be provocative and offensive to others user. if user are found to be offensive, it will be removed from the system and permenently banned
!show!: 2220|!reply!: 0

CPU Performance









Rank: 9Rank: 9Rank: 9

Medal No.2

!poston!: 7-5-2009 08:13 AM
I'm just so interested about how my CPU react when I just simplified put a software in it.

I had found a few interested web site and explanation about its improvement.

  • Context switching: This occurs when threads are switched between CPUs in your SQL Server, and excessive context switching eats up CPU resources. In some cases, context switching can be reduced by turning on Lightweight Pooling. See this website for more details on this option.

  • Recompilation: Excessive SP recompilation wastes CPU resources and slows SQL Server. See this website for ways to reduce SP recompilation.

  • Sorting: At some point, data may have be be sorted. But to reduce the load sorting can have on SQL Server, only sort the minimum amount of data that needs to be sorted, or consider pushing off the sorting function onto the client.

  • Hashing: Hashing often occurs when JOINs are used. They are also used in UNIONs. Often, but not always, a HASH JOIN can be modified so that is runs as a LOOP JOIN instead, which reduces CPU activity and speeds performance. See this website for more details on LOOP JOINs.


!thread_magic! !report!

RM5.99 Malaysia Domain names with FREE Hosting @

Mobile version| Archiver| a Malaysia Forum | Technology | Property | Web Hosting & Domain | Online Marketing forum , hosted on

!time_now! , Processed in 0.178922 sec., 22 queries .

Powered by Discuz! X2.5

Release 20121101, © 2001-2019 Comsenz Inc.

MultiLingual version, Rev. 85, © 2009-2019