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 » Performance » indexes » 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement