THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » performance » Hardware   (RSS)
Showing page 2 of 3 (22 total posts)
  • Big-Iron Revival II, Nehalem-EX and Windows Server 2008 R2

    At Intel Developer Forum 2009 last week, Microsoft disclosed significant advances in Windows Server 2008 R2 with the elimination of many locks, most prominently the Dispatch Scheduler lock, that impact the ability scale performance up to and beyond 64 cores. Look for the presentation: Microsoft & Intel Innovations in Hardware and Software to ...
    Posted to Joe Chang (Weblog) by jchang on September 27, 2009
  • Benchmark Omissions for the Six-Core Intel Xeon AMD Opteron Processors

    To date, no 4-way or 8-way TPC-H data warehouse benchmark result has been published for the six-core Xeon X7460 and no TPC-C or TPC-E OLTP benchmark result has been published for six-core Opteron. Usually, the absence of published results means the results are not competitive, in one manner or another. TPC-C, E and H results were published for ...
    Posted to Joe Chang (Weblog) by jchang on September 13, 2009
  • Why have we not seen TPC-C and TPC-E benchmarks using SSD storage?

    Dell recently published a TPC-H report for the PowerEdge T610, 2 x Xeon 5570, with 4 FusionIO 80GB SSD storage devices at 100GB scale factor. So why have we not seen TPC-C or TPC-E OLTP benchmark results published?   Now it is much more feasible to run the TPC-H data warehouse benchmark on SSD because the Scale Factor 100 size is ...
    Posted to Joe Chang (Weblog) by jchang on July 1, 2009
  • First Nehalem TPC-H

    Earlier I talked about the first TPC-C and TPC-E results for 2-way Nehalem, ie, the Intel Xeon 5500 series. The results were spectacular relative to the previous generation Xeon 5400 series, (2.5X gain on the Intel slide deck for database OLTP) and were pretty much hitting the same range as 4-way Xeon 7460. I pointed out ...
    Posted to Joe Chang (Weblog) by jchang on June 3, 2009
  • Big Iron Revival, Intel Nehalem EX and AMD Magny-Cours

    Yesterday Intel held a product announcement press event for the upcoming Nehalem EX, which will succeed the current Xeon 7400 series based on the Core 2 micro-architecture for ''expandable system'', i.e., 4-way and higher, in late 2009 or early 2010. The current Xeon 5500 series (also Nehalem architecture) has 4 cores, 8M shared L3, 2 QPI links, ...
    Posted to Joe Chang (Weblog) by jchang on May 27, 2009
  • Early Intel Nehalem Xeon 5500 performance results

    SAP numbers were available a few months ago, and now, TPC-C and TPC-E results are available for 2-socket Intel Xeon 5570 systems with the Nehalem quad-core processor. The TPC-C result is on Oracle/Linux, no SQL Server on Windows yet. The TPC-E results are all SQL Server 2008. I mentioned before that my expectations was that Nehalem would generate ...
    Posted to Joe Chang (Weblog) by jchang on April 1, 2009
  • Table Scan - Aggregate Cost Structure

    In the previous post, I mention that in an earlier post on IO cost structure, that the cost of a table scan was approximately 1 CPU-micro sec per page, plus approximately 0.05 us per row for just a SELECT COUNT(*) This was calibrated on a 2-way Xeon 5430 Quad-Core 2.66GHz. I should also add that the test tables have a clustered primary key, with ...
    Posted to Joe Chang (Weblog) by jchang on February 27, 2009
  • Nehalem, Shanghai, and Dunnington performance notes

    Back in March 2008, I discussed the SAP SD 2 Tier results for some AMD Opteron and Intel Xeon systems. Here are some more recent results. All Opteron and Xeon processors below are on the 45nm process except for the Opteron 8360, which is a 65nm product. For some reason, HP has not posted a 4-socket result for the 45nm Opteron 8384, where the ...
    Posted to Joe Chang (Weblog) by jchang on February 23, 2009
  • Early TPC-C and H reports for Shanghai relative to Barcelona and Dunnington

    Below are the first performance numbers for the new AMD 45nm Opteron (Shanghai) relative to other recent AMD and Intel Xeon results. 4-way TPC-C Opteron 8360 Quad-core 2.5GHz (Barcelona) 2M L3, 471,883 (DL585G2) Opteron 8384 Quad-core 2.7GHz (Shanghai) 6M L3, 579,814 (DL585G2) Xeon 7350 Quad-core 2.93GHz (Tigerton) 2x4M L2, 407,079 ...
    Posted to Joe Chang (Weblog) by jchang on November 19, 2008
  • Dell PERC6 RAID Controller Performance

    Last month, Scott pointed out the really bad performance characteristics of the Dell PERC6 in RAID0 sequential write, particularly compared with RAID-5. Granted, this is not necessarily a red flag because few people use RAID 0 in production. Still, if one can't write code or test correctly, one should not be in the hardware/firmware business. Dell ...
    Posted to Joe Chang (Weblog) by jchang on October 1, 2008
Privacy Statement