June 2009 - Posts

• Automating dm_exec_query_stats and dm_db_index_usage_stats analysis

  Everyone should know by now how really useful the DMVs dm_exec_query_stats, and dm_db_index_usage_stats and the associated DMFs for obtaining the SQL and XML plan: dm_exec_sql_text, dm_exec_query_plan, and dm_exec_text_query_plan. Of course it has been Read More... Posted Monday, June 22, 2009 1:25 AM by jchang | 1 Comments Filed under: DMV, indexes, Performance, Query Tuning

• HP Oracle 10X Extreme Performance Data Warehouse with Exadata Storage Server

  For several months, we have seen ads for the joint HP/Oracle RAC and Exadata storage combination talking about extreme performance (10X faster) for large data warehouses. One thing I like about Oracle is that they have courage to pursue technology with Read More... Posted Tuesday, June 09, 2009 8:26 PM by jchang | 2 Comments Filed under: Exadata, Oracle RAC, Performance, Scaling, Storage

• Microsoft's-Thinking Oracle RAC Think Again Whitepaper

  Now that I have actually kind of read this paper, I will comment on it. I say kind of because I cannot focus on non-technical matters, the same way I get really frustrated trying to explain something to a person that just cannot understand the difference Read More... Posted Friday, June 05, 2009 10:36 AM by jchang | 5 Comments Filed under: Oracle RAC

• 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 Read More... Posted Wednesday, June 03, 2009 4:55 PM by jchang | 2 Comments Filed under: Hardware, Performance, Scalability