July 2007 - Posts

• sys.dm_io_virtual_file_stats

  Excellent dmv that shows, for each file that SQL Server uses for the databases, stats on how frequently the file has been used by the database. This is one of the primary dynamic management views I use almost daily (well, not usually when I am on vacation, Read More... Posted Friday, July 27, 2007 9:26 PM by drsql | 5 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_db_index_usage_stats

  This object gives statistics on how an index has been used to resolve queries. Most importantly it tells you the number of times a query was used to find a single row ( user_seeks ), a range of values, or to resolve a non-unique query ( user_scans ), Read More... Posted Sunday, July 22, 2007 10:45 PM by drsql | 5 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_db_file_space_usage

  Give space usage of objects in tempdb (most likely this will be extended to more than just tempdb in a future edition of SQL Server.) Can be used to see how and why space is being used in Tempdb, on a file by file basis. Type: View Data: temporal, reflects Read More... Posted Saturday, July 14, 2007 3:35 PM by drsql | 3 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_db_partition_stats

  For the current database, gives you space oriented statistics for each partition of indexes (even if you only have one partion), like row count, page counts, etc. Resembles the sysindexes in previous versions of SQL Server, with more information. Type: Read More... Posted Wednesday, July 11, 2007 9:41 PM by drsql | 4 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• Blogging the DMV's

  Well, I am working on a project that is going to be a book on dynamic management views (and functions, but DMF is an interesting acronym, and objects, as in DMO, has a well known other meaning. What I will post will be one object in the following format: Read More... Posted Tuesday, July 10, 2007 12:14 AM by drsql | 4 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects