August 2007 - Posts

• DMV Progress and Upcoming Events (PASS/Devlink)

  If you have noticed my series of posts on the DMV's on http://sqlblog.com/blogs/louis_davidson , you may have wondered why these posts are coming so slowly. I mean, if I am actually going to get a book of all of them, with examples, done in a couple of Read More... Posted Sunday, August 26, 2007 4:52 PM by drsql | 2 Comments

• sys.dm_db_index_operational_stats

  This object provides very useful stats on how many times an index has been used, locked, waited on, etc. An index in this context can mean several things: a clustered index, heap, index, or a partition of either of these. The grain of the function is Read More... Posted Sunday, August 26, 2007 4:12 PM by drsql | 8 Comments Filed under: Dynamic Management Objects, SQL Server, T-SQL

• sys.dm_exec_query_optimizer_info

  Information about how queries have been optimized since the server has been restarted. Note that counters are only affected when there is some sort of optimization event, not on every query. (reference: http://sqlserver-qa.net/blogs/perftune/archive/2007/05/11/get-statistics-on-query-plan-optimizer-execution.aspx Read More... Posted Monday, August 06, 2007 8:40 PM by drsql | 3 Comments Filed under: Dynamic Management Objects, SQL Server, T-SQL