SQL Snippets

บทความ
11/04/2005

“Best of SQL 2005 Launch” - Event Resources

I want to thank my buddy Kevin Remde https://blogs.technet.com/kevinremde/default.aspx for putting together the below list of useful support links for everybody out there getting ramped up on SQL 2005! I'll be in Syracuse and Buffalo next week with our Best of SQL Launch Content--register at www.technetevents.com.

There are some very useful resources available from Microsoft that you can exploit to make the most of the most powerful, integrated and facile Database Application to ever come out of Redmond and, dare I say, most cost effective in the world. For independent performance testing results see The Transaction Processing Performance Council's results at https://www.tpc.org/tpcc/results/tpcc_price_perf_results.asp.

According to the TCP, congratulations are in order to Dell for being the first to beat the $1 per tpmC threshold for TPC-C price/performance. Dell published a result of 38,622 tpmC with a price/performance of 0.99 $/tpmC. Dell used SQL Server 2005 x64 Standard Edition running on an Intel dual-core Xeon CPU (Paxville). This highlights both Yukon performance and the TCO advantage of our dual-core pricing model. The best results from Oracle and DB2 are 1.81 and 1.61 $/tpmC, respectively.

HP brought out five results which show the power of Yukon on AMD Opteron. Running Yukon x64 on a 4P Opteron 2.4GHz dual-core with 128GB memory, HP delivered 202,551 tpmC with a price/performance of 2.40 $/tpmC – setting a new all-time record for 4P performance. Compared to the next best 4P (IBM’s eServer p5 570 running on POWER5 CPUs which got 197,669 at 3.93 $/tpmC), SQL Server+Windows+HP+AMD beats DB2+AIX+IBM+POWER5 by 2% on perf at a price/perf that is 39% lower. Yukon processor licensing (per proc instead of per core) plays a big part in the price advantage. HP also published a 2P Opteron 2.4GHz dual-core result, showing 109,633 tpmC with 2.73 $/tpmC, and setting a new all-time record for 2P performance.

A third result was run on HP’s blade system, using a 2P Opteron 2.4GHz dual-core blade for the database server. The result is noteworthy because the database server and application servers where all blades contained in the same enclosure. HP is the only blade vendor so far to publish TPC-C results.

Finally, HP published results on 2P and 4P Opteron 2.8GHz (single-core) systems. The 2P would have set a new all-time perf record, except for the dual-core results mentioned above.

Future Live, In-Person Event Information

TechNet: https://www.TechnetEvens.com

MSDN: https://www.MSDNEvents.com

Microsoft Across America: https://www.microsoft.com/acrossamerica

TechNet Events Bloggers - https://techneteventsbloggers.net
(Add your blog, or subscribe to IT Pro focused blog postings)

Microsoft Learning - Training Resources
https://www.microsoft.com/learning
https://www.microsoft.com/learning/books/ITPro

Microsoft TechNet
https://www.microsoft.com/technet

SQL Server 2005 Upgrade Session Resources:
https://www.microsoft.com/technet/SQL-10

Introducing SQL Server 2005: https://www.microsoft.com/sql/2005/

Product Overview
https://www.microsoft.com/sql/2005/productinfo/overview_1.asp

Top 30 Features
https://www.microsoft.com/sql/2005/productinfo/top30features.asp

SQL 2005 Feature Comparison by Edition
https://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx