Browse by Tags

• DMV
• indexes
• Performance

• 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 | 2 Comments Filed under: Performance, Query Tuning, DMV, indexes

• Why Logical IO is a poor performance metric

  Many years ago, I attended a conference where a very highly respected Oracle performance expert advocated the use of logical IO count as a performance metric. The argument was that a logical IO is a fairly substantial operation relative to others. I suppose Read More... Posted Wednesday, September 10, 2008 1:08 PM by jchang | 35 Comments Filed under: Performance, Query Tuning, DMV