Browse by Tags

• 64-bit
• Benchmarks
• cost based optimizer
• Data Warehouse
• DMV
• Exadata
• execution plans
• Hardware
• indexes
• internals
• Opteron
• Optimizer
• Oracle RAC
• Query Hints
• Query Tuning
• RAID Controllers
• Reporting Services
• Scalability
• Scaling
• Sizing
• SSD
• Storage
• tools
• Xeon

• Storage Performance

  Storage has changed dramatically over the last three years driven by SSD developments. Most of the key components necessary for a powerful storage system are available and the cost is highly favorable for direct placement of data files. Some additional Read More... Posted Monday, March 25, 2013 12:52 AM by jchang | 13 Comments Filed under: Performance, Storage, Hardware

• TPC-H Benchmarks - Westmere-EX versus RISC

  There has been relatively litle activity in TPC Benchmarks recently with the exception of the raft of Dell TPC-H results with Exa Solutions. It could be that systems today are so powerful that few people feel the need for benchmarks. IBM published an Read More... Posted Monday, October 10, 2011 5:03 PM by jchang | 5 Comments Filed under: Performance, Hardware, Benchmarks

• Consumer SSDs with SQL Server

  Over the last two years, I have stood up several proof-of-concept (POC) database server systems with consumer grade SSD storage at cost $2-4K per TB. Of course production servers are on enterprise class SSD, Fusion-IO and others, typically $25K+ per TB. Read More... Posted Saturday, September 17, 2011 12:21 AM by jchang | 8 Comments Filed under: Performance, Storage, SSD

• IBM System x3850 X5 TPC-H Benchmark

  IBM just published a TPC-H SF 1000 result for their x3850 X5 , 4-way Xeon 7560 system featuring a special MAX5 memory expansion board to support 1.5TB memory. In Dec 2010, IBM also published a TPC-H SF1000 for their Power 780 system, 8-way, quad-core, Read More... Posted Friday, March 04, 2011 5:04 PM by jchang | 0 Comments Filed under: Performance, Hardware, Benchmarks

• Caching RAID Controller Performance Tuning Secrets (cough-giggle)

  Over weekend I was looking at various RAID controller documents to update my material on storage performance, and I came across three items that were good for a hoot. Direct IO, not Cached IO The LSI slidedeck MegaRAID Performance Tuning and Benchmark Read More... Posted Monday, October 11, 2010 9:07 PM by jchang | 4 Comments Filed under: Performance, Storage, RAID Controllers

• Benchmark Update - Astounding Fujitsu RX900 8-way Xeon 7560 TPC-E Scaling

  Fujitsu just published an astounding TPC-E benchmark result of 3,800 tpsE for their 8-way Xeon 7560 system, the Primergy RX900 S1. Fujitsu had previously published a TPC-E result of 2046.96 for their 4-way Xeon 7560 system, the Primergy RX600 S5. The Read More... Posted Tuesday, September 28, 2010 6:13 PM by jchang | 13 Comments Filed under: Performance, Hardware, Benchmarks

• NEC Express5800 A1080a

  NEC announced their 8-way server with Intel's Xeon 7500 launch on 30 March 2010, along with a published TPC-E performance benchmark result. The listed availability date was 24 June 2010, so the 5800/A1080a should now be available, although I have not Read More... Posted Monday, June 28, 2010 11:36 AM by jchang | 0 Comments Filed under: Performance, Hardware

• New HP ProLiant DL980, 580 and 585 G7 servers

  HP has just announced the ProLiant DL580 G7 and DL980 G7 servers based on the Xeon 7500 series processors, and the DL585 G7 4-way server with the 12-core AMD Opteron 6100 series (Magny-Cours). Apparently the reason for the delay is that the 8-way DL980 Read More... Posted Wednesday, June 23, 2010 11:03 AM by jchang | 2 Comments Filed under: Performance, Hardware

• Intel Xeon 5600 (Westmere-EP) and AMD Magny-Cours Performance Update

  HP has just released TPC-C and TPC-E results for the ProLiant DL380G7 with 2 Xeon 5680 3.33GHz 6-core processor, allowing a direct comparison with their DL385G7 with 2 Opteron 6176 2.3GHz 12-core processors. Last month I complained about the lack of performance Read More... Posted Wednesday, May 12, 2010 10:29 AM by jchang | 7 Comments Filed under: Performance, Hardware

• 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 Read More... Posted Sunday, September 27, 2009 7:39 PM by jchang | 4 Comments Filed under: Performance, Hardware, Scalability

• HP Storage Works 2000 sa and fc G2 performance specs

  While reading through the documentation for the HP Storage Works 2000 MSA, I found the following performance numbers cited in the quickspecs for both the FC and SAS versions. The 2000fc version cited performance numbers for the fc (Fiber Channel), sa Read More... Posted Monday, September 14, 2009 3:38 PM by jchang | 6 Comments Filed under: Performance, Storage

• 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 Read More... Posted Sunday, September 13, 2009 5:23 PM by jchang | 0 Comments Filed under: Performance, Hardware, Scalability, Opteron, Xeon

• Solid State Drive versus Memory, TPC-H Nehalem

  A recently published TPC-H benchmark result, along with previously published results provide some insight into to the relative impact of SSD to disk drives, and SSD versus system memory. The TPC-H configurations are shown below. All results are at SF Read More... Posted Wednesday, August 12, 2009 1:06 AM by jchang | 9 Comments Filed under: Performance, Storage, SSD

• Automating Query Exec, Index Usage and Execution Plans, Update 2

  I have made updates to my tool for automating SQL Server query exec stats, index usage, execution plan analysis. So I would like people to give it a try and send feedback. If there is an error, please report the file and line number (the top level is Read More... Posted Monday, July 13, 2009 8:18 PM by jchang | 9 Comments Filed under: Performance, tools, execution plans

• 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 Read More... Posted Wednesday, July 01, 2009 1:48 PM by jchang | 8 Comments Filed under: Performance, Hardware, SSD