THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Query Tuning » DMV   (RSS)
  • 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 explained that dm_exec_query_stats is not a replacement for SQL Server Profiler and SQL Trace. ...
    Posted to Joe Chang (Weblog) by jchang on June 22, 2009
  • 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 that detailed logical IO was already collected supported this. So why would logical IO be ...
    Posted to Joe Chang (Weblog) by jchang on September 10, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement