Question of the Day Eleven
What is a DMV (and will there be a long line there)?
DMVs are Dynamic Management Views and you will hear them tossed around alot. DMVs are an amazing tool introduced in SQL 2005 to replace querying system tables in SQL Server 2000. However, they give you a plethora of internal information for troubleshooting purposes. Want more information? Check out the MSDN reference page for a full listing and categorization of DMVs.