| | |

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

 Forgot password?
 Register with Mamakcafe
Search
BigDomain.my  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
View: 2325|Reply: 0

CPU Performance

[Copy link]

0

Threads

0

Friends

473

Money

Administrator

Rank: 9Rank: 9Rank: 9

Medal No.2

Post time: 7-5-2009 08:13 AM
|Show all posts
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.


Reply

Use magic Report

RM5.99 Malaysia Domain names with FREE Hosting @ bigdomain.my

Mobile| Archive| Mamakcafe.com a Malaysia Forum | Technology | Property | Web Hosting & Domain | Online Marketing forum , hosted on Bigdomain.my

19-7-2019 06:15 PM GMT+8 , Processed in 0.110979 sec., 22 queries .

Powered by Discuz! X2.5

Release 20121101, © 2001-2019 Comsenz Inc.

MultiLingual version, Rev. 85, © 2009-2019 codersclub.org

To Top