HyperThreading and SQL Server 2005

I recently installed SQL Sever 2005 (with SP1) on a server that is P4 3.0 GHz and does hyperthreading. After the installation SQL Server seems to take up 99% of all of the CPU. this was uncanny!

I searched the net and came up with this:

http://blogs.msdn.com/slavao/archive/2005/11/12/492110.aspx

This is Slava Oks's WebLog where he explains whether to do hythreading or not with the SQL Server 2005.

Comments

Post a Comment

Popular posts from this blog

Community Star Discussions and Future

In my continuing discussion with Community Stars across the country, I had a discussion today with Sadashiv. Though he works out of chennai and was here for a short trip, he found time today to discuss the opportunities for Community Star program to improve on. Some of thoughts we generated out of the discussion are as follows: 1. Community Stars are disengaged 'cause of lack of communication with them from MS. Better communication channels need to be developed. 2. Award experience and delivery of the Community Star benefits leave a lot to be desired. 3. Community Stars feel that MS is not laying enough importance on Community Stars and do not value their contributions much. More information needs to flow to CSs. From our end, we are doing the following: 1. Launch an extranet portal exclusively for Community Stars. We will host issue submission on this site. Also, we will share opportunities via this site e.g. beta opportunities 2. Re-launch the Community Star distributi...
Read more

Notes from an Internet Marketing Seminar

These are my notes from an internet marketing seminar I attended. Read through to see if you can figure out who delivered this and i promise you would be surprised :) Topic: Web & New Media: Emerging Trends 183 bn emails sent a day 49 mn internet users in India 7.5 hrs spent on internet/ week (18-35 Males) 1.2 bn searches / month- search increasing at 80% 80% online shop Online Time Spent in India: 23% – TV 30% Internet 26% Print 21 % Radio Advertising Money Spent: 41% TV 1% Internet 40% Print 12% Radio 1.4 bn online out of 6.6 bn in the world mobile is the next huge thing... computing cloud is the current stage after PC being personal era.. web is not US centric.. 211 still the largest.. inspite of the company being so "open source".. the presentation consistently says Confidential & PROPRIETARY .. paradoxical.. the presentation laptop from google is running Windows XP.. sweet.. and oh! the presenta...
Read more

Solving the multi-platform challenge in mobile devices

Image
The writing is on the wall is clear with mobile devices becoming mainstream business devices. In addition to the current workhorse – the PC, consumers and businesses are adopting internet connected smartphones and tablets in record numbers. The path for mobile device enablement for businesses is fragmented and full of challenging decisions. This starts from mobile application landscape being multi-platform and multi-resolution. While Android uses Java, iOS uses Objective-C, Windows Phones use .NET. Natively hitting all of these environments requires one to build multiple versions of an app and to learn multiple technology platforms. New challenges also open up with the client devices in deliver visualizations and touch enablement. How to work with multi-platform challenge Fortunately there exists a solution to this madness in HTML 5. This stack takes advantage of browser based technologies and hence can run on all of the major mobile platforms as well as desktop platforms. However, th...
Read more